3 Partially reduced testcases for CS 10.5.26 13ca1ce565c38ab41a6979a5d331efe78d840db1 (Optimized)

INSTALL PLUGIN Spider SONAME 'ha_spider.so';
CREATE SERVER srv FOREIGN DATA WRAPPER MYSQL OPTIONS (SOCKET '../socket.sock', DATABASE 'test', USER 'Spider', PASSWORD '');
SET GLOBAL init_connect='SET autocomit=0';
CREATE TABLE customer (id INT NOT NULL, PRIMARY KEY(id)) ENGINE=Spider COMMENT='WRAPPER "mysql", SRV "srv", TABLE "t"';
CREATE TABLE gis_poINT(p1 POINT NOT NULL, p2 POINT NOT NULL, SPATIAL KEY k1 (p1), SPATIAL KEY k2 (p2)) ENGINE=Spider COMMENT='WRAPPER "mysql", SRV "srv", TABLE "t"' COMMENT='WRAPPER "mysql", SRV "srv", TABLE "t"';
CREATE TABLE t5 (a INT NOT NULL, b CHAR(20), KEY(a)) ENGINE=Spider COMMENT='WRAPPER "mysql", SRV "srv", TABLE "t"' COMMENT='WRAPPER "mysql", SRV "srv", TABLE "t"';
XA BEGIN 'a','ab';
SELECT ST_ASTEXT (p1) FROM gis_point WHERE MBRWITHin (p1, @p1);
SHOW TABLE STATUS LIKE 't_';
SET GLOBAL table_open_cache=400;
SELECT * FROM t5 PARTITION (s5) ORDER BY id;
SELECT * FROM information_schema.tables;
SELECT fid, ST_X (g) FROM gis_point;

INSTALL PLUGIN Spider SONAME 'ha_spider.so';
CREATE SERVER srv FOREIGN DATA WRAPPER MYSQL OPTIONS (SOCKET '../socket.sock', DATABASE 'test', USER 'Spider', PASSWORD '');
SET GLOBAL init_connect=init_slave;
CREATE TABLE foo (a INT, b INT, c CHAR(10), PRIMARY KEY(c (3)), KEY b (b)) ENGINE=Spider COMMENT='WRAPPER "mysql", SRV "srv", TABLE "t"';
CREATE TABLE #mysql50#t11 (a INT) ENGINE=Spider COMMENT='WRAPPER "mysql", SRV "srv", TABLE "t"' COMMENT='WRAPPER "mysql", SRV "srv", TABLE "t"';
SELECT a.constraint_schema, b.table_name, constraint_type, b.constraint_name, unique_constraint_schema, unique_constraint_name, match_option, update_rule, delete_rule, b.referenced_table_name FROM information_schema.table_constraints a, information_schema.referential_constraints b WHERE a.constraint_schema='test' AND a.constraint_schema=b.constraint_schema AND a.constraint_name=b.constraint_name;
FLUSH TABLES WITH READ LOCK;
INSERT INTO foo VALUES (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL, "rewoiu","fds","fr","oiufdsrew");
INSERT INTO foo VALUES (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew");
CREATE OR REPLACE TEMPORARY TABLE t1 (a INT, b INT) ENGINE=InnoDB;
INSERT INTO t1 VALUES ('1','1'),('5','2'),('2','3'),('3','4'),('4','4');
SELECT * FROM foo WHERE a <="c";

INSTALL PLUGIN Spider SONAME 'ha_spider.so';
CREATE SERVER srv FOREIGN DATA WRAPPER MYSQL OPTIONS (SOCKET '../socket.sock', DATABASE 'test', USER 'Spider', PASSWORD '');
CREATE TABLE t (c INT PRIMARY KEY,c1 BLOB, c2 TEXT) ENGINE=InnoDB;
CREATE TABLE t1 (a CHAR CHARACTER SET latin1 COLLATE latin1_swedish_ci, b CHAR CHARACTER SET latin1 COLLATE latin1_german1_ci);
ALTER TABLE t1 CHANGE a a VARCHAR(10) CHARACTER SET cp1251;
SELECT * FROM t1 _1 WHERE 0.8=0.7+0.1;
CALL empty_5();
CREATE TABLE SERVER (SUFFIX CHAR(2) BINARY NOT NULL, server_id INT UNSIGNED NOT NULL, NAME CHAR(32) BINARY NOT NULL, no_of_read INT UNSIGNED NOT NULL, no_of_insert INT UNSIGNED NOT NULL, no_of_delete INT UNSIGNED NOT NULL, PRIMARY KEY USING HASH (SUFFIX, server_id)) ENGINE=Spider COMMENT='WRAPPER "mysql", SRV "srv", TABLE "t"';
SET @start_value=@@GLOBAL.slow_query_log;
SET GLOBAL wait_timeout=@start_value;
DROP TABLE t1;
SELECT * FROM information_schema.tables WHERE table_schema='test' AND create_options LIKE '%table_type=XML%';
SET GLOBAL key_cache_segments=10, GLOBAL table_open_cache=1024;
CREATE TABLE t1 (user_num BIGINT, HOURs SMALLINT, KEY user_num (user_num)) ENGINE=RocksDB PARTITION BY RANGE COLUMNS (HOURs) (PARTITION hour_003 VALUES LESS THAN (3), PARTITION hour_004 VALUES LESS THAN (4), PARTITION hour_005 VALUES LESS THAN (5), PARTITION hour_LAST VALUES LESS THAN (MAXVALUE));
SET GLOBAL init_connect="CALL p1 ('t1', 11)";
SELECT SLEEP(3);
SELECT * FROM information_schema.PARTITIONS WHERE table_schema="test";