SET autocommit = 0; START TRANSACTION; SET @conn_id = CONNECTION_ID(), @thread_id = 0; UPDATE t1 SET `int1` = `int1` - 4, `id` = 4, `is_consistent` = 0, `connection_id` = @conn_id, `thread_id` = @thread_id WHERE `pk` = 4; *** UPDATEing row with pk = 4 and `int1_key` +=4 if above statement succeeded (query log disabled)... COMMIT;
| Name | Type | Size | Permission | Actions |
|---|---|---|---|---|
| init_innodb.result | File | 2.12 KB | 0644 |
|
| rr_c_count_not_zero.result | File | 264 B | 0644 |
|
| rr_c_stats.result | File | 38 B | 0644 |
|
| rr_i_40-44.result | File | 2.12 KB | 0644 |
|
| rr_id_3.result | File | 147 B | 0644 |
|
| rr_id_900.result | File | 1 KB | 0644 |
|
| rr_insert_select_2.result | File | 745 B | 0644 |
|
| rr_iud_rollback-multi-50.result | File | 555 B | 0644 |
|
| rr_replace_7-8.result | File | 1.08 KB | 0644 |
|
| rr_s_select-uncommitted.result | File | 224 B | 0644 |
|
| rr_sc_select-limit-nolimit_4.result | File | 4.65 KB | 0644 |
|
| rr_sc_select-same_2.result | File | 1.56 KB | 0644 |
|
| rr_sc_sum_total.result | File | 141 B | 0644 |
|
| rr_u_10-19.result | File | 5.52 KB | 0644 |
|
| rr_u_10-19_nolimit.result | File | 5.48 KB | 0644 |
|
| rr_u_4.result | File | 333 B | 0644 |
|