diff options
| author | unknown <tim@white.box> | 2001-06-28 03:06:23 -0400 |
|---|---|---|
| committer | unknown <tim@white.box> | 2001-06-28 03:06:23 -0400 |
| commit | 950a6871d908c3fba343b197693d0fab6aa2e370 (patch) | |
| tree | 8e1c3a62991f2a6d938de086708b15282d727add /mysql-test/r/order_by.result | |
| parent | f246b619153704f78ecc60361470f3f664fc6493 (diff) | |
| download | mariadb-git-950a6871d908c3fba343b197693d0fab6aa2e370.tar.gz | |
Implement ORDER BY DESC optimization, which reads values in descending
order directly from the index instead of using a filesort.
mysql-test/mysql-test-run.sh:
[ -n $SKIP_TEST ] --> [ -n "$SKIP_TEST" ]; portability fix
mysql-test/r/order_by.result:
Added test for ORDER BY DESC optimization
mysql-test/t/order_by.test:
Added test for ORDER BY DESC optimization
sql/opt_range.cc:
Added QUICK_SELECT_DESC class which implements ORDER BY DESC optimization.
sql/opt_range.h:
Added QUICK_SELECT_DESC class which implements ORDER BY DESC optimization.
sql/sql_select.cc:
Added QUICK_SELECT_DESC class which implements ORDER BY DESC optimization.
BitKeeper/etc/ignore:
Added .gdbinit .vimrc to the ignore list
BitKeeper/etc/logging_ok:
Logging to logging@openlogging.org accepted
Diffstat (limited to 'mysql-test/r/order_by.result')
| -rw-r--r-- | mysql-test/r/order_by.result | 56 |
1 files changed, 56 insertions, 0 deletions
diff --git a/mysql-test/r/order_by.result b/mysql-test/r/order_by.result index 74c8bd53af2..5c9e20c35a3 100644 --- a/mysql-test/r/order_by.result +++ b/mysql-test/r/order_by.result @@ -111,3 +111,59 @@ DateOfAction TransactionID member_id nickname voornaam 1 2 +table type possible_keys key key_len ref rows Extra +t1 index NULL a 20 NULL 10 Using index +a b c +1 NULL NULL +1 NULL b +1 1 NULL +1 1 b +1 1 b +2 0 a +2 0 b +2 1 a +2 1 b +2 1 c +table type possible_keys key key_len ref rows Extra +t1 index NULL a 20 NULL 10 Using index +a b c +2 1 c +2 1 b +2 1 a +2 0 b +2 0 a +1 1 b +1 1 b +1 1 NULL +1 NULL b +1 NULL NULL +table type possible_keys key key_len ref rows Extra +t1 range a a 20 NULL 2 where used; Using index +a b c +1 1 b +1 1 b +table type possible_keys key key_len ref rows Extra +t1 range a a 4 NULL 5 where used; Using index +a b c +1 1 b +1 1 b +1 1 NULL +table type possible_keys key key_len ref rows Extra +t1 range a a 9 NULL 7 where used; Using index +a b c +2 1 c +2 1 b +2 1 a +2 0 b +2 0 a +1 1 b +1 1 b +1 1 NULL +table type possible_keys key key_len ref rows Extra +t1 range a a 4 NULL 4 where used; Using index +a b c +1 1 b +1 1 b +1 1 NULL +1 NULL b +1 NULL NULL |