Viewing all changes in revision 2732.46.56.
- Committer: Igor Babaev
- Date: 2012-01-13 20:23:19 UTC
- mto: (3403.1.1 maria-5.3-merge) (3429.1.2 maria-5.3) (2732.53.2 maria-5.2) (3446.1.2 maria-5.3-trunk) (3556.1.1 work-5.3-mdev382) (3539.1.1 5.3-push)
- mto: This revision was merged to the branch mainline in revision 3405.
- Revision ID: igor@askmonty.org-20120113202319-8u2exriofkfz6dz4
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.
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.
expand all
collapse all
added
removed
