diff options
Diffstat (limited to 'mysql-test/r/ps.result')
-rw-r--r-- | mysql-test/r/ps.result | 17 |
1 files changed, 17 insertions, 0 deletions
diff --git a/mysql-test/r/ps.result b/mysql-test/r/ps.result index c3e6e61ae9d..8d4b52e1b2e 100644 --- a/mysql-test/r/ps.result +++ b/mysql-test/r/ps.result @@ -5373,5 +5373,22 @@ drop procedure p; drop view v1; drop table t1; # +# MDEV-22591 Debug build crashes on EXECUTE IMMEDIATE '... WHERE ?' USING IGNORE +# +CREATE TABLE t1 (a INT); +EXECUTE IMMEDIATE 'SELECT * FROM t1 WHERE ?' USING IGNORE; +ERROR HY000: Default/ignore value is not supported for such parameter usage +EXECUTE IMMEDIATE 'SELECT * FROM t1 HAVING ?' USING IGNORE; +ERROR HY000: Default/ignore value is not supported for such parameter usage +EXECUTE IMMEDIATE 'SELECT * FROM t1 WHERE ?' USING 0; +a +EXECUTE IMMEDIATE 'SELECT * FROM t1 HAVING ?' USING 0; +a +DROP TABLE t1; +EXECUTE IMMEDIATE 'SHOW DATABASES WHERE ?' USING DEFAULT; +ERROR HY000: Default/ignore value is not supported for such parameter usage +EXECUTE IMMEDIATE 'SHOW DATABASES WHERE ?' USING 0; +Database +# # End of 10.2 tests # |