Debian Codegraph @

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>;