diff options
| author | evgen@moonbone.local <> | 2007-02-10 00:00:07 +0300 |
|---|---|---|
| committer | evgen@moonbone.local <> | 2007-02-10 00:00:07 +0300 |
| commit | a24144636295d4f2a1d95477872c56c46e59bbff (patch) | |
| tree | 3d0a09437fbcbef918d34a77d0ba717620153d27 /sql/sql_lex.cc | |
| parent | 826178b0f22da5300fde714a4b9a6510059b2918 (diff) | |
| download | mariadb-git-a24144636295d4f2a1d95477872c56c46e59bbff.tar.gz | |
Bug#12122: The MERGE algorithm isn't applicable if the ORDER BY clause is
present.
A view created with CREATE VIEW ... ORDER BY ... cannot be resolved with
the MERGE algorithm, even when no other part of the CREATE VIEW statement
would require the view to be resolved using the TEMPTABLE algorithm.
The check for presence of the ORDER BY clause in the underlying select is
removed from the st_lex::can_be_merged() function.
The ORDER BY list of the underlying select is appended to the ORDER BY list
Diffstat (limited to 'sql/sql_lex.cc')
| -rw-r--r-- | sql/sql_lex.cc | 1 |
1 files changed, 0 insertions, 1 deletions
diff --git a/sql/sql_lex.cc b/sql/sql_lex.cc index a362e6c7fd2..ce76c35b33c 100644 --- a/sql/sql_lex.cc +++ b/sql/sql_lex.cc @@ -1751,7 +1751,6 @@ bool st_lex::can_be_merged() } return (selects_allow_merge && - select_lex.order_list.elements == 0 && select_lex.group_list.elements == 0 && select_lex.having == 0 && select_lex.with_sum_func == 0 && |