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/r/ps.result | |
| 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/r/ps.result')
| -rw-r--r-- | mysql-test/r/ps.result | 7 |
1 files changed, 7 insertions, 0 deletions
diff --git a/mysql-test/r/ps.result b/mysql-test/r/ps.result index b5a9367c985..000a9317b8d 100644 --- a/mysql-test/r/ps.result +++ b/mysql-test/r/ps.result @@ -1528,5 +1528,12 @@ a 1 2 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; +a +1 +2 +DEALLOCATE PREPARE stmt; DROP TABLE t1,t2; End of 5.0 tests. |