diff options
author | Michael Widenius <monty@askmonty.org> | 2014-01-02 15:51:02 +0200 |
---|---|---|
committer | Michael Widenius <monty@askmonty.org> | 2014-01-02 15:51:02 +0200 |
commit | c050b5fdf9564e5ffd98ff381c61504efdf69f99 (patch) | |
tree | b72ef2c5b3038c2e222e6ea844057169e0feaef5 /mysql-test/suite | |
parent | f8c7e3477f17488f546ab5d20c4fad6aa0577d01 (diff) | |
download | mariadb-git-c050b5fdf9564e5ffd98ff381c61504efdf69f99.tar.gz |
Fixed MDEV-5424: SELECT using ORDER BY DESC and LIMIT produces unexpected results (InnoDB/XtraDB)
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
Diffstat (limited to 'mysql-test/suite')
0 files changed, 0 insertions, 0 deletions