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 | 5faf23bf55ee7a7110514cf0cc7aeab96dc1013d (patch) | |
| tree | e8b98d4a75e63235bc86e6683cdea26c65b05c21 /sql/sql_select.h | |
| parent | 482503d2787b0f6d2c0fee005fe1840051176e12 (diff) | |
| download | mariadb-git-5faf23bf55ee7a7110514cf0cc7aeab96dc1013d.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; /** |