mysql-test/suite/perfschema_stress/r/work.result
raw| 1 | SET @rowid = ROUND(RAND() * <num_stress_rows>); |
| 2 | START TRANSACTION; |
| 3 | UPDATE t1 SET b = 'changed' WHERE id=@rowid; |
| 4 | SELECT b FROM t1 WHERE id=@rowid; |
| 5 | b |
| 6 | changed |
| 7 | COMMIT; |
| 8 | START TRANSACTION; |
| 9 | DELETE FROM t1 WHERE id=@rowid; |
| 10 | INSERT INTO t1 (id, b) VALUES (@rowid, 'newly_inserted'); |
| 11 | SELECT b FROM t1 WHERE id=@rowid; |
| 12 | b |
| 13 | newly_inserted |
| 14 | COMMIT; |
| 15 | CREATE TABLE tw_<conn_nr> AS SELECT * FROM t1; |
| 16 | DROP TABLE tw_<conn_nr>; |