[tomato.git] / release / src / router / mysql / mysql-test / suite / engines / rr_trx / r / rr_u_4.result
| blob | cda558e682f5a551b7522a3d0e23a55711e4b0e9 |
1 SET autocommit = 0;
2 START TRANSACTION;
3 SET @conn_id = CONNECTION_ID(), @thread_id = 0;
4 UPDATE t1 SET `int1` = `int1` - 4,
5 `id` = 4,
6 `is_consistent` = 0,
7 `connection_id` = @conn_id,
8 `thread_id` = @thread_id
9 WHERE `pk` = 4;
10 *** UPDATEing row with pk = 4 and `int1_key` +=4 if above statement succeeded (query log disabled)...
11 COMMIT;