diff options
| author | unknown <sanja@montyprogram.com> | 2012-01-10 23:26:00 +0200 |
|---|---|---|
| committer | unknown <sanja@montyprogram.com> | 2012-01-10 23:26:00 +0200 |
| commit | cf31ccc33c2f5ac5e2ae92c672bd54cc7ce63107 (patch) | |
| tree | 5ecc3fc90fc3af76c08e9603dad95e3b735c6ccb /sql/sql_select.h | |
| parent | d21189d7759e8223e06ce28bc75b3a5c87da6db1 (diff) | |
| download | mariadb-git-cf31ccc33c2f5ac5e2ae92c672bd54cc7ce63107.tar.gz | |
Fix for LP BUG#908269 Wrong result with subquery in select list, EXISTS, constant MyISAM/Aria table.
Problem: When building the condition for JOIN::outer_ref_cond the optimizer forgot to take into account
that this condition could depend on constant tables as well.
Diffstat (limited to 'sql/sql_select.h')
| -rw-r--r-- | sql/sql_select.h | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/sql/sql_select.h b/sql/sql_select.h index 8b3da18c976..8b448130eaf 100644 --- a/sql/sql_select.h +++ b/sql/sql_select.h @@ -1111,6 +1111,7 @@ public: COND *conds; // ---"--- Item *conds_history; // store WHERE for explain COND *outer_ref_cond; ///<part of conds containing only outer references + COND *pseudo_bits_cond; // part of conds containing special bita TABLE_LIST *tables_list; ///<hold 'tables' parameter of mysql_select List<TABLE_LIST> *join_list; ///< list of joined tables in reverse order COND_EQUAL *cond_equal; @@ -1237,7 +1238,7 @@ public: rollup.state= ROLLUP::STATE_NONE; no_const_tables= FALSE; - outer_ref_cond= 0; + outer_ref_cond= pseudo_bits_cond= NULL; in_to_exists_where= NULL; in_to_exists_having= NULL; } |