diff options
| author | unknown <sanja@askmonty.org> | 2011-07-21 23:37:40 +0300 |
|---|---|---|
| committer | unknown <sanja@askmonty.org> | 2011-07-21 23:37:40 +0300 |
| commit | 813aaac51d2aaf0c582cbcd869fd48b948b90d66 (patch) | |
| tree | dd0723f7e841410ec714d4e52510f807ceddf754 /sql/opt_subselect.cc | |
| parent | c86ffc23ee737b258dc006669ccfb3600e6f4c2e (diff) | |
| download | mariadb-git-813aaac51d2aaf0c582cbcd869fd48b948b90d66.tar.gz | |
Fix for LP BUG#806071
In case of two views with subqueries it is dificult to decide about order of injected ORDER BY clauses.
A simple solution is just prohibit ORDER BY injection if there is other order by.
mysql-test/r/view.result:
New test added, old test changed.
mysql-test/t/view.test:
New test aded.
sql/share/errmsg.txt:
new warning added.
sql/sql_view.cc:
Inject ORDER BY only if there is no other one.
Warning about ignoring ORDER BY in this case for EXPLAIN EXTENDED.
Diffstat (limited to 'sql/opt_subselect.cc')
0 files changed, 0 insertions, 0 deletions