DROP DATABASE test;
CREATE DATABASE test;
USE test;
CREATE TABLE t1(a LONGBLOB);
INSERT INTO t1  VALUES('a');
INSERT INTO t1  VALUES (112233);
CREATE TABLE ti (a MEDIUMINT, b BIGINT UNSIGNED, c BINARY(18), d VARCHAR(21) NOT NULL, e VARCHAR(23) NOT NULL, f VARCHAR(77) NOT NULL, g TINYBLOB, h MEDIUMBLOB NOT NULL, id BIGINT NOT NULL, KEY(b), KEY(e), PRIMARY KEY(id)) ENGINE=InnoDB;
CREATE TEMPORARY TABLE temp_binlog_disabled(a INT) ENGINE=InnoDB;
drop TABLE t1;
XA START 'a';
INSERT INTO ti VALUES (-6597086529773188582,251,'uDIiinM4','3tlWAXiln6U2LAiv2xXNpJlg8oruGsNyjLGzJJtRZDgubDbC7bWYoaVxMjV0nLsTlIz2LjOudy3GBve8M1wqTTt75RFcrxn5SQv2qi355j3f517dnyjFqGz4ioMYlQqXmbXPD2jceVYR1DB88BKavtDp9CHQmbEmTW36hh44mIm3GaWtvc5uLt9tvHdKaXdr9k7KJxPupvk8sxamOSbp8SbqGa8Z9tLf8YWGKlo24bK60Xli0V1','BSbI9OD','wL','t','g',3);
XA END 'a';
SET @@session.pseudo_slave_mode = ON;
XA PREPARE 'a';
CREATE TABLE t1(c1 DATE NULL, c2 CHAR(25) NOT NULL, c3 MEDIUMINT(4) NULL, c4 CHAR(15) NOT NULL PRIMARY KEY, c5 DATE NOT NULL UNIQUE KEY,c6 FIXED(10,8) NOT NULL DEFAULT 3.141592);
INSERT INTO ti VALUES (4070827335,-1298847957,'Z','qK34','Xu','lOHbg7I43fVgG3c9BH8IXEXTmp8drBk5e5fGhMICkTqRpwm2VtW4YruHEeD3Y51KzN9T5t8S0PAnAJOZm4a84wjq6CROWmVOkDzRsGwncXuo4kQMlrUe4iGoONTbo8qrRlUzzrpJYh','O','An',4);
DELETE FROM t1;
INSERT INTO ti VALUES (39370,-1310310255274659529,'CvaDxzFgY','TaQ9G9pKoj7s90pppR0vsy6GlIBkLCpEUq2Cm0HK3V10xFkOp74MpH0hJSY5unfbJmEjOQ7V5lGemnxrBiyjf6Wg80D0embp4Mzqc0Se9ZmBTg2L4zRuwl332AIuFbJfljo78YshStvrp5eLyZThALGsDYe7lZ7C','ix0LK64fP8DfEStWDDliEmPDlTXalANvq','YmmhYplAb75AOyULtGeUPAuvQxQuKxFIIMVZWshc8QusAl1JwLEdtEqSoRKgpAMkglGY6hkVa05aAkUQgLJf3yWI1sipP751b7FmOLiNXF9U1MKR1V1JamuTXMfs95DlTAlvuhnN9ZkPTZsIzrbHXvqtUS2dmlec8i7APkw0SfnYMiJR1Kwi','m','B',4);
INSERT INTO ti VALUES (3014470415,10605708,'OYa2kUL1VKdaKXCvL66lZ70e0KnlQ8RhkSjT01m','cpOBIYSYd800jHdOF9f24CWNResQ7nsnSqQ8YmQDuI3lC64vT1Q46H','FpfJUXPlHEJq2OS1uHvJbnh0tUpFrE1f37XQmvDKxFPw5EoY32uaOIw7UOVMcHqjAFZTAWr3P','rZheXQsqB570MUUM4PP','e','un',1);
CREATE TABLE t2 (y INT);
CREATE TABLE m3(c1 FLOAT NULL, c2 CHAR(25) NOT NULL, c3 TINYINT(4) NULL, c4 CHAR(15) NOT NULL PRIMARY KEY, c5 FLOAT NOT NULL UNIQUE KEY,c6 DEC(10,8) NOT NULL DEFAULT 3.141592);
DROP TABLE t1,t2,t5,t12,t10;
INSERT INTO ti VALUES (13703868380332925060,537145704,'EOsbdqDnhiMeobnDD4N','YrD1HJfGBqo8AE7mNNH8FEBlcMdJaMrKHZLXzSY81SkL5X96N3ZgPEZ6Bs1NLwcvSnfA5b5bAHlziOumgJ3hRqrkDB4RTpnkNfy3a2xpeDA7Il8Fd1Y0RdmWXexyvlbqAi8lVX3gUMFnZAor4VxsVItlHNz6RXXcrClYDzdAL8hxWuXZLFNENgJ3zIXAvbur4EpS42sR8GhlrO5','PPXcpPahJMs','kqwKtu2k0uG4Gv7SRSvT5ErixMF0sewhAh6KAcpCrFK296AHyb8l','0','C3',14);
CREATE TABLE t1 (a DATETIME) PARTITION BY HASH (EXTRACT(YEAR_MONTH FROM a));
INSERT INTO ti VALUES (2845975627,2237490611,'KGVwc8OMC76dvRShd8A8bMzucjirmikW9apmI4SR7','0HBQvZqDt','MeZNehACLt6GmIMCHDFdo','xbmDPPjGlzBpxNX398YhNDYca84XxJHBIDiagmXx12mCPWJ83ACqNPFQ','bQ','v',1);
INSERT INTO t1  VALUES (400000), (400001);
create table t_34455 (a int not null);
drop TABLE t1;
CREATE TABLE c ( pk INT, col_varchar_key VARCHAR(1), PRIMARY KEY (pk), KEY col_varchar_key (col_varchar_key) ) engine=innodb;
CREATE TABLE t1 (c1 INT NOT NULL, c2 CHAR(5)) PARTITION BY LINEAR KEY(c1) PARTITIONS 10;
INSERT INTO ti VALUES (1,-827661822,'qq1WkCUPEtxkEvtGjIwhXcF5Vfa6R2PK3YYY3M4irmdYXOqNgKs6BefVhkEChDbv0L85FAmJ9ILSF8T68G4ty','37LBJ9pbpKGkSRy9MPRMMBPTCFmjL5c2BMwVSmn5K8QS7ZClJsV3xXMH6gA5XlbGGTOiBfLn','03FfvB7Xv','IBhaTM0BKGE3jvD4FaQb4l4T23PqJmpyi7D','A1b','lJ',6);
create table `t2` ( `f1` int(11) not null default -1, unique key `i2` (`f1`) ) engine=innodbcluster default charset=utf8;
CREATE TABLE bug48024(a int PRIMARY KEY,b int NOT NULL,KEY(b)) engine=innodb;
DELETE FROM t1;
UPDATE t1 SET t1.c2='99999.99999' WHERE c1 BETWEEN 080000 AND 100000;
INSERT INTO ti VALUES (4935,601,'2yJ2Tyr9JFKcTwmejEOuT84DbxHHPw3rtYSoFPN4CR8ljyYRhrOSKR','K1k0a1jvz8mTzF7CYy90ITk8yDyOMtaMq4Qq81NQm34TLe8yLovzTdESzko0gO6HLQ5PnjNwnSOgvPCVmhIATA6z43XA1kAUiIy1xLPaiFB0X7LMhZIhPVbvtZe1tw','Y1UuKWNwqRpxROkfVARuQfy9hjX0wYhKRDTwIHmmEosdjcghoZaE2V9dtoEzkdsmIoPnEwPUHJPQCR','MZ17ivMkYy9CUq2jLFoOumNG1MbLuLQSwz9vSld6T4qihxar6nEbwZYbJWvvsodDTWsK8FxJiCSGww2sMHikbxEwVFQdtyfZPPlox0nKg9l5YboeugaLY0qDouDSet0kA65z2YSF','X','v',14);
INSERT INTO t2 VALUES('blue');
ALTER TABLE t1 engine=innodb;
INSERT INTO t1 VALUES ('1978-11-26');
drop table t1, t2, t3, t4, t5;
CREATE TABLE t2 (f2 VARCHAR(10)) engine=innodb;
CREATE TABLE t1 (c1 bigint(20) unsigned NOT NULL AUTO_INCREMENT, c2 varchar(40) not null default '', c3 datetime not NULL, PRIMARY KEY (c1,c3), KEY partidx(c3)) engine=innodb PARTITION BY RANGE (TO_DAYS(c3)) (PARTITION p200912 VALUES LESS THAN (to_days('2010-01-01')), PARTITION p201103 VALUES LESS THAN (to_days('2011-04-01')), PARTITION p201912 VALUES LESS THAN MAXVALUE);
insert into t2 values (11164+0.75);
CREATE TABLE `Ｔ１` (c1 char(20), INDEX(c1)) DEFAULT CHARSET = utf8 engine=innodb;
flush TABLE t1 with read lock;
set global innodb_trx_rseg_n_slots_debug=1024;
CREATE TEMPORARY TABLE t2 (a int, b int, primary key (a)) engine=innodb;; ;

