diff options
| author | unknown <igor@olga.mysql.com> | 2006-12-13 21:08:25 -0800 |
|---|---|---|
| committer | unknown <igor@olga.mysql.com> | 2006-12-13 21:08:25 -0800 |
| commit | cbd1bd90786025b98b9e510f770c5e3a0f3b23c6 (patch) | |
| tree | d2a54ccb335e917d32f0e7f7c6cf236039ea34d5 /mysql-test/t/ps.test | |
| parent | 2f78d5ca81e39c55aa918758a1f9b4e46ce76d74 (diff) | |
| download | mariadb-git-cbd1bd90786025b98b9e510f770c5e3a0f3b23c6.tar.gz | |
Fixed bug #25027.
Blocked evaluation of constant objects of the classes
Item_func_is_null and Item_is_not_null_test at the
prepare phase in the cases when the objects used subqueries.
mysql-test/r/ps.result:
Extended test case for bug #25027.
mysql-test/t/ps.test:
Extended test case for bug #25027.
sql/sql_lex.cc:
Returned back the assertion in st_select_lex_unit::set_limit,
removed by the previous commit for this bug.
Diffstat (limited to 'mysql-test/t/ps.test')
| -rw-r--r-- | mysql-test/t/ps.test | 5 |
1 files changed, 5 insertions, 0 deletions
diff --git a/mysql-test/t/ps.test b/mysql-test/t/ps.test index 9386436a1fd..f6de2a40efa 100644 --- a/mysql-test/t/ps.test +++ b/mysql-test/t/ps.test @@ -1577,8 +1577,13 @@ SELECT a FROM t1 WHERE (SELECT b FROM t2) IS NULL; PREPARE stmt FROM 'SELECT a FROM t1 WHERE (SELECT b FROM t2) IS NULL'; EXECUTE stmt; +DEALLOCATE PREPARE stmt; +PREPARE stmt FROM 'SELECT a FROM t1 WHERE (SELECT b FROM t2 limit ?) IS NULL'; +SET @arg=1; +EXECUTE stmt USING @arg; DEALLOCATE PREPARE stmt; + DROP TABLE t1,t2; --echo End of 5.0 tests. |