Logging: ./mysql-test-run rocksdb.index_merge_rocksdb2
|
vardir: /usr/share/mysql-test/var
|
Removing old var directory...
|
Creating var directory '/usr/share/mysql-test/var'...
|
Checking supported features...
|
Can't exec "patch": No such file or directory at ./mysql-test-run line 1979.
|
MariaDB Version 10.2.21-MariaDB
|
- SSL connections supported
|
Collecting tests...
|
Installing system database...
|
|
==============================================================================
|
|
TEST RESULT TIME (ms) or COMMENT
|
--------------------------------------------------------------------------
|
|
worker[1] Using MTR_BUILD_THREAD 300, with reserved ports 16000..16019
|
worker[1] mysql-test-run: WARNING: running this script as _root_ will cause some tests to be skipped
|
rocksdb.index_merge_rocksdb2 'write_prepared' [ fail ]
|
Test ended at 2019-01-25 22:26:51
|
|
CURRENT_TEST: rocksdb.index_merge_rocksdb2
|
--- /usr/share/mysql-test/plugin/rocksdb/rocksdb/r/index_merge_rocksdb2.result 2018-12-31 00:29:21.000000000 +0100
|
+++ /usr/share/mysql-test/plugin/rocksdb/rocksdb/r/index_merge_rocksdb2.reject 2019-01-25 22:26:51.250437614 +0100
|
@@ -26,7 +26,7 @@
|
test.t0 analyze status OK
|
explain select * from t0 where key1 < 3 or key1 > 1020;
|
id select_type table type possible_keys key key_len ref rows Extra
|
-1 SIMPLE t0 range i1 i1 4 NULL 2 Using index condition; Using where
|
+1 SIMPLE t0 range i1 i1 4 NULL 4 Using index condition; Using where
|
explain
|
select * from t0 where key1 < 3 or key2 > 1020;
|
id select_type table type possible_keys key key_len ref rows Extra
|
@@ -260,33 +260,33 @@
|
explain
|
select * from t0,t1 where (t0.key1=t1.key1) and ( t0.key1=3 or t0.key2=4);
|
id select_type table type possible_keys key key_len ref rows Extra
|
-1 SIMPLE t0 index_merge i1,i2 i1,i2 4,4 NULL # Using union(i1,i2); Using where
|
-1 SIMPLE t1 ref i1 i1 4 test.t0.key1 #
|
+1 SIMPLE t1 ALL i1 NULL NULL NULL #
|
+1 SIMPLE t0 ref i1,i2 i1 4 test.t1.key1 # Using where
|
explain
|
select * from t0,t1 where (t0.key1=t1.key1) and
|
(t0.key1=3 or t0.key2<4) and t1.key1=2;
|
id select_type table type possible_keys key key_len ref rows Extra
|
1 SIMPLE t0 ref i1,i2 i1 4 const 2 Using where
|
-1 SIMPLE t1 ref i1 i1 4 const 1
|
+1 SIMPLE t1 ref i1 i1 4 const 2
|
explain select * from t0,t1 where t0.key1 = 5 and
|
(t1.key1 = t0.key1 or t1.key8 = t0.key1);
|
id select_type table type possible_keys key key_len ref rows Extra
|
-1 SIMPLE t0 ref i1 i1 4 const 1
|
-1 SIMPLE t1 index_merge i1,i8 i1,i8 4,4 NULL 2 Using union(i1,i8); Using where; Using join buffer (flat, BNL join)
|
+1 SIMPLE t1 ALL i1,i8 NULL NULL NULL 0 Using where
|
+1 SIMPLE t0 ref i1 i1 4 const 2
|
explain select * from t0,t1 where t0.key1 < 3 and
|
(t1.key1 = t0.key1 or t1.key8 = t0.key1);
|
id select_type table type possible_keys key key_len ref rows Extra
|
-1 SIMPLE t0 range i1 i1 4 NULL # Using index condition
|
-1 SIMPLE t1 ALL i1,i8 NULL NULL NULL # Range checked for each record (index map: 0x81)
|
+1 SIMPLE t1 ALL i1,i8 NULL NULL NULL #
|
+1 SIMPLE t0 range i1 i1 4 NULL # Using index condition; Using where; Using join buffer (flat, BNL join)
|
explain select * from t1 where key1=3 or key2=4
|
union select * from t1 where key1<4 or key3=5;
|
id select_type table type possible_keys key key_len ref rows Extra
|
-1 PRIMARY t1 index_merge i1,i2 i1,i2 4,4 NULL 4 Using union(i1,i2); Using where
|
-2 UNION t1 index_merge i1,i3 i1,i3 4,4 NULL 4 Using sort_union(i1,i3); Using where
|
+1 PRIMARY t1 ALL i1,i2 NULL NULL NULL 0 Using where
|
+2 UNION t1 ALL i1,i3 NULL NULL NULL 0 Using where
|
NULL UNION RESULT <union1,2> ALL NULL NULL NULL NULL NULL
|
explain select * from (select * from t1 where key1 = 3 or key2 =3) as Z where key8 >5;
|
id select_type table type possible_keys key key_len ref rows Extra
|
-1 SIMPLE t1 index_merge i1,i2,i8 i1,i2 4,4 NULL 2 Using union(i1,i2); Using where
|
+1 SIMPLE t1 range i1,i2,i8 i8 4 NULL 2 Using index condition; Using where
|
create table t3 like t0;
|
insert into t3 select * from t0;
|
alter table t3 add key9 int not null, add index i9(key9);
|
@@ -392,10 +392,10 @@
|
8704
|
explain select * from t1 WHERE cola = 'foo' AND colb = 'bar';
|
id select_type table type possible_keys key key_len ref rows Extra
|
-1 SIMPLE t1 index_merge cola,colb cola,colb 3,3 NULL # Using intersect(cola,colb); Using where
|
+1 SIMPLE t1 ref cola,colb cola 3 const # Using index condition; Using where
|
explain select * from t1 force index(cola,colb) WHERE cola = 'foo' AND colb = 'bar';
|
id select_type table type possible_keys key key_len ref rows Extra
|
-1 SIMPLE t1 index_merge cola,colb cola,colb 3,3 NULL # Using intersect(cola,colb); Using where
|
+1 SIMPLE t1 ref cola,colb cola 3 const # Using index condition; Using where
|
drop table t1;
|
CREATE TABLE t1(a INT);
|
INSERT INTO t1 VALUES(1);
|
@@ -517,9 +517,8 @@
|
where t2.a=t1.a and (t3.a=t2.b or t3.b=t2.b or t3.b=t2.b+1));
|
id select_type table type possible_keys key key_len ref rows Extra
|
1 PRIMARY t1 ALL NULL NULL NULL NULL #
|
-1 PRIMARY <subquery2> eq_ref distinct_key distinct_key 4 func #
|
-2 MATERIALIZED t2 ALL NULL NULL NULL NULL #
|
-2 MATERIALIZED t3 ALL a,b NULL NULL NULL # Range checked for each record (index map: 0x3)
|
+1 PRIMARY t2 ALL NULL NULL NULL NULL # Using where
|
+1 PRIMARY t3 ALL a,b NULL NULL NULL # Range checked for each record (index map: 0x3); FirstMatch(t1)
|
select * from t1
|
where exists (select 1 from t2, t3
|
where t2.a=t1.a and (t3.a=t2.b or t3.b=t2.b or t3.b=t2.b+1));
|
@@ -603,7 +602,7 @@
|
64801
|
explain select key1,key2 from t1 where key1=100 and key2=100;
|
id select_type table type possible_keys key key_len ref rows Extra
|
-1 SIMPLE t1 index_merge key1,key2 key2,key1 5,5 NULL # Using intersect(key2,key1); Using where; Using index
|
+1 SIMPLE t1 index_merge key1,key2 key1,key2 5,5 NULL # Using intersect(key1,key2); Using where; Using index
|
select key1,key2 from t1 where key1=100 and key2=100;
|
key1 key2
|
100 100
|
@@ -789,7 +788,7 @@
|
Level Code Message
|
explain select pk from t1 where key1 = 1 and key2 = 1;
|
id select_type table type possible_keys key key_len ref rows Extra
|
-1 SIMPLE t1 ref key1,key2 key1 5 const 2 Using where
|
+1 SIMPLE t1 index_merge key1,key2 key2,key1 4,5 NULL 1 Using intersect(key2,key1); Using where; Using index
|
select pk from t1 where key2 = 1 and key1 = 1;
|
pk
|
26
|
@@ -1057,7 +1056,7 @@
|
FROM t1
|
WHERE c = 1 AND b = 1 AND d = 1;
|
id select_type table type possible_keys key key_len ref rows Extra
|
-1 SIMPLE t1 ref c,bd c 5 const 2 Using where
|
+1 SIMPLE t1 index_merge c,bd c,bd 5,10 NULL 1 Using intersect(c,bd); Using where; Using index
|
CREATE TABLE t2 ( a INT )
|
SELECT a
|
FROM t1
|
@@ -1110,7 +1109,7 @@
|
(((pk BETWEEN 141 AND 141) OR col_varchar_key <> 'l')
|
AND ((pk BETWEEN 141 AND 141) OR (col_int_key > 141)));
|
id select_type table type possible_keys key key_len ref rows Extra
|
-1 SIMPLE t1 index PRIMARY,col_int_key,col_varchar_key col_varchar_key 7 NULL 2 Using where; Using index
|
+1 SIMPLE t1 index PRIMARY,col_int_key,col_varchar_key col_varchar_key 7 NULL 4 Using where; Using index
|
SELECT col_int_key
|
FROM t1
|
WHERE col_varchar_key >= 'l' OR
|
@@ -1288,7 +1287,7 @@
|
);
|
explain select * from t1 where pk1 = 1 and pk2 < 80 and key1=0;
|
id select_type table type possible_keys key key_len ref rows Extra
|
-1 SIMPLE t1 range PRIMARY,key1 key1 12 NULL ROWS Using index condition
|
+1 SIMPLE t1 range PRIMARY,key1 PRIMARY 8 NULL ROWS Using where
|
select * from t1 where pk1 = 1 and pk2 < 80 and key1=0;
|
pk1 pk2 key1 key2 pktail1ok pktail2ok pktail3bad pktail4bad pktail5bad pk2copy badkey filler1 filler2
|
1 10 0 0 0 0 0 0 0 10 0 filler-data-10 filler2
|
@@ -1321,13 +1320,13 @@
|
1 SIMPLE t1 ref key1 key1 4 const ROWS Using where
|
explain select * from t1 where pk1 < 7500 and key1 = 10;
|
id select_type table type possible_keys key key_len ref rows Extra
|
-1 SIMPLE t1 range PRIMARY,key1 key1 8 NULL ROWS Using index condition
|
+1 SIMPLE t1 range PRIMARY,key1 PRIMARY 4 NULL ROWS Using where
|
explain select * from t1 where pktail1ok=1 and key1=10;
|
id select_type table type possible_keys key key_len ref rows Extra
|
-1 SIMPLE t1 index_merge key1,pktail1ok key1,pktail1ok 4,4 NULL 1 Using intersect(key1,pktail1ok); Using where
|
+1 SIMPLE t1 ref key1,pktail1ok key1 4 const 2 Using where
|
explain select * from t1 where pktail2ok=1 and key1=10;
|
id select_type table type possible_keys key key_len ref rows Extra
|
-1 SIMPLE t1 index_merge key1,pktail2ok key1,pktail2ok 4,4 NULL 1 Using intersect(key1,pktail2ok); Using where
|
+1 SIMPLE t1 ref key1,pktail2ok key1 4 const 2 Using where
|
explain select * from t1 where (pktail2ok=1 and pk1< 50000) or key1=10;
|
id select_type table type possible_keys key key_len ref rows Extra
|
1 SIMPLE t1 index_merge PRIMARY,key1,pktail2ok PRIMARY,key1 4,4 NULL ROWS Using union(PRIMARY,key1); Using where
|
@@ -1393,7 +1392,7 @@
|
WHERE (SELECT COUNT(*) FROM t2 WHERE t2.f3 = 'h' AND t2.f2 = t1.f1) = 0 AND t1.f1 = 2;
|
id select_type table type possible_keys key key_len ref rows Extra
|
1 PRIMARY t1 const PRIMARY PRIMARY 4 const 1 Using index
|
-2 SUBQUERY t2 ref f2,f3 f2 5 const 1 Using where
|
+2 SUBQUERY t2 index_merge f2,f3 f3,f2 2,5 NULL 1 Using intersect(f3,f2); Using where; Using index
|
DROP TABLE t1,t2;
|
set global rocksdb_force_flush_memtable_now=1;
|
#
|
@@ -1412,5 +1411,5 @@
|
INSERT INTO t1 SELECT id + 16, 7, 0 FROM t1;
|
EXPLAIN SELECT SQL_NO_CACHE count(*) FROM t1 WHERE id2=7 AND id3=0;
|
id select_type table type possible_keys key key_len ref rows Extra
|
-1 SIMPLE t1 ref id2,id3,covering_index covering_index 8 const,const 1 Using index
|
+1 SIMPLE t1 ref id2,id3,covering_index covering_index 8 const,const 2 Using index
|
DROP TABLE t1;
|
|
mysqltest: Result length mismatch
|
|
- saving '/usr/share/mysql-test/var/log/rocksdb.index_merge_rocksdb2-write_prepared/' to '/usr/share/mysql-test/var/log/rocksdb.index_merge_rocksdb2-write_prepared/'
|
|
Only 1 of 2 completed.
|
--------------------------------------------------------------------------
|
The servers were restarted 0 times
|
Spent 0.000 of 42 seconds executing testcases
|
|
Failure: Failed 1/1 tests, 0.00% were successful.
|
|
Failing test(s): rocksdb.index_merge_rocksdb2
|