pbxt.basic_pkey_index_reverse_scan [ fail ]
--- /home/stewart/drizzle/working/tests/../plugin/pbxt/tests/r/basic_pkey_index_reverse_scan.result 2010-09-17 05:14:16.099317742 +0300
+++ /home/stewart/drizzle/working/tests/../plugin/pbxt/tests/r/basic_pkey_index_reverse_scan.reject 2010-09-17 07:55:34.969350595 +0300
@@ -3,7 +3,7 @@
insert into t1 values (1),(2),(3);
explain select * from t1 order by a desc;
id select_type table type possible_keys key key_len ref rows Extra
-1 SIMPLE t1 index NULL PRIMARY 4 NULL 3 Using index
+1 SIMPLE t1 ALL NULL NULL NULL NULL 3 Using filesort
select * from t1 order by a desc;
a
3
also:
pbxt.basic_ pkey_index_ reverse_ scan [ fail ] drizzle/ working/ tests/. ./plugin/ pbxt/tests/ r/basic_ pkey_index_ reverse_ scan.result 2010-09-17 05:14:16.099317742 +0300 drizzle/ working/ tests/. ./plugin/ pbxt/tests/ r/basic_ pkey_index_ reverse_ scan.reject 2010-09-17 07:55:34.969350595 +0300
--- /home/stewart/
+++ /home/stewart/
@@ -3,7 +3,7 @@
insert into t1 values (1),(2),(3);
explain select * from t1 order by a desc;
id select_type table type possible_keys key key_len ref rows Extra
-1 SIMPLE t1 index NULL PRIMARY 4 NULL 3 Using index
+1 SIMPLE t1 ALL NULL NULL NULL NULL 3 Using filesort
select * from t1 order by a desc;
a
3
drizzletest: Result length mismatch