DROP DATABASE test;
CREATE DATABASE test;
USE test;
CREATE TABLE t1 (c1 VARCHAR(10));
RENAME TABLE t1 TO t3_1;
CREATE TABLE t1 (c1 VARCHAR(10));
CREATE TABLE ti (a MEDIUMINT UNSIGNED, b TINYINT UNSIGNED NOT NULL, c BINARY(73) NOT NULL, d VARBINARY(64) NOT NULL, e VARBINARY(25), f VARCHAR(56), g TINYBLOB NOT NULL, h BLOB NOT NULL, id BIGINT NOT NULL, KEY(b), KEY(e), PRIMARY KEY(id)) engine=innodb;
INSERT INTO t1  VALUES ( 1 );
INSERT INTO ti VALUES (-2051845359,195,'ZH','Fm1KN3vnnbfAJqzkgwwqkSUiUdQ2XXfSCDEUEEAeIGzGcESzK6w0Q6R5JP5k0AjseibiL9igi6rM6lMHkwpIRxwUzm1InGXERKXxfeVE92MJwc2vJwNQiEf8mg4qwWQdMVbEbEOmNwvM8KftxguTaTJxXOYKs0MfBDHKnzdUQxMvXQ','MkHWQsJvomJAiHhL','0xKhHjjYzqBoq8qB5Qhndr0wwX6TN6vXS4DruYpRYGRcaRiSCd8JLvrMjydbhSXdrflpvAT2YaLD1Ll3r1pp','o4','0',5);
CREATE TABLE m3(c1 DECIMAL NULL, c2 VARCHAR(25) NOT NULL, c3 INT(4) NULL, c4 VARCHAR(15) NOT NULL PRIMARY KEY, c5 DECIMAL NOT NULL UNIQUE KEY,c6 DECIMAL(10,8) NOT NULL DEFAULT 3.141592);
ALTER TABLE t1 engine=innodb;
INSERT INTO t1 VALUES (0xFFFF);
DELETE FROM t1;
create table t2 (id int(11) not null, id2 int(11) not null, unique (id,id2),constraint t1_id_fk foreign key (id2,id) references t1 (id,id2)) engine=innodb;
INSERT INTO t1  VALUES(0xAED5);
create table t3(id3 int not null, t char(12), index(id3));
DROP TABLE t1;
CREATE TABLE t1 (c1 INT NOT NULL PRIMARY KEY, c2 CHAR(10), c3 DATETIME);
checksum table t1, t2, t3 quick;
CREATE TABLE t4(c1 char(1)) DEFAULT CHARSET = sjis engine=innodb;
CREATE TABLE test.t_before(a INT);
SET @@global.table_open_cache = FALSE;
INSERT INTO ti VALUES (-1131758228089208058,474843610,'CejAJ1nl9nXD01Wlh8AhSs5L88qrhkUmEeoMnYK54R4vZSWJDVwEZTuUeIf0oDZtAwZWCO','1b5dtWtwcp67uqkc2CKBmWZoT69pZ278cBhUpIDbidrE2zmRG6Dwi34g7iNwI1hd9xmmXR04A2PwSBnXnrQBDgb8Tmk4q4UZ0LAFtXKqvZjMzCQkD1vVbZkTJo10rxXMPcsekz0MWSMc3auS6vTunrkyWqMN9lGmp3jpyNfItZ7XJBEajZIgeZ24Uk2k5qwTQIuZve3y8jP6cbEb1MbuIq0PGFyk7zZD9p8GZR900td5x','b9Byigklj4GRtRgJErzfn08kznD','R6SAdoWnmLqV7sYCNVUqctg','9','C',3);
INSERT INTO ti VALUES (2924640036941716208,48125,'wLarOYwisnzxwAntuIqIV3zdbTm','Zty1IWSAoysCiE8qpfdV6SxqBaWJ1uF0js9a9lt33Tq2LhOvGQ0rmJTCqgC6X2lXqxIZi1azoH5Mr7LYc2y6TuNMTnVY4SBmAPJO7H7iDBZ8L3tF91C8koUbiOdAECDRYqwtjoa1o2vc7OmcDZOTdCGDUb6GEsqaQ7gkpJg4dz5PLxcFJSR2PKMaZy','eXtV0tQ','1QC4wc7NKntDTYkB3Y24amI5Lx2w4ag3KQdqnFsePkrDuq1QgcY5r3wfHgsMXU1DGqP7eugpRJISW4MAzJDvH9xKHBrNO3KNCfCZayeLSC5WCPb7wk11LBEsiqN2LO6KB6GnBlLl54PX5UfI762xvpT73AUd02brww2R56CZv8wydRjxlFb1gsSA2jyp7Jweu3SxpEF','RL','v9',6);
EXPLAIN PARTITIONS SELECT * FROM t1  WHERE b < CAST('2009-04-03 00:00:01' AS DATETIME);
SET pseudo_slave_mode = 1;
DROP TABLE t1;
CREATE TABLE t1 (c1 INTEGER NULL, c2 CHAR(5)) PARTITION BY KEY(c1) PARTITIONS 4;
select t1.pk, t2.b from t1 natural left join t2 group by t1.pk;
INSERT INTO ti VALUES (3028420845,-1517234,'5ZPNZFv','KRP','5Y8DpnLj8C','qS27jk6','H','N',1);
CREATE TABLE t4_purge ( A int PRIMARY KEY, B varchar(800), C varchar(800), D varchar(800), E varchar(800), F varchar(800), G varchar(800), H varchar(800), I varchar(800), J varchar(800), K varchar(800), L varchar(800), INDEX (B(767))) ENGINE=InnoDB ROW_FORMAT=DYNAMIC;
CREATE PROCEDURE p1() BEGIN SELECT SLEEP(1000); END;
CREATE TABLE t2 ( i INT ) engine=innodb  PARTITION BY KEY(i) PARTITIONS 3;
select convert_tz('2003-05-01 00:00:00', 'MET', 'UTC');
checksum table performance_schema.cond_instances extended;
DROP TABLE bigintegertypes;
INSERT INTO t1 VALUES(8112);
DROP USER rpluser_with_length_32_123456789@127.0.0.1;
insert into t2 values (60794+0.755555555);
INSERT INTO t1  VALUES (1,2), (1,3), (1,4), (1,5);
alter TABLE t1 add primary key (alpha), change a alpha int, change b beta int, modify c int not null;
insert into t1 values (6958,6958,6958,6958);
INSERT INTO ti VALUES (2909003501,-22667,'2','CjZRsGTF7XXSCdnxDvl2zBxuHqrtb8ww724uKIo11zelx56vwcFyruHymhqPvi5dr0Q2EMecyzIuVxl4k7y9hN7rEsqdrMYDuxvNWBRyxz7Y0dOyL','y8wmOcVYZzCbXwoIEEdeE1TQ9U4S3hpygG76MRTWqLsYC8jW','edPzdBhVckC4KsMrkiP4geHvLm2cTXfAQuDuCfZjDTUwCQMfFb0zkp5oJgwFhRwAJB6xnfTZivZPd44k7twzMfY9MsQZfAUbMsZ4CQemDMB1aHTdt18PkC8uc2peyw3YpqeHLuUBqSMM2l5CISaZPOrf1fW8','xnT','vS',14);
DROP TABLE t1;
XA START 'a';
insert into t2 values (51244+0.333333333);
XA END 'a';
XA PREPARE 'a';
CREATE TABLE t1 (a tinyblob) engine=innodb;
CREATE TABLE t469 (c1 INTEGER);
insert into t2 values (19700101000000+48);
INSERT INTO t1  VALUES(0xA6F2);
CREATE TABLE t9(c1 VARCHAR(10) NOT NULL KEY);
insert into t2 values (49654+0.755555555);
insert into t2 values (56439+0.755555555);
INSERT INTO t1  values (@a);
CREATE TABLE bug13861218 (c1 INT NOT NULL, c2 INT UNIQUE) ENGINE=InnoDB;
CREATE TABLE t881 (c1 VARCHAR(10));
CREATE TABLE t347 (c1 VARCHAR(10));
INSERT INTO ti VALUES (4096896135,5188468809135784401,'OnXYKsvXdZ8A51wbKSw6zvL','RatF1PUXEiDK7V8PTehgMhdbA7PlqeZoiAgtuNc5BlgR3njsoZPvj3xgDBUCSIk3ARWq6OWx69nlFsyT55onLjKnNjOoUND3n','ixSqtIVwFitumt','t2brL6GclKXqjXM8klXsvXvkbmkFCTxWtuc6KjT3d5HDkERExGSX','G','n',14);
ALTER TABLE ti CHANGE COLUMN c c CHAR(68);
CREATE TEMPORARY TABLE t1 (c1 INT) ENGINE=MRG_RocksDB UNION=(t1,t2) INSERT_METHOD=FIRST;
SELECT * FROM t3;
SELECT t1.c1,t4.c1 FROM t1 LEFT OUTER JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 < 5;
insert into t1 values ("hej");
ALTER EVENT one_event DO SELECT 12;
ALTER TABLE t1 CHANGE c1 c1 INT FIRST;
CREATE TABLE t5(c1 REAL NULL);
CREATE TABLE src (c1 INT NOT NULL AUTO_INCREMENT, c2 MEDIUMBLOB NULL, PRIMARY KEY(c1));
INSERT INTO t1  VALUES(0xA8E0);
CREATE TABLE t58 (c1 INTEGER);
INSERT INTO t1  VALUES ('text1');
CREATE TABLE multipolygon_geom(id INT PRIMARY KEY, mpoly MULTIPOLYGON NOT NULL, SPATIAL INDEX(mpoly));
insert into t2 values (50959+0.333333333);
ALTER TABLE ti CHANGE COLUMN a a BINARY(110);
insert into mysql.help_relation(help_keyword_id,help_topic_id)values(@keyword1_id,@topic2_id);
drop function if exists t1;
set global innodb_trx_rseg_n_slots_debug=1000;
insert delayed INTO t1  values (1,"b");
