diff options
| author | sergefp@mysql.com <> | 2007-01-12 23:22:41 +0300 |
|---|---|---|
| committer | sergefp@mysql.com <> | 2007-01-12 23:22:41 +0300 |
| commit | c3f46e1f26ba092a700d3ccdee75ee8060d43ef4 (patch) | |
| tree | 89dced7ceab3b8f0b6983f1ecea0d1c59eedf0a1 /sql/item_cmpfunc.h | |
| parent | 52367948559d0b357c932db9fd6b9838a9bd54ed (diff) | |
| download | mariadb-git-c3f46e1f26ba092a700d3ccdee75ee8060d43ef4.tar.gz | |
BUG#24127: (a,b) IN (SELECT c,d ...) can produce wrong results if a and/or b are NULLs:
- Make the code produce correct result: use an array of triggers to turn on/off equalities for each
compared column. Also turn on/off optimizations based on those equalities.
- Make EXPLAIN output show "Full scan on NULL key" for tables for which we switch between
ref/unique_subquery/index_subquery and ALL access.
- index_subquery engine now has HAVING clause when it is needed, and it is
displayed in EXPLAIN EXTENDED
- Fix incorrect presense of "Using index" for index/unique-based subqueries (BUG#22930)
// bk trigger note: this commit refers to BUG#24127
Diffstat (limited to 'sql/item_cmpfunc.h')
| -rw-r--r-- | sql/item_cmpfunc.h | 1 |
1 files changed, 1 insertions, 0 deletions
diff --git a/sql/item_cmpfunc.h b/sql/item_cmpfunc.h index 7bdc90adcee..af98e51c55d 100644 --- a/sql/item_cmpfunc.h +++ b/sql/item_cmpfunc.h @@ -311,6 +311,7 @@ public: enum Functype functype() const { return TRIG_COND_FUNC; }; const char *func_name() const { return "trigcond"; }; bool const_item() const { return FALSE; } + bool *get_trig_var() { return trig_var; } }; class Item_func_not_all :public Item_func_not |