• unknown's avatar
    Fix for LP BUG#806071 · 813aaac5
    unknown authored
    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.
    813aaac5
errmsg.txt 409 KB