diff options
| author | Sergei Golubchik <serg@mariadb.org> | 2017-11-21 19:47:46 +0100 |
|---|---|---|
| committer | Sergei Golubchik <serg@mariadb.org> | 2017-11-21 19:47:46 +0100 |
| commit | 7f1900705b28a432a91595726f7d58e6d968cbd5 (patch) | |
| tree | a24724ebc45941490e2970d87c495bc5f5cbb64b /mysql-test/t/trigger.test | |
| parent | 375caf99c494a4add7d48d5db3a3ec4b409a256e (diff) | |
| parent | b54aeeb080aba2385204cdd09cba3eedbbf1b891 (diff) | |
| download | mariadb-git-7f1900705b28a432a91595726f7d58e6d968cbd5.tar.gz | |
Merge branch '10.1' into 10.2
Diffstat (limited to 'mysql-test/t/trigger.test')
| -rw-r--r-- | mysql-test/t/trigger.test | 27 |
1 files changed, 26 insertions, 1 deletions
diff --git a/mysql-test/t/trigger.test b/mysql-test/t/trigger.test index 5c65e3dd13b..46a013d1bc9 100644 --- a/mysql-test/t/trigger.test +++ b/mysql-test/t/trigger.test @@ -2643,8 +2643,33 @@ DROP TABLE t1; SET TIMESTAMP=DEFAULT; set time_zone= @@global.time_zone; +--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. + # -# MDEV-10915 Count number of exceuted triggers +# MDEV-10915 Count number of executed triggers # create table t1 (i int); |