diff options
Diffstat (limited to 'mysql-test/r/ps.result')
| -rw-r--r-- | mysql-test/r/ps.result | 16 |
1 files changed, 16 insertions, 0 deletions
diff --git a/mysql-test/r/ps.result b/mysql-test/r/ps.result index 81167bc85c0..77bfcb9eabb 100644 --- a/mysql-test/r/ps.result +++ b/mysql-test/r/ps.result @@ -5509,5 +5509,21 @@ id select_type table type possible_keys key key_len ref rows Extra NULL UNION RESULT <union2,3> ALL NULL NULL NULL NULL NULL DEALLOCATE PREPARE stmt; DROP TABLE t1; +# +# MDEV-16128: Server crash in Item_func::print_op on 2nd execution of PS +# +CREATE TABLE t1 (a2 varchar(10)); +CREATE TABLE t2 (u1 varchar(10) CHARACTER SET utf8 ); +CREATE TABLE t3 (u2 varchar(10) CHARACTER SET utf8); +PREPARE stmt FROM "SELECT t1.* FROM (t1 JOIN t2 ON (t2.u1 = t1.a2)) WHERE (EXISTS (SELECT 1 FROM t3 WHERE t3.u2 = t1.a2))"; +EXECUTE stmt; +a2 +# Without the patch second execution of the prepared statement +# would lead to server crash. +EXECUTE stmt; +a2 +# Clean up +DEALLOCATE PREPARE stmt; +DROP TABLE t1, t2, t3; # End of 10.2 tests # |