diff options
| author | Igor Babaev <igor@askmonty.org> | 2012-01-13 12:23:19 -0800 |
|---|---|---|
| committer | Igor Babaev <igor@askmonty.org> | 2012-01-13 12:23:19 -0800 |
| commit | 6dfe0956d64b41a2e4eda0f40feaad799cd84058 (patch) | |
| tree | fb9454c28ab6108098945bd2f5aea9aced2be773 /sql/table.cc | |
| parent | 22876a5495b5ddb9a310a56953a1b572946712c1 (diff) | |
| download | mariadb-git-6dfe0956d64b41a2e4eda0f40feaad799cd84058.tar.gz | |
Back-ported the test cases for bug #12763207 from mysql-5.6 code line into 5.2
Completed the fix for this bug.
Note: in 5.3 the affected 'if' statement in Item_in_subselect::single_value_transformer()
starting with the condition (thd->variables.sql_mode & MODE_ONLY_FULL_GROUP_BY)
should be removed altogether. The change from table.cc is not needed either.
This is because in 5.3
- min/max transformation for subqueries are done at the optimization phase
- evaluation of the expensive subqueries is done at the execution phase.
Added an EXPLAIN EXTENDED to the test case for bug #12329653.
Diffstat (limited to 'sql/table.cc')
| -rw-r--r-- | sql/table.cc | 1 |
1 files changed, 1 insertions, 0 deletions
diff --git a/sql/table.cc b/sql/table.cc index ca14b2ef4d2..a3df9023805 100644 --- a/sql/table.cc +++ b/sql/table.cc @@ -4467,6 +4467,7 @@ Item *Field_iterator_table::create_item(THD *thd) { select->non_agg_fields.push_back(item); item->marker= select->cur_pos_in_select_list; + select->set_non_agg_field_used(true); } return item; } |