diff options
| author | Oleksandr Byelkin <sanja@mariadb.com> | 2019-04-16 23:02:54 +0200 |
|---|---|---|
| committer | Oleksandr Byelkin <sanja@mariadb.com> | 2019-04-16 23:21:04 +0200 |
| commit | f202f3dfe638aabfb0615a4685c05c31d9137481 (patch) | |
| tree | 25076525fb61b5d75227f44a2ea2543f1721ca28 /mysql-test/main/ps.result | |
| parent | 653a56fd956f472e17522ea593696a64367472ac (diff) | |
| download | mariadb-git-f202f3dfe638aabfb0615a4685c05c31d9137481.tar.gz | |
MDEV-19263: Server crashes in mysql_handle_single_derived upon 2nd execution of PS
Fix case of prelocking placeholder
Diffstat (limited to 'mysql-test/main/ps.result')
| -rw-r--r-- | mysql-test/main/ps.result | 18 |
1 files changed, 18 insertions, 0 deletions
diff --git a/mysql-test/main/ps.result b/mysql-test/main/ps.result index 2bb817c8286..c9f89b94e41 100644 --- a/mysql-test/main/ps.result +++ b/mysql-test/main/ps.result @@ -5388,3 +5388,21 @@ drop table t1; # # End of 10.2 tests # +# +# MDEV-19263: Server crashes in mysql_handle_single_derived +# upon 2nd execution of PS +# +CREATE TABLE t1 (f INT); +CREATE VIEW v1 AS SELECT * FROM t1; +CREATE TRIGGER tr BEFORE INSERT ON t1 FOR EACH ROW INSERT INTO v1 SELECT * FROM x; +PREPARE stmt FROM "INSERT INTO v1 VALUES (1)"; +EXECUTE stmt; +ERROR 42S02: Table 'test.x' doesn't exist +EXECUTE stmt; +ERROR 42S02: Table 'test.x' doesn't exist +DEALLOCATE PREPARE stmt; +DROP VIEW v1; +DROP TABLE t1; +# +# End of 10.4 tests +# |