• unknown's avatar
    Bug #17212 results not sorted correctly by ORDER BY when using index · 5337f8ae
    unknown authored
      * don't use join cache when the incoming data set is already ordered
        for ORDER BY
        This choice must be made because join cache will effectively
        reverse the join order and the results will be sorted by the index
        of the table that uses join cache.
    
    
    mysql-test/r/innodb_mysql.result:
      Bug #17212 results not sorted correctly by ORDER BY when using index
        * Test suite for the bug
    mysql-test/t/innodb_mysql.test:
      Bug #17212 results not sorted correctly by ORDER BY when using index
        * Test suite for the bug
    sql/sql_select.cc:
      Bug #17212 results not sorted correctly by ORDER BY when using index
        * don't use join cache when the incoming data set is already sorted
    5337f8ae
sql_select.cc 295 KB