From 0f43279cc472d82859960f5057e0ec98428459ee Mon Sep 17 00:00:00 2001 From: Oleksandr Byelkin Date: Mon, 6 Nov 2017 14:35:58 +0100 Subject: MDEV-13936: Server crashes in Time_and_counter_tracker::incr_loops Repeat reworked solution of procedures for all posible Sp (functions & triggers). --- mysql-test/t/trigger.test | 24 ++++++++++++++++++++++++ 1 file changed, 24 insertions(+) (limited to 'mysql-test/t/trigger.test') diff --git a/mysql-test/t/trigger.test b/mysql-test/t/trigger.test index a02dce34837..ff6f38b719d 100644 --- a/mysql-test/t/trigger.test +++ b/mysql-test/t/trigger.test @@ -2634,3 +2634,27 @@ INSERT INTO t1 VALUES ('a'); DROP TRIGGER t1_bi; DROP TABLE t1; +--echo # +--echo # MDEV-13936: Server crashes in Time_and_counter_tracker::incr_loops +--echo # + +CREATE TABLE t1 (i INT); +CREATE VIEW v1 AS SELECT * FROM t1 WHERE RAND() > 0.5; +CREATE TABLE t2 (a int); +CREATE TABLE t3 (a int); + +create trigger trg after insert on t2 for each row + INSERT INTO t3 SELECT MAX(i) FROM v1 UNION SELECT MAX(i) FROM v1; + +drop table t1; + +--error ER_NO_SUCH_TABLE +insert into t2 value (2); +CREATE TABLE t1 (i INT); +insert into t2 value (2); + +DROP VIEW v1; +DROP TABLE t1,t2,t3; + + +--echo End of 10.1 tests. -- cgit v1.2.1