diff options
| author | Marko Mäkelä <marko.makela@mariadb.com> | 2020-05-19 21:18:15 +0300 |
|---|---|---|
| committer | Marko Mäkelä <marko.makela@mariadb.com> | 2020-05-19 21:18:15 +0300 |
| commit | 2bf93a8fd6d8d7563edc248183ca8b54a5d76dff (patch) | |
| tree | aeee1a3aeb5196092975248cb4e60760d9c40f4f /mysql-test/main/ps.test | |
| parent | 6b5f7ddc78e5e4796031fba27583d9b20504d529 (diff) | |
| parent | 294ac1fbab306e97dad3588a00e3527f2056e7e4 (diff) | |
| download | mariadb-git-2bf93a8fd6d8d7563edc248183ca8b54a5d76dff.tar.gz | |
Merge 10.3 into 10.4
Diffstat (limited to 'mysql-test/main/ps.test')
| -rw-r--r-- | mysql-test/main/ps.test | 17 |
1 files changed, 17 insertions, 0 deletions
diff --git a/mysql-test/main/ps.test b/mysql-test/main/ps.test index a3c9f12e582..e702cb76bbb 100644 --- a/mysql-test/main/ps.test +++ b/mysql-test/main/ps.test @@ -4914,6 +4914,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 # |