SET SESSION aria_sort_buffer_size=18446744073709551615;
SET SESSION aria_repair_threads=18446744073709551615;
CREATE TABLE t1 (a VARCHAR(255));
INSERT INTO t1 VALUES('C'), ('c');
XA BEGIN 'a','ab';
INSERT INTO t1 VALUES('2001-01-01 00:00:01.000000'),('a'),(1),(3),(0xACD4),(0xABA8),(1),(0xF48F8080);
#DELETE FROM mysql.user WHERE USER='mysqltest_4';
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');
SET SESSION tmp_table_size=65535;
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));
USE test;
SET SESSION aria_sort_buffer_size=CAST(-1 AS UNSIGNED INT);
INSERT INTO t1 VALUES('C'), ('c');
INSERT INTO t1 VALUES(1550);
SET SESSION aria_repair_threads=CAST(-1 AS UNSIGNED INT);
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);
DELETE FROM mysql.user WHERE USER='mysqltest_4';
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');
SET SESSION tmp_table_size=65535;
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));
