mysql-test/suite/engines/rr_trx/t/rr_s_select-uncommitted.test
raw| 1 | ################################################################################ |
| 2 | # |
| 3 | # No uncommitted changes should be visible to a REPEATABLE-READ transaction |
| 4 | # |
| 5 | ################################################################################ |
| 6 | |
| 7 | SET autocommit = 0; |
| 8 | START TRANSACTION; |
| 9 | |
| 10 | --error 0, ER_LOCK_DEADLOCK, ER_LOCK_WAIT_TIMEOUT |
| 11 | SELECT * FROM t1 WHERE `is_uncommitted` > 0; |
| 12 | |
| 13 | COMMIT; |