• Michael Widenius's avatar
    Fixed MDEV-5424: SELECT using ORDER BY DESC and LIMIT produces unexpected results (InnoDB/XtraDB) · c050b5fd
    Michael Widenius authored
    This only happend when using an ORDER BY on a primary key part, where all other key parts where constant.
    Remove of duplicated expressions in ORDER BY (as the old code did this in some strange cases)
    
    
    mysql-test/r/group_by.result:
      Fixed results to take into account that duplicate order by parts are now deleted
    mysql-test/r/group_by_innodb.result:
      Ensure extended keys are on
    mysql-test/r/innodb_ext_key.result:
      More tests
    mysql-test/r/order_by.result:
      More tests
    mysql-test/t/group_by.test:
      Fixed results to take into account that duplicate order by parts are now deleted
    mysql-test/t/group_by_innodb.test:
      Ensure extended keys are on
    mysql-test/t/innodb_ext_key.test:
      More tests
    mysql-test/t/order_by.test:
      More tests
    sql/sql_select.cc:
      Fixed bug where we looked at extended key parts when we shouldn't
      Remove of duplicated expressions in ORDER BY
    sql/table.cc:
      Indentation fixes
    c050b5fd
group_by_innodb.test 989 Bytes