diff options
| author | unknown <sanja@montyprogram.com> | 2012-10-11 12:09:21 +0300 |
|---|---|---|
| committer | unknown <sanja@montyprogram.com> | 2012-10-11 12:09:21 +0300 |
| commit | 8215ce4695e743d313e92f4d30f412f79958439c (patch) | |
| tree | d4b7fd43f1f2221a9ddbf56edf9cc0c71f799174 /mysql-test | |
| parent | a9f9296891a6ca611878b930f5932f4dc3d9f2a6 (diff) | |
| download | mariadb-git-8215ce4695e743d313e92f4d30f412f79958439c.tar.gz | |
MDEV-3804:
MySQL fix for bug#11765413 removed (we have better and more general fix for the problem).
Test suite added.
Diffstat (limited to 'mysql-test')
| -rw-r--r-- | mysql-test/r/ps_1general.result | 11 | ||||
| -rw-r--r-- | mysql-test/t/ps_1general.test | 10 |
2 files changed, 21 insertions, 0 deletions
diff --git a/mysql-test/r/ps_1general.result b/mysql-test/r/ps_1general.result index d2f740a06f4..0a3d16cf48e 100644 --- a/mysql-test/r/ps_1general.result +++ b/mysql-test/r/ps_1general.result @@ -777,3 +777,14 @@ execute stmt1 ; prepare stmt1 from ' select * from t5 ' ; execute stmt1 ; drop table t1, t5, t9; +# +# testcase for bug#11765413 - Crash with dependent subquery and +# prepared statement +create table t1 (c1 int); +insert into t1 values (1); +prepare stmt1 from "select 1 from t1 where 1=(select 1 from t1 having c1)"; +execute stmt1; +1 +1 +drop prepare stmt1; +drop table t1; diff --git a/mysql-test/t/ps_1general.test b/mysql-test/t/ps_1general.test index b9e84d8d7df..812b1b5ff94 100644 --- a/mysql-test/t/ps_1general.test +++ b/mysql-test/t/ps_1general.test @@ -827,6 +827,16 @@ execute stmt1 ; drop table t1, t5, t9; +--echo # +--echo # testcase for bug#11765413 - Crash with dependent subquery and +--echo # prepared statement +create table t1 (c1 int); +insert into t1 values (1); +prepare stmt1 from "select 1 from t1 where 1=(select 1 from t1 having c1)"; +execute stmt1; +drop prepare stmt1; +drop table t1; + ##### RULES OF THUMB TO PRESERVE THE SYSTEMATICS OF THE PS TEST CASES ##### # # 0. You don't have the time to |