dble
dble copied to clipboard
`lock table read`, then select on unlocked table, transaction will be rollback
Raised by: @FlyingMao Steps:
-
lock table sbtest1 read;
-
select * from sbtest2;
-
select * from sbtest2;
-
unlock tables;
-
select * from sbtest2;
Returns:Error 1105(HY000):MySQL Error Packet{Length=56,id=1}
Analysis: Data-node general log shows there is a rollback after first select.