|
http://buildbot.askmonty.org/buildbot/builders/kvm-fulltest/builds/19924
|
10.4 c1a2778e689030fcbb6cdc93d8c1f1d8
|
main.rowid_filter_innodb 'innodb' w2 [ fail ]
|
Test ended at 2019-09-07 05:41:19
|
|
CURRENT_TEST: main.rowid_filter_innodb
|
--- /mnt/buildbot/build/mariadb-10.4.8/mysql-test/main/rowid_filter_innodb.result 2019-09-07 03:37:56.000000000 -0400
|
+++ /mnt/buildbot/build/mariadb-10.4.8/mysql-test/main/rowid_filter_innodb.reject 2019-09-07 05:41:19.377566069 -0400
|
@@ -1634,7 +1634,7 @@
|
"key_length": "9",
|
"used_key_parts": ["o_totaldiscount"],
|
"rows": 41,
|
- "filtered": 2.0711,
|
+ "filtered": 2.0467,
|
"index_condition": "orders.o_totaldiscount between 18000 and 20000",
|
"attached_condition": "orders.o_totalprice between 200000 and 220000 and orders.o_orderDATE between '1992-12-01' and '1997-01-01'"
|
},
|
@@ -1664,7 +1664,7 @@
|
o_totalprice BETWEEN 200000 AND 220000 AND
|
l_shipdate BETWEEN '1996-10-01' AND '1996-12-01';
|
id select_type table type possible_keys key key_len ref rows r_rows filtered r_filtered Extra
|
-1 SIMPLE orders range PRIMARY,i_o_orderdate,i_o_totalprice,i_o_totaldiscount i_o_totaldiscount 9 NULL 41 41.00 2.07 2.44 Using index condition; Using where
|
+1 SIMPLE orders range PRIMARY,i_o_orderdate,i_o_totalprice,i_o_totaldiscount i_o_totaldiscount 9 NULL 41 41.00 2.05 2.44 Using index condition; Using where
|
1 SIMPLE lineitem ref PRIMARY,i_l_shipdate,i_l_orderkey,i_l_orderkey_quantity PRIMARY 4 dbt3_s001.orders.o_orderkey 4 6.00 3.05 66.67 Using where
|
set statement optimizer_switch='rowid_filter=on' for ANALYZE FORMAT=JSON SELECT o_totaldiscount, o_totalprice, l_shipdate
|
FROM v1, lineitem
|
@@ -1694,7 +1694,7 @@
|
"rows": 41,
|
"r_rows": 41,
|
"r_total_time_ms": "REPLACED",
|
- "filtered": 2.0711,
|
+ "filtered": 2.0467,
|
"r_filtered": 2.439,
|
"index_condition": "orders.o_totaldiscount between 18000 and 20000",
|
"attached_condition": "orders.o_totalprice between 200000 and 220000 and orders.o_orderDATE between '1992-12-01' and '1997-01-01'"
|
@@ -1765,7 +1765,7 @@
|
"key_length": "9",
|
"used_key_parts": ["o_totaldiscount"],
|
"rows": 41,
|
- "filtered": 2.0711,
|
+ "filtered": 2.0467,
|
"index_condition": "orders.o_totaldiscount between 18000 and 20000",
|
"attached_condition": "orders.o_totalprice between 200000 and 220000 and orders.o_orderDATE between '1992-12-01' and '1997-01-01'"
|
},
|
@@ -1795,7 +1795,7 @@
|
o_totalprice BETWEEN 200000 AND 220000 AND
|
l_shipdate BETWEEN '1996-10-01' AND '1996-12-01';
|
id select_type table type possible_keys key key_len ref rows r_rows filtered r_filtered Extra
|
-1 SIMPLE orders range PRIMARY,i_o_orderdate,i_o_totalprice,i_o_totaldiscount i_o_totaldiscount 9 NULL 41 41.00 2.07 2.44 Using index condition; Using where
|
+1 SIMPLE orders range PRIMARY,i_o_orderdate,i_o_totalprice,i_o_totaldiscount i_o_totaldiscount 9 NULL 41 41.00 2.05 2.44 Using index condition; Using where
|
1 SIMPLE lineitem ref PRIMARY,i_l_shipdate,i_l_orderkey,i_l_orderkey_quantity PRIMARY 4 dbt3_s001.orders.o_orderkey 4 6.00 3.05 66.67 Using where
|
set statement optimizer_switch='rowid_filter=off' for ANALYZE FORMAT=JSON SELECT o_totaldiscount, o_totalprice, l_shipdate
|
FROM v1, lineitem
|
@@ -1825,7 +1825,7 @@
|
"rows": 41,
|
"r_rows": 41,
|
"r_total_time_ms": "REPLACED",
|
- "filtered": 2.0711,
|
+ "filtered": 2.0467,
|
"r_filtered": 2.439,
|
"index_condition": "orders.o_totaldiscount between 18000 and 20000",
|
"attached_condition": "orders.o_totalprice between 200000 and 220000 and orders.o_orderDATE between '1992-12-01' and '1997-01-01'"
|
|
mysqltest: Result content mismatch
|
|