Debian Codegraph @

mysql-test/suite/perfschema/include/table_io_basic_dml.inc

raw
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
8 --disable_ps2_protocol
9 insert into marker set a = 1;
10 eval insert into $table_item set a = 'foo', b = 1;
11 insert into marker set a = 1;
12 eval insert into $table_item set a = 'foo', b = 2;
13 insert into marker set a = 1;
14 eval insert into $table_item set a = 'foo', b = 3;
15 insert into marker set a = 1;
16 eval select * from $table_item;
17 insert into marker set a = 1;
18 eval update $table_item set a = 'bar';
19 insert into marker set a = 1;
20 eval select * from $table_item limit 2;
21 insert into marker set a = 1;
22 eval delete from $table_item where b = 3;
23 insert into marker set a = 1;
24 # This may record a fetch for "deleted" records
25 eval select * from $table_item;
26 insert into marker set a = 1;
27 eval optimize table $table_item;
28 insert into marker set a = 1;
29 # Same data after optimize
30 eval select * from $table_item;
31 insert into marker set a = 1;
32 # truncate will fail for views
33 --disable_abort_on_error
34 eval truncate table $table_item;
35 --enable_abort_on_error
36 insert into marker set a = 1;
37 --enable_ps2_protocol