diff options
author | unknown <bell@50.0.168.192.in-addr.arpa> | 2005-08-13 07:45:14 +0300 |
---|---|---|
committer | unknown <bell@50.0.168.192.in-addr.arpa> | 2005-08-13 07:45:14 +0300 |
commit | 19b4760f19ee2551e38ed086c20e15d29dee644a (patch) | |
tree | 2232e8d1a329fa5860b90bd9f65f6780dfda8cf7 /sql/item_cmpfunc.h | |
parent | dbfc9b741dd4b5b77a538fa57448b97238580a47 (diff) | |
download | mariadb-git-19b4760f19ee2551e38ed086c20e15d29dee644a.tar.gz |
fixed convertion and handling IN subqueries with rows (BUG#11867)
mysql-test/r/subselect.result:
testst of IN subqueries with row
mysql-test/t/subselect.test:
tests of ion subqueries with row
sql/item.h:
add method to prevent of removing Item_ref_null_helper from HAVING
sql/item_cmpfunc.h:
Prevented removing of Item_test_isnotnull from HAVING
sql/item_subselect.cc:
fixed converting row IN subqueries
sql/sql_select.cc:
fixed debug print
Diffstat (limited to 'sql/item_cmpfunc.h')
-rw-r--r-- | sql/item_cmpfunc.h | 5 |
1 files changed, 5 insertions, 0 deletions
diff --git a/sql/item_cmpfunc.h b/sql/item_cmpfunc.h index 525f269e528..47884f6064e 100644 --- a/sql/item_cmpfunc.h +++ b/sql/item_cmpfunc.h @@ -832,6 +832,11 @@ public: longlong val_int(); const char *func_name() const { return "<is_not_null_test>"; } void update_used_tables(); + /* + we add RAND_TABLE_BIT to prevent moving this item from HAVING to WHERE + */ + table_map used_tables() const + { return used_tables_cache | RAND_TABLE_BIT; } }; |