Comment 10 for bug 1370002

Revision history for this message
Roel Van de Paar (roel11) wrote :

Out of 100+ trials, here are 15 randomly selected & reduced testcases. They all look very similar, but I'll let you decide on what are duplicates or not. Each line is one seperate testcase. Having this fixed would be great as it means that many trials will not be stopped out with this bug.

DROP DATABASE test;CREATE DATABASE test;USE test;xa start'','';SET @@max_statement_time=10000;DROP TABLE t1;

DROP DATABASE test;CREATE DATABASE test;USE test;SET @@SESSION.max_statement_time=10;XA START'';DROP TABLE t1;

DROP DATABASE test;CREATE DATABASE test;USE test;SET max_statement_time=10000;XA START'';CREATE TABLE t1(c1 INT KEY)Engine=TokuDB;

DROP DATABASE test;CREATE DATABASE test;USE test;SET @@session.max_statement_time=TRUE;XA START'';CREATE TABLE t1(c1 INT KEY)Engine=FEDERATED;

DROP DATABASE test;CREATE DATABASE test;USE test;xa start'','';SET @@SESSION.max_statement_time=10;CREATE TABLE t1(c1 INT KEY)Engine=InnoDB;

DROP DATABASE test;CREATE DATABASE test;USE test;SET @@max_statement_time=10000;XA START'';DROP TABLE t1;

DROP DATABASE test;CREATE DATABASE test;USE test;XA START'';SET @@SESSION.max_statement_time=500;DROP TABLE t1;

DROP DATABASE test;CREATE DATABASE test;USE test;SET @@session.max_statement_time=TRUE;XA START'';DROP TABLE t1;

DROP DATABASE test;CREATE DATABASE test;USE test;XA START'';SET @@session.max_statement_time=65535;CREATE TABLE t1(c1 BLOB);

DROP DATABASE test;CREATE DATABASE test;USE test;XA START'';SET @@max_statement_time=10000;create TABLE t1(f1 INT,key k1 (f1)) engine=innodb;

DROP DATABASE test;CREATE DATABASE test;USE test;SET @@session.max_statement_time=65535;XA START'';CREATE TABLE t1(c1 INT KEY)Engine=TokuDB;

DROP DATABASE test;CREATE DATABASE test;USE test;xa start 'test1';SET max_statement_time=10000;DROP TABLE t3;

DROP DATABASE test;CREATE DATABASE test;USE test;XA START'';SET @@session.max_statement_time=10000;DROP TABLE t1;

DROP DATABASE test;CREATE DATABASE test;USE test;XA START 'test1';SET @@SESSION.max_statement_time=10;DROP TABLE t3;

DROP DATABASE test;CREATE DATABASE test;USE test;SET @@session.max_statement_time=50050;xa start 'test-bad';CREATE TABLE t1(c1 INT)Engine=ARCHIVE;