DROP DATABASE test;CREATE DATABASE test;USE test;
CREATE TABLE tsq(id int KEY,subquery CHAR (1),can_be_locked INT);
CREATE TABLE m3(c1 TIME NULL,c2 BINARY (1)NOT NULL,c3 INT(1) NULL,c4 VARBINARY(1) NOT NULL KEY,c5 TIME NOT NULL UNIQUE KEY,c6 DECIMAL(0,0) NOT NULL DEFAULT 3.141592);
create table temp2(f1 char(1),f2 char(1),f3 int,f4 char(1));
CREATE TABLE t1(a DATETIME(1),b TIME(1));
CREATE TABLE mt1(a int not null key,b int not null,key (b));
CREATE TABLE t81(c1 INT);
set global innodb_trx_rseg_n_slots_debug=1;
CREATE TABLE m3(c1 INT NULL,c2 BINARY (1)NOT NULL,c3 INT(1) NULL,c4 VARBINARY(1) NOT NULL KEY,c5 INT NOT NULL UNIQUE KEY,c6 FIXED(0,0) NOT NULL DEFAULT 3.141592);
create table t5(a int)engine=innodb;
create table t_warn(a INT(1));
CREATE TABLE t681(c1 CHAR (1));
insert into t1 values();
set @@global.innodb_file_per_table=0;
CREATE TABLE t8(c1 INT);
CREATE TEMPORARY TABLE t2(a int,b int,primary key (a));
checksum table t1,t2,t3,t4 extended;
ALTER TABLE t2 ADD COLUMN c INT;
CREATE TABLE t9(c1 CHAR (1));
CREATE TABLE t10(c1 CHAR (1));
create table t2(pid int,foreign key (pid)references t1(id)) engine=Innodb;
SELECT MIN(a)AS min_a FROM t1;
create table t6(c1 int);
delete from t1 where a in(0,0,0);
CREATE TRIGGER t1_bu BEFORE UPDATE ON t1 FOR EACH ROW INSERT INTO t2 VALUES(1);
delete t1 from t1,t2 where t1.a=t2.a;
CREATE TABLE t11(c1 CHAR (1));
SELECT a,b,COUNT(*)FROM t1 GROUP BY a,b WITH ROLLUP;
update t1 set a=4 where b=3;
ALTER TABLE t1 engine=MERGE UNION(tn_exists);
ALTER TABLE t2 MODIFY a INT NOT NULL;
CREATE TABLE t12(c1 CHAR (1));
CREATE TABLE t4(c1 INT NOT NULL);
CREATE TABLE t14(c1 CHAR (1));
CREATE TABLE t3(a timestamp,b char(1),KEY (a)) PARTITION BY HASH (UNIX_TIMESTAMP(a)) PARTITIONS 3;
select a,t1.*,b from t1;
CREATE TABLE t16(c1 CHAR (1));
check table t1;
CREATE TABLE t17(c1 INT);
CREATE TABLE t18(c1 CHAR (1));
create table exists_only_on_slave(a int);
create table worklog5743_4(a1 int,a2 TEXT not null)KEY_BLOCK_SIZE=4;
CREATE TABLE t19(c1 CHAR (1));
create trigger t1_bi before insert on t1 for each row insert into test.t2 SET b=new.a
ALTER TABLE t5 ADD c2 BINARY(1)NULL FIRST;
CREATE TEMPORARY TABLE t4 LIKE t3;
CREATE TABLE t20(c1 INT);
create table t7(id int not null key,name char(1)) ENGINE=INNODB;
SELECT COUNT(*)FROM t1 WHERE b IS NOT NULL;
CREATE DATABASE db1 character set ascii;
alter table t1 engine=innodb;
CREATE TABLE t21(c1 CHAR (1));
USE db1;
CREATE TABLE t1(c1 YEAR(1),c2 YEAR(1));
CREATE TABLE m3(c1 DECIMAL NULL,c2 BINARY(1)NOT NULL,c3 INT(1) NULL,c4 BINARY(1) NOT NULL KEY,c5 DECIMAL NOT NULL UNIQUE KEY,c6 DEC(0,0) NOT NULL DEFAULT 3.141592);
INSERT INTO t1 VALUES(0,0),(0,0);
insert into t1 values(0,0);
drop table if exists t1,t2,m1;
create table t14(a int key)engine=innodb key_block_size=9;
SELECT COUNT(*)FROM t1 WHERE c1=0;