diff options
Diffstat (limited to 'mysql-test/t/ps.test')
-rw-r--r-- | mysql-test/t/ps.test | 13 |
1 files changed, 13 insertions, 0 deletions
diff --git a/mysql-test/t/ps.test b/mysql-test/t/ps.test index 157b125a13d..7f65a7b04da 100644 --- a/mysql-test/t/ps.test +++ b/mysql-test/t/ps.test @@ -472,6 +472,19 @@ set @var=null; select @var is null, @var is not null, @var; execute stmt using @var, @var, @var; +# +# Bug#6873 "PS, having with subquery, crash during execute" +# check that if we modify having subtree, we update JOIN->having pointer +# +create table t1 (pnum char(3)); +create table t2 (pnum char(3)); +prepare stmt from "select pnum from t2 having pnum in (select 'p1' from t1)"; +execute stmt; +execute stmt; +execute stmt; +deallocate prepare stmt; +drop table t1, t2; + # # Bug#6102 "Server crash with prepared statement and blank after # function name" |