Debian Codegraph @

mysql-test/suite/sql_sequence/rebuild.result

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