• unknown's avatar
    Bug #17212 results not sorted correctly by ORDER BY when using index · 41445430
    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
    41445430
innodb_mysql.test 3.04 KB