1--source include/not_embedded.inc 2--source suite/perfschema_stress/include/settings.inc 3 4let $have_table= `SELECT COUNT(*) FROM INFORMATION_SCHEMA.TABLES 5 WHERE TABLE_SCHEMA='test' AND TABLE_NAME='t1'`; 6 7if (!$have_table) { 8 --source suite/perfschema_stress/t/setup.test 9} 10 11--replace_result $num_stress_rows <num_stress_rows> 12eval SET @rowid = ROUND(RAND() * $num_stress_rows); 13 14let $conn_id= `SELECT CONNECTION_ID()`; 15let $conn_nr= conn_$conn_id; 16 17START TRANSACTION; 18UPDATE t1 SET b = 'changed' WHERE id=@rowid; 19SELECT b FROM t1 WHERE id=@rowid; 20COMMIT; 21 22START TRANSACTION; 23DELETE FROM t1 WHERE id=@rowid; 24INSERT INTO t1 (id, b) VALUES (@rowid, 'newly_inserted'); 25SELECT b FROM t1 WHERE id=@rowid; 26COMMIT; 27 28--replace_result $conn_nr <conn_nr> 29eval CREATE TABLE tw_$conn_nr AS SELECT * FROM t1; 30 31--replace_result $conn_nr <conn_nr> 32eval DROP TABLE tw_$conn_nr; 33