DROP DATABASE transforms;CREATE DATABASE transforms;DROP DATABASE test;CREATE DATABASE test;USE test; create table t2(a tinyint NOT NULL, b char(3)); ALTER TABLE t1 ADD UNIQUE UNIQUE INDEX b (b); INSERT INTO t2 VALUES (231,058101,37,'husky','postcondition','civilize',''); CREATE TABLE t1 ( c1 INT NOT NULL, c2 CHAR(5)) PARTITION BY HASH(c1 ) PARTITIONS 1; insert into ti values(1); CREATE TABLE t7( c1 BIT(64) ); CREATE TABLE t675 ( c1 VARCHAR(10) ); CREATE TABLE t8( c7 BIGINT ); CREATE TABLE t26 ( c1 INTEGER ); EXPLAIN EXTENDED SELECT * FROM t1 WHERE url='1'; create temporary table ti (a int) engine=innodb; SET @@global.innodb_file_format_max = @start_global_value; INSERT INTO t1 VALUES ('aa5','bb'); explain select auto from t1 where date_time like '1902-02-02 %'; SELECT * FROM t1 WHERE c1 >= '1998-12-31 11:30:45' ORDER BY c1 DESC; CREATE TABLE t3( c1 DEC UNSIGNED NULL ); CREATE TABLE t318 ( c1 INTEGER ); CREATE TABLE t661 ( c1 VARCHAR(10) ); (6,12); insert into t2 values(1, 3), (2, NULL), (3, NULL); RENAME information_schema.xcolumn_privileges; CREATE TABLE t737 ( c1 VARCHAR(10) ); CREATE TABLE t722 ( c1 VARCHAR(10) ); CREATE TABLE t( a SERIAL ) ENGINE=InnoDB; SELECT count(*) FROM t2; INSERT INTO t1 VALUES (1,'master,slave'), (2,'master,slave'); delete t1, t2, t3 from t1,t2,t3 where t1.id1 = t2.id2 and t2.id2 = t3.id3 and t1.id1 > 5; SELECT * FROM t1 WHERE c1 = '0000-00-00' ORDER BY c1 DESC; ); CREATE TABLE t853 ( c1 INTEGER ); CREATE TABLE t5 ( c int ); truncate t2; SELECT hex(c1),hex(c2) FROM t5 WHERE c1 <=>'1' ORDER BY c1 DESC LIMIT 2; ALTER TABLE t1n CHANGE c1 Fts_DOC_ID INT, ALGORITHM=COPY; SELECT * FROM t1 WHERE c2 = '-838:59:59' ORDER BY c2 DESC; DROP TABLE t17059925, t2, t3; SET SESSION sql_select_limit = 10; ALTER TABLE t ENGINE = InnoDB; insert into t1 values (4828532208463511553); set global innodb_trx_rseg_n_slots_debug=1; CREATE TABLE t3 ( a INT, c1 INT NOT NULL, c2 TINYINT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL ); DROP TABLE IF EXISTS t5; set global keycache1.key_cache_block_size=2048; select * from t3 order by a desc; ALTER TABLE t1 TABLESPACE ts2; SELECT * FROM t3 WHERE c2 = '-838:59:59' ORDER BY c1,c2 DESC; DROP TABLE t1, t_check_dml_not_executed_prematurely; CREATE TABLE m3( c6 NUMERIC(10, 8) NOT NULL DEFAULT 3.141592 ); CREATE TABLE t1( a INT )MAX_ROWS=70000; INSERT INTO t1 VALUES (1); UPDATE t1 SET c2=-1 WHERE c1=2071; CREATE TABLE t367 ( c1 INTEGER ); (7,'f'); select left(concat(a,version()),1) from t1; insert into `t1`values ( 1 ); CREATE TABLE t779 ( c1 INTEGER ); update t1 set a=2 /* will be "killed" after work has been done */; CREATE TABLE t11( c1 BIGINT(5) NULL DEFAULT 1 ); SELECT WEEKOFYEAR(c1) FROM t3; CREATE TABLE t842 ( c1 VARCHAR(10) ); INSERT INTO t1 VALUES (7); grant TRIGGER on performance_schema.* to 'pfs_user_2'@localhost; INSERT INTO t1 VALUES (106060e0); drop tables if exists t1, t2, t3, t4, t5; insert into t1 values (7), (8), (9); SET GLOBAL general_log= @old_general_log; insert into t1 values ('-1234.1e2'); drop table t1,t2,t4,t5,t6; alter table t1 add i int not null first;