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 /sql/item_cmpfunc.h | |
| 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 'sql/item_cmpfunc.h')
| -rw-r--r-- | sql/item_cmpfunc.h | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/sql/item_cmpfunc.h b/sql/item_cmpfunc.h index acad1e51bc9..faeee0d5567 100644 --- a/sql/item_cmpfunc.h +++ b/sql/item_cmpfunc.h @@ -1028,7 +1028,8 @@ public: else { args[0]->update_used_tables(); - if ((const_item_cache= !(used_tables_cache= args[0]->used_tables()))) + if ((const_item_cache= !(used_tables_cache= args[0]->used_tables())) && + !with_subselect) { /* Remember if the value is always NULL or never NULL */ cached_value= (longlong) args[0]->is_null(); |