diff options
| author | Oleksandr Byelkin <sanja@mariadb.com> | 2023-05-04 18:19:47 +0200 |
|---|---|---|
| committer | Oleksandr Byelkin <sanja@mariadb.com> | 2023-05-04 18:19:47 +0200 |
| commit | ba0433dc1ccbbf2a92ac40fc3e34339a822938f2 (patch) | |
| tree | f3283da1b844bc26efdd9e754332afe4c0f638d5 /mysql-test/main/view.test | |
| parent | 749c512911d36fbecc506b72694c473fcc8c2fd4 (diff) | |
| parent | 7973ffde0fede83049a1d611c379b9ee61dea9c9 (diff) | |
| download | mariadb-git-ba0433dc1ccbbf2a92ac40fc3e34339a822938f2.tar.gz | |
Merge branch '10.4' into 10.5
Diffstat (limited to 'mysql-test/main/view.test')
| -rw-r--r-- | mysql-test/main/view.test | 19 |
1 files changed, 19 insertions, 0 deletions
diff --git a/mysql-test/main/view.test b/mysql-test/main/view.test index 408c8eb2830..0556d612975 100644 --- a/mysql-test/main/view.test +++ b/mysql-test/main/view.test @@ -6684,4 +6684,23 @@ create algorithm=merge view v as drop table t1,t2,t3; +--echo # +--echo # MDEV-31189: Server crash or assertion failure in upon 2nd +--echo # execution of PS with views and HAVING +--echo # + +CREATE TABLE t (f INT); +INSERT INTO t VALUES (1),(2); # Optional, fails either way +CREATE VIEW v1 AS SELECT 1 AS a; +CREATE VIEW v2 AS SELECT a FROM v1; + +PREPARE stmt FROM "SELECT * FROM v2 HAVING 1 IN (SELECT f FROM t)"; +EXECUTE stmt; +EXECUTE stmt; + +# Cleanup +DROP VIEW v1; +DROP VIEW v2; +DROP TABLE t; + --echo # End of 10.4 tests |