DROP DATABASE transforms;CREATE DATABASE transforms;DROP DATABASE test;CREATE DATABASE test;USE test;
create table t1 ( a int not null default 0);
explain select a1, max(a2) from t1 group by a1;
drop table t1, t2, t3, t4;
CREATE TABLE t1(i int);
CREATE TABLE m3(c1 MEDIUMINT NULL, c2 VARCHAR(25) NOT NULL, c3 TINYINT(4) NULL, c4 VARCHAR(15) NOT NULL PRIMARY KEY, c5 MEDIUMINT NOT NULL UNIQUE KEY,c6 NUMERIC(10,8) NOT NULL DEFAULT 3.141592);
insert into t1 values (1),(1),(2),(2),(3),(3);
create table t4 (a int unique);
INSERT INTO t1 VALUES (DEFAULT(i));
create table profile_log (how_many int);
CREATE TABLE t2 (a INT, b INT, c INT, d INT, e INT, f INT, KEY (a,b,c));
INSERT INTO t1 VALUES (3),(1),(2),(4),(1);
CREATE TABLE t919 (c1 INTEGER);
ALTER TABLE t1 ADD c POINT;
CREATE TABLE m3(c1 TIMESTAMP NULL, c2 VARBINARY(25) NOT NULL, c3 INTEGER(4) NULL, c4 VARBINARY(15) NOT NULL PRIMARY KEY, c5 TIMESTAMP NOT NULL UNIQUE KEY,c6 DEC(10,8) NOT NULL DEFAULT 3.141592);
# Query: "CREATE TABLE m3(c1 TIMESTAMP NULL, c2 VARBINARY(25) NOT NULL, c3 INTEGER(4) NULL, c4 VARBINARY(15) NOT NULL PRIMARY KEY, c5 TIMESTAMP NOT NULL UNIQUE KEY,c6 DEC(10,8) NOT NULL DEFAULT 3.141592);" FAILED: Table 'm3' already exists
INSERT INTO t2 VALUES (844,226209,37,'furnishings','vanish','hooker','');
# Query: "INSERT INTO t2 VALUES (844,226209,37,'furnishings','vanish','hooker','');" FAILED: Tabulka 't2' nebyla zamčena s LOCK TABLES
CREATE TABLE t900 (c1 INTEGER);
CREATE TABLE t865 (c1 INTEGER);
ALTER TABLE t1 ADD utf8_f CHAR(32) CHARACTER SET utf8 NOT NULL default '';
ALTER TABLE t1 ROW_FORMAT=FIXED KEY_BLOCK_SIZE=1;
CREATE TABLE t50 (c1 INTEGER);
CREATE TEMPORARY TABLE t2 (a INT);
show status like "performance_schema_mutex_classes_lost";
insert into t2 values( 1 );
CREATE TABLE t17 (c1 VARCHAR(10));
INSERT INTO t4 VALUES('20070523091528','070523091528','20070524091528','070524091528'),('20070525','070525','20070526','070526');
# Query: "INSERT INTO t4 VALUES('20070523091528','070523091528','20070524091528','070524091528'),('20070525','070525','20070526','070526');" FAILED: Tabulka 't4' nebyla zamčena s LOCK TABLES
CREATE TABLE t660 (c1 INTEGER);
CREATE TABLE t306 (c1 INTEGER);
# Query: "CREATE TABLE t306 (c1 INTEGER);" FAILED: Tabulka 't306' nebyla zamčena s LOCK TABLES
CREATE TABLE t3(c1 SMALLINT UNSIGNED NOT NULL, c2 SMALLINT NULL, c3 TINYINT, c4 MEDIUMINT , c5 INT, c6 INTEGER, c7 BIGINT, index idx(c2,c7));
CREATE TABLE t3 ( broj int(4) unsigned NOT NULL default '0',  naziv char(25) NOT NULL default 'NEPOZNAT',  PRIMARY KEY  (broj)) ENGINE=MyISAM;
flush table;
# Query: "flush table;" FAILED: Tabulka 't1' byla zamčena s READ a nemųže bũt zmėnėna
CREATE TABLE general (slow INT, general INT, master_heartbeat_period INT, ignore_server_ids INT);
# Query: "CREATE TABLE general (slow INT, general INT, master_heartbeat_period INT, ignore_server_ids INT);" FAILED: Tabulka 'general' nebyla zamčena s LOCK TABLES
SELECT * FROM t3 WHERE c1 <=> '1000-00-01 00:00:00' ORDER BY c1,c2 DESC;
# Query: "DROP TABLE t1,t2,t3,t4;" FAILED: Tabela 't2' nije bila zaključana komandom 'LOCK TABLES'
create temporary table t1 (a int key);
select * from t2 for update;
CREATE TABLE t493 (c1 VARCHAR(10));
# Query: "CREATE TABLE t493 (c1 VARCHAR(10));" FAILED: Tabela 't493' nije bila zaključana komandom 'LOCK TABLES'
CREATE TABLE t693 (c1 VARCHAR(10));
INSERT INTO t1 VALUES(0xABAF);
CREATE TABLE m3(c1 DECIMAL NULL, c2 VARBINARY(25) NOT NULL, c3 BIGINT(4) NULL, c4 VARBINARY(15) NOT NULL PRIMARY KEY, c5 DECIMAL NOT NULL UNIQUE KEY,c6 FIXED(10,8) NOT NULL DEFAULT 3.141592);
# Query: "CREATE TABLE m3(c1 DECIMAL NULL, c2 VARBINARY(25) NOT NULL, c3 BIGINT(4) NULL, c4 VARBINARY(15) NOT NULL PRIMARY KEY, c5 DECIMAL NOT NULL UNIQUE KEY,c6 FIXED(10,8) NOT NULL DEFAULT 3.141592);" FAILED: Tabela 'm3' već postoji
CREATE TABLE t2 (a INT) engine= InnoDB;
# Query: "CREATE TABLE t2 (a INT) engine= InnoDB;" FAILED: Tabela 't2' već postoji
CREATE TABLE t6 (c1 INTEGER NOT NULL);
INSERT INTO t1 VALUES(0xAEA2);
CREATE TABLE t15 (c1 VARCHAR(10));
INSERT INTO t1 VALUES (@@session.unique_checks);
CREATE TABLE t1 (c1 FLOAT NOT NULL PRIMARY KEY, c2 CHAR(10), c3 DATETIME);
# Query: "SELECT * FROM t3 WHERE c3 = '1998-12-11';" FAILED: Nepoznata kolona 'c3' u 'where clause'
ALTER TABLE t4 MODIFY c1 DECIMAL   ZEROFILL NOT NULL;
select concat(a,'.') from t1 where binary a='aaa';
SET @start_value = @@global.key_cache_block_size;
set global innodb_trx_rseg_n_slots_debug=1;
CREATE INDEX i1 ON t6(c1);
ALTER TABLE t1 ADD   UNIQUE INDEX i1 (c1); ;