mirror of
https://github.com/MariaDB/server.git
synced 2025-02-04 21:02:17 +01:00
9854fb6fa7
This patch adds for "--ps-protocol" second execution of queries "SELECT". Also in this patch it is added ability to disable/enable (--disable_ps2_protocol/--enable_ps2_protocol) second execution for "--ps-prototocol" in testcases.
37 lines
1.1 KiB
PHP
37 lines
1.1 KiB
PHP
# Tests for PERFORMANCE_SCHEMA table io
|
|
#
|
|
# Payload fragment to test table io for basic DML.
|
|
#
|
|
# $table_item = <schema>.<tablename> must be set before sourcing this script.
|
|
#
|
|
|
|
--disable_ps2_protocol
|
|
insert into marker set a = 1;
|
|
eval insert into $table_item set a = 'foo', b = 1;
|
|
insert into marker set a = 1;
|
|
eval insert into $table_item set a = 'foo', b = 2;
|
|
insert into marker set a = 1;
|
|
eval insert into $table_item set a = 'foo', b = 3;
|
|
insert into marker set a = 1;
|
|
eval select * from $table_item;
|
|
insert into marker set a = 1;
|
|
eval update $table_item set a = 'bar';
|
|
insert into marker set a = 1;
|
|
eval select * from $table_item limit 2;
|
|
insert into marker set a = 1;
|
|
eval delete from $table_item where b = 3;
|
|
insert into marker set a = 1;
|
|
# This may record a fetch for "deleted" records
|
|
eval select * from $table_item;
|
|
insert into marker set a = 1;
|
|
eval optimize table $table_item;
|
|
insert into marker set a = 1;
|
|
# Same data after optimize
|
|
eval select * from $table_item;
|
|
insert into marker set a = 1;
|
|
# truncate will fail for views
|
|
--disable_abort_on_error
|
|
eval truncate table $table_item;
|
|
--enable_abort_on_error
|
|
insert into marker set a = 1;
|
|
--enable_ps2_protocol
|