DROP DATABASE transforms;CREATE DATABASE transforms;DROP DATABASE test;CREATE DATABASE test;USE test;
# Query: "begin declare continue handler for 1264 -- ER_WARN_DATA_OUT_OF_RANGE select 'Inner (good)' as 'h_we';" FAILED: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'declare continue handler for 1264 -- ER_WARN_DATA_OUT_OF_RANGE select 'Inner (go' at line 1
CREATE TEMPORARY TABLE t1(c1 TINYTEXT NULL);
CREATE TABLE t1(c1 DOUBLE NULL, c2 VARBINARY(25) NOT NULL, c3 SMALLINT(4) NULL, c4 VARBINARY(15) NOT NULL PRIMARY KEY, c5 DOUBLE NOT NULL UNIQUE KEY,c6 NUMERIC(10,8) NOT NULL DEFAULT 3.141592);
# Query: "CREATE TABLE t1(c1 DOUBLE NULL, c2 VARBINARY(25) NOT NULL, c3 SMALLINT(4) NULL, c4 VARBINARY(15) NOT NULL PRIMARY KEY, c5 DOUBLE NOT NULL UNIQUE KEY,c6 NUMERIC(10,8) NOT NULL DEFAULT 3.141592);" FAILED: Table 't1' already exists
INSERT INTO t1  VALUES('a');
SELECT * FROM t1  WHERE c1 = '1998-12-31 11:30:45' ORDER BY c1 LIMIT 2;
label1 loop if count1 > 2 then leave lable1;
SET GLOBAL innodb_file_per_table=0;
INSERT INTO t1  VALUES (1003);
DROP TABLE t1;
SELECT hex(c1),hex(c2) FROM t1  WHERE c1 IN ( '1' , '64' ) ORDER BY c1 DESC;
# Query: "create TABLE t1 (a timestamp null default current_timestamp on update current_timestamp, b timestamp null);" FAILED: Table 't1' already exists
ALTER TABLE t1 CHANGE c1 c1 BIGINT NULL;
SELECT SUM(c1) AS value FROM t1  WHERE c1 = 0;
drop table if exists t1, t2, t3;
create TABLE t1 (f text) engine=innodb;
set debug_sync='p0 wait_for s2 execute 2';
DROP TABLE t1;
SET GLOBAL read_only= 1;
CREATE TABLE t1 (a TIME(1), b TIME(2));
# Query: "CREATE TABLE t1 (a TIME(1), b TIME(2));" FAILED: Table 't1' already exists
ANALYZE TABLE t1;
CREATE TABLE t1 (C2 INT);
CREATE TABLE t(id INT);
# Query: "CREATE TABLE t(id INT);" FAILED: Table 't' already exists
DROP TABLE t1;
CREATE TABLE t1 (c1 INTEGER);
INSERT INTO t1  VALUES(1);
CREATE TEMPORARY TABLE t1(a INT);
REPLACE t1 VALUES ('a');
CREATE FUNCTION t1 s char(20)) RETURNS CHAR(50) RETURN CONCAT('Hello, ',s,'!');
INSERT INTO t1  VALUES (SEC_TO_TIME(10));
checksum TABLE t1;
INSERT INTO t1  VALUES('a');
SET @@global.innodb_flushing_avg_loops = ON;
DROP TABLE t1;
insert INTO t1  values (0xF0),(0xF1),(0xF2),(0xF3),(0xF4),(0xF5),(0xF6),(0xF7);
ALTER TABLE t1 MODIFY c1 BIT NULL;
CREATE TABLE table_11757486 (field1 tinyint) ENGINE=INNODB;
ALTER TABLE t1 CHANGE c1 c1 INT ZEROFILL NULL;
SELECT MIN(c1) AS value FROM t1  WHERE c1 = 0;
INSERT INTO t1  VALUES (DEFAULT);
set global innodb_trx_rseg_n_slots_debug=1;
insert INTO t1  values ('x,y,z,Ä,Ö,Ü');
# Query: "CREATE TABLE t1(c1 TIMESTAMP NOT NULL);" FAILED: Table 't1' already exists
ALTER TABLE t1 MODIFY c1 NUMERIC UNSIGNED NOT NULL;
INSERT INTO t1  VALUES('a');
CREATE TABLE ```ab````cd``` (i INT);
INSERT INTO t1  VALUES (CONVERT(_ucs2 0x0627064A063106270646 USING utf8));
INSERT INTO t1  VALUES ('HHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHH');
SET global.expire_logs_days = 1;
CREATE TABLE t2c (a INT, b CHAR(1) NOT NULL) ENGINE=InnoDB;
DROP TABLE t1;
INSERT INTO t1  VALUES(1);
INSERT INTO t1  VALUES(0xADA3); ;
INSERT INTO t1  VALUES(0xADA3); ;
INSERT INTO t1  VALUES(0xADA3); ;