DROP DATABASE test;
CREATE DATABASE test;
USE test;
SET SESSION aria_repair_threads=CAST(-1 AS UNSIGNED INT);
SET SESSION aria_sort_buffer_size=CAST(-1 AS UNSIGNED INT);
SET SESSION tmp_table_size=65535;
CREATE TABLE t1 (a BIT(7));
INSERT INTO t1 VALUES('C'), ('c');
ALTER TABLE t1 modify a VARCHAR(255);
XA BEGIN 'a';
INSERT INTO t1 VALUES('2001-01-01 00:00:01.000000');
INSERT INTO t1 VALUES('a');
INSERT INTO t1 VALUES(1), (3);
INSERT INTO t1 VALUES(0xACD4);
INSERT INTO t1 VALUES(0xABA8);
INSERT INTO t1 VALUES(1);
INSERT INTO t1 VALUES(0xF48F8080);
INSERT INTO t1 SELECT * FROM t1;
INSERT INTO t1 VALUES(0xA9A2);
INSERT t1 VALUES(30), (1230), ("1230"), ("12:30"), ("12:30:35"), ("1 12:30:31.32");
INSERT INTO t1 VALUES("19991101000000"), ("19990102030405"), ("19990630232922"), ("19990601000000");
INSERT INTO t1 VALUES('2004-01-01'), ('2004-02-29');
INSERT INTO t1 SELECT 1 FROM t1;
INSERT INTO t1 VALUES('2001-01-01 10:10:10.999993');
INSERT INTO t1 VALUES(0xADE5);
INSERT INTO t1 VALUES('');
INSERT INTO t1 SELECT * FROM t1;
INSERT INTO t1 VALUES('a');
INSERT INTO t1 VALUES('Z');
INSERT INTO t1 VALUES(12704);
INSERT INTO t1 VALUES('0.1');
INSERT INTO t1 VALUES('698aaaaaaaaaaaaaaaaaaaaaaaaaa');
INSERT INTO t1 VALUES(0xA9AA);
INSERT INTO t1 VALUES(unhex (hex (132)));
INSERT INTO t1 VALUES(1), (2), (1), (2), (1), (2), (3);
INSERT IGNORE INTO t1 VALUES(@inserted_value);
INSERT INTO t1 VALUES(15416);
UPDATE t1 SET a=( (SELECT MAX(a) FROM t1));
UPDATE t1 SET a=( (SELECT MAX(a) FROM t1));
UPDATE t1 SET a=( (SELECT MAX(a) FROM t1));
UPDATE t1 SET a=( (SELECT MAX(a) FROM t1));
UPDATE t1 SET a=( (SELECT MAX(a) FROM t1));
UPDATE t1 SET a=( (SELECT MAX(a) FROM t1));
UPDATE t1 SET a=( (SELECT MAX(a) FROM t1));
UPDATE t1 SET a=( (SELECT MAX(a) FROM t1));
UPDATE t1 SET a=( (SELECT MAX(a) FROM t1));
UPDATE t1 SET a=( (SELECT MAX(a) FROM t1));
UPDATE t1 SET a=( (SELECT MAX(a) FROM t1));
UPDATE t1 SET a=( (SELECT MAX(a) FROM t1));
UPDATE t1 SET a=( (SELECT MAX(a) FROM t1));
UPDATE t1 SET a=( (SELECT MAX(a) FROM t1));
UPDATE t1 SET a=( (SELECT MAX(a) FROM t1));
UPDATE t1 SET a=( (SELECT MAX(a) FROM t1));
UPDATE t1 SET a=( (SELECT MAX(a) FROM t1));
UPDATE t1 SET a=( (SELECT MAX(a) FROM t1));
INSERT INTO t1 VALUES('C'), ('c');
INSERT INTO t1 VALUES(1550);
INSERT INTO t1 VALUES('2001-01-01 00:00:01.000000');
INSERT INTO t1 VALUES('a');
INSERT INTO t1 VALUES(1), (3);
INSERT INTO t1 VALUES(0xACD4);
INSERT INTO t1 VALUES(0xABA8);
INSERT INTO t1 VALUES(1);
INSERT INTO t1 VALUES(0xF48F8080);
INSERT INTO t1 SELECT * FROM t1;
INSERT INTO t1 VALUES(0xA9A2);
INSERT t1 VALUES(30), (1230), ("1230"), ("12:30"), ("12:30:35"), ("1 12:30:31.32");
INSERT INTO t1 VALUES("19991101000000"), ("19990102030405"), ("19990630232922"), ("19990601000000");
INSERT INTO t1 VALUES('2004-01-01'), ('2004-02-29');
INSERT INTO t1 VALUES('2001-01-01 10:10:10.999993');
INSERT INTO t1 VALUES(0xADE5);
INSERT INTO t1 VALUES('');
INSERT INTO t1 SELECT * FROM t1;
INSERT INTO t1 VALUES('a');
INSERT INTO t1 VALUES('Z');
INSERT INTO t1 VALUES(12704);
INSERT INTO t1 VALUES('0.1');
INSERT INTO t1 VALUES('698aaaaaaaaaaaaaaaaaaaaaaaaaa');
INSERT INTO t1 VALUES(0xA9AA);
INSERT INTO t1 VALUES(unhex (hex (132)));
INSERT INTO t1 VALUES(1), (2), (1), (2), (1), (2), (3);
INSERT IGNORE INTO t1 VALUES(@inserted_value);
INSERT INTO t1 VALUES(15416);
UPDATE t1 SET a=( (SELECT MAX(a) FROM t1));
UPDATE t1 SET a=( (SELECT MAX(a) FROM t1));
XA END 'a';
USE test;
