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