diff options
| author | Georgi Kodinov <joro@sun.com> | 2009-10-07 18:03:42 +0300 |
|---|---|---|
| committer | Georgi Kodinov <joro@sun.com> | 2009-10-07 18:03:42 +0300 |
| commit | 1a48dd4e2bf0c6353bbf76b1f9b768620e0aa090 (patch) | |
| tree | e8b98d4a75e63235bc86e6683cdea26c65b05c21 /sql/sql_select.h | |
| parent | 9226c847f5ac5424b50da07623e6e75a60725bc0 (diff) | |
| download | mariadb-git-1a48dd4e2bf0c6353bbf76b1f9b768620e0aa090.tar.gz | |
Bug #43029: FORCE INDEX FOR ORDER BY is ignored when join
buffering is used
FORCE INDEX FOR ORDER BY now prevents the optimizer from
using join buffering. As a result the optimizer can use
indexed access on the first table and doesn't need to
sort the complete resultset at the end of the statement.
Diffstat (limited to 'sql/sql_select.h')
| -rw-r--r-- | sql/sql_select.h | 2 |
1 files changed, 2 insertions, 0 deletions
diff --git a/sql/sql_select.h b/sql/sql_select.h index a0366d47149..3f06b402638 100644 --- a/sql/sql_select.h +++ b/sql/sql_select.h @@ -357,6 +357,8 @@ public: simple_xxxxx is set if ORDER/GROUP BY doesn't include any references to other tables than the first non-constant table in the JOIN. It's also set if ORDER/GROUP BY is empty. + Used for deciding for or against using a temporary table to compute + GROUP/ORDER BY. */ bool simple_order, simple_group; /** |