Edit File: work.test
--source include/not_embedded.inc --source suite/perfschema_stress/include/settings.inc let $have_table= `SELECT COUNT(*) FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA='test' AND TABLE_NAME='t1'`; if (!$have_table) { --source suite/perfschema_stress/t/setup.test } --replace_result $num_stress_rows <num_stress_rows> eval SET @rowid = ROUND(RAND() * $num_stress_rows); let $conn_id= `SELECT CONNECTION_ID()`; let $conn_nr= conn_$conn_id; START TRANSACTION; UPDATE t1 SET b = 'changed' WHERE id=@rowid; SELECT b FROM t1 WHERE id=@rowid; COMMIT; START TRANSACTION; DELETE FROM t1 WHERE id=@rowid; INSERT INTO t1 (id, b) VALUES (@rowid, 'newly_inserted'); SELECT b FROM t1 WHERE id=@rowid; COMMIT; --replace_result $conn_nr <conn_nr> eval CREATE TABLE tw_$conn_nr AS SELECT * FROM t1; --replace_result $conn_nr <conn_nr> eval DROP TABLE tw_$conn_nr;
Back to File Manager