1# Tests for PERFORMANCE_SCHEMA table io 2# 3# Payload fragment to test table io for basic DML. 4# 5# $table_item = <schema>.<tablename> must be set before sourcing this script. 6# 7 8insert into marker set a = 1; 9eval insert into $table_item set a = 'foo', b = 1; 10insert into marker set a = 1; 11eval insert into $table_item set a = 'foo', b = 2; 12insert into marker set a = 1; 13eval insert into $table_item set a = 'foo', b = 3; 14insert into marker set a = 1; 15eval select * from $table_item; 16insert into marker set a = 1; 17eval update $table_item set a = 'bar'; 18insert into marker set a = 1; 19eval select * from $table_item limit 2; 20insert into marker set a = 1; 21eval delete from $table_item where b = 3; 22insert into marker set a = 1; 23# This may record a fetch for "deleted" records 24eval select * from $table_item; 25insert into marker set a = 1; 26eval optimize table $table_item; 27insert into marker set a = 1; 28# Same data after optimize 29eval select * from $table_item; 30insert into marker set a = 1; 31# truncate will fail for views 32--disable_abort_on_error 33eval truncate table $table_item; 34--enable_abort_on_error 35insert into marker set a = 1; 36 37