diff options
author | Olivier Bertrand <bertrandop@gmail.com> | 2020-11-18 14:37:44 +0100 |
---|---|---|
committer | Olivier Bertrand <bertrandop@gmail.com> | 2020-11-18 14:37:44 +0100 |
commit | 9055db73d5b43b241730e643f220dfa5e35eb7c1 (patch) | |
tree | 972d9bf5049c7687702196c77281f4419ceba2df /mysql-test/t/ps.test | |
parent | 8771390dfd3a98ae47b76b5f262af76aa8232cd7 (diff) | |
parent | 9b30212f15e280bef6d2a9be212c3295e912b959 (diff) | |
download | mariadb-git-9055db73d5b43b241730e643f220dfa5e35eb7c1.tar.gz |
Commit new source and all recent changes.
Diffstat (limited to 'mysql-test/t/ps.test')
-rw-r--r-- | mysql-test/t/ps.test | 17 |
1 files changed, 17 insertions, 0 deletions
diff --git a/mysql-test/t/ps.test b/mysql-test/t/ps.test index b82394b56f6..90af3ff7ce1 100644 --- a/mysql-test/t/ps.test +++ b/mysql-test/t/ps.test @@ -4885,6 +4885,23 @@ drop procedure p; drop view v1; drop table t1; + +--echo # +--echo # MDEV-22591 Debug build crashes on EXECUTE IMMEDIATE '... WHERE ?' USING IGNORE +--echo # + +CREATE TABLE t1 (a INT); +--error ER_INVALID_DEFAULT_PARAM +EXECUTE IMMEDIATE 'SELECT * FROM t1 WHERE ?' USING IGNORE; +--error ER_INVALID_DEFAULT_PARAM +EXECUTE IMMEDIATE 'SELECT * FROM t1 HAVING ?' USING IGNORE; +EXECUTE IMMEDIATE 'SELECT * FROM t1 WHERE ?' USING 0; +EXECUTE IMMEDIATE 'SELECT * FROM t1 HAVING ?' USING 0; +DROP TABLE t1; +--error ER_INVALID_DEFAULT_PARAM +EXECUTE IMMEDIATE 'SHOW DATABASES WHERE ?' USING DEFAULT; +EXECUTE IMMEDIATE 'SHOW DATABASES WHERE ?' USING 0; + --echo # --echo # End of 10.2 tests --echo # |