main.desc_index_range 'innodb' w4 [ fail ]
|
Test ended at 2022-03-01 11:23:04
|
|
CURRENT_TEST: main.desc_index_range
|
--- D:/winx64-packages/build/src/mysql-test/main/desc_index_range.result 2022-03-01 10:22:18.000000000 +0000
|
+++ D:\winx64-packages\build\src\mysql-test\main\desc_index_range.reject 2022-03-01 11:23:04.506052100 +0000
|
@@ -207,7 +207,7 @@
|
# Must use ROR-intersect:
|
explain select * from t1 where b = 255 AND a IS NULL;
|
id select_type table type possible_keys key key_len ref rows Extra
|
-1 SIMPLE t1 index_merge a,b b,a 5,5 NULL 1 Using intersect(b,a); Using where; Using index
|
+1 SIMPLE t1 ref a,b b 5 const 2 Using where
|
select * from t1 where b = 255 AND a IS NULL;
|
pk a b
|
10000 NULL 255
|
|
mysqltest: Result length mismatch
|