diff options
author | Alexander Barkov <bar@mariadb.org> | 2016-09-09 08:40:24 +0400 |
---|---|---|
committer | Alexander Barkov <bar@mariadb.org> | 2016-09-09 08:40:24 +0400 |
commit | de7f87708a156659e518bf4ccdb051e92a0a7521 (patch) | |
tree | e204b4265b02a61b6ad6660ecc8cd20dd9d58c2c /mysql-test/r/ps_ddl.result | |
parent | 8494039757a2f6353cc161e7824aab4fe2312d2a (diff) | |
download | mariadb-git-de7f87708a156659e518bf4ccdb051e92a0a7521.tar.gz |
MDEV-10702 Crash in SET STATEMENT FOR EXECUTE
Diffstat (limited to 'mysql-test/r/ps_ddl.result')
-rw-r--r-- | mysql-test/r/ps_ddl.result | 29 |
1 files changed, 29 insertions, 0 deletions
diff --git a/mysql-test/r/ps_ddl.result b/mysql-test/r/ps_ddl.result index dec0d12c455..fc1832260c5 100644 --- a/mysql-test/r/ps_ddl.result +++ b/mysql-test/r/ps_ddl.result @@ -2542,3 +2542,32 @@ EXECUTE stmt3; EXECUTE stmt3; DEALLOCATE PREPARE stmt3; DROP TEMPORARY TABLES tm, t1; +# +# Start of 10.1 tests +# +# +# MDEV-10702 Crash in SET STATEMENT FOR EXECUTE +# +CREATE TABLE t1 (a INT); +PREPARE stmt FROM 'INSERT INTO t1 VALUES (@@max_sort_length)'; +SET STATEMENT max_sort_length=2048 FOR EXECUTE stmt; +SELECT * FROM t1; +a +2048 +CREATE TRIGGER tr1 BEFORE INSERT ON t1 FOR EACH ROW SET NEW.a=NEW.a + 1; +SET STATEMENT max_sort_length=2048 FOR EXECUTE stmt; +SELECT * FROM t1; +a +2048 +1025 +DROP TRIGGER tr1; +SET STATEMENT max_sort_length=2048 FOR EXECUTE stmt; +SELECT * FROM t1; +a +2048 +1025 +1024 +DROP TABLE t1; +# +# End of 10.1 tests +# |