Debian Codegraph @

mysql-test/suite/sql_sequence/rebuild.test

raw
1 --source include/have_innodb.inc
2 --source include/have_perfschema.inc
3
4 --echo #
5 --echo # MDEV-15977 Assertion `! thd->in_sub_stmt' failed in trans_commit_stmt
6 --echo #
7
8 CREATE SEQUENCE s1 ENGINE=InnoDB;
9 ALTER TABLE s1 FORCE;
10 CREATE TABLE t1 (a INT) ENGINE=MyISAM;
11 CREATE TABLE t2 (b VARCHAR(64)) ENGINE=MyISAM;
12 CREATE TRIGGER tr1 BEFORE INSERT ON t1 FOR EACH ROW INSERT INTO t2 SELECT TABLE_NAME FROM INFORMATION_SCHEMA.PARTITIONS WHERE TABLE_SCHEMA='test';
13 INSERT INTO t1 VALUES (1);
14 --sorted_result
15 select * from t1;
16 --sorted_result
17 select * from t2;
18
19 # Cleanup
20 DROP TABLE t1, t2, s1;
21