diff options
Diffstat (limited to 'mysql-test/main/innodb_ext_key,off.rdiff')
-rw-r--r-- | mysql-test/main/innodb_ext_key,off.rdiff | 49 |
1 files changed, 23 insertions, 26 deletions
diff --git a/mysql-test/main/innodb_ext_key,off.rdiff b/mysql-test/main/innodb_ext_key,off.rdiff index 752e70862d4..2164c56c5b5 100644 --- a/mysql-test/main/innodb_ext_key,off.rdiff +++ b/mysql-test/main/innodb_ext_key,off.rdiff @@ -3,7 +3,7 @@ select count(*) from lineitem where l_orderkey=130 and l_shipdate='1992-07-01'; id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE lineitem ref PRIMARY,i_l_shipdate,i_l_orderkey,i_l_orderkey_quantity i_l_shipdate 8 const,const 1 Using index -+1 SIMPLE lineitem ref PRIMARY,i_l_shipdate,i_l_orderkey,i_l_orderkey_quantity PRIMARY 4 const 5 Using where ++1 SIMPLE lineitem ref PRIMARY,i_l_shipdate,i_l_orderkey,i_l_orderkey_quantity i_l_shipdate 4 const 6 Using where; Using index flush status; select count(*) from lineitem where l_orderkey=130 and l_shipdate='1992-07-01'; count(*) @@ -12,7 +12,7 @@ Handler_read_key 1 Handler_read_last 0 -Handler_read_next 1 -+Handler_read_next 5 ++Handler_read_next 6 Handler_read_prev 0 Handler_read_retry 0 Handler_read_rnd 0 @@ -93,7 +93,7 @@ where l_shipdate='1992-07-01' and l_orderkey=130; id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE NULL NULL NULL NULL NULL NULL NULL Select tables optimized away -+1 SIMPLE lineitem ref PRIMARY,i_l_shipdate,i_l_orderkey,i_l_orderkey_quantity PRIMARY 4 const 5 Using where ++1 SIMPLE lineitem ref PRIMARY,i_l_shipdate,i_l_orderkey,i_l_orderkey_quantity i_l_shipdate 4 const 6 Using where; Using index flush status; select max(l_linenumber) from lineitem where l_shipdate='1992-07-01' and l_orderkey=130; @@ -102,7 +102,7 @@ Handler_read_key 1 Handler_read_last 0 -Handler_read_next 0 -+Handler_read_next 5 ++Handler_read_next 6 Handler_read_prev 0 Handler_read_retry 0 Handler_read_rnd 0 @@ -132,8 +132,8 @@ where l_shipdate='1992-07-01' and l_orderkey between 1 and 1000 or l_receiptdate='1992-07-01' and l_orderkey between 5001 and 6000; id select_type table type possible_keys key key_len ref rows Extra --1 SIMPLE lineitem index_merge i_l_shipdate,i_l_receiptdate i_l_shipdate,i_l_receiptdate 8,8 NULL 3 Using sort_union(i_l_shipdate,i_l_receiptdate); Using where -+1 SIMPLE lineitem index_merge i_l_shipdate,i_l_receiptdate i_l_shipdate,i_l_receiptdate 4,4 NULL 9 Using union(i_l_shipdate,i_l_receiptdate); Using where +-1 SIMPLE lineitem index_merge i_l_shipdate,i_l_receiptdate i_l_shipdate,i_l_receiptdate # NULL 3 Using sort_union(i_l_shipdate,i_l_receiptdate); Using where ++1 SIMPLE lineitem index_merge i_l_shipdate,i_l_receiptdate i_l_shipdate,i_l_receiptdate # NULL 9 Using union(i_l_shipdate,i_l_receiptdate); Using where flush status; select l_orderkey, l_linenumber from lineitem use index (i_l_shipdate, i_l_receiptdate) @@ -154,21 +154,18 @@ where l_shipdate='1992-07-01' and l_orderkey between 1 and 1000 or l_receiptdate='1992-07-01' and l_orderkey between 5001 and 6000; id select_type table type possible_keys key key_len ref rows Extra --1 SIMPLE lineitem index_merge PRIMARY,i_l_shipdate,i_l_receiptdate,i_l_orderkey,i_l_orderkey_quantity i_l_shipdate,i_l_receiptdate 8,8 NULL 3 Using sort_union(i_l_shipdate,i_l_receiptdate); Using where -+1 SIMPLE lineitem index_merge PRIMARY,i_l_shipdate,i_l_receiptdate,i_l_orderkey,i_l_orderkey_quantity i_l_shipdate,PRIMARY,i_l_receiptdate,PRIMARY 4,4,4,4 NULL 2 Using union(intersect(i_l_shipdate,PRIMARY),intersect(i_l_receiptdate,PRIMARY)); Using where +-1 SIMPLE lineitem index_merge PRIMARY,i_l_shipdate,i_l_receiptdate,i_l_orderkey,i_l_orderkey_quantity i_l_shipdate,i_l_receiptdate # NULL # Using ++1 SIMPLE lineitem index_merge PRIMARY,i_l_shipdate,i_l_receiptdate,i_l_orderkey,i_l_orderkey_quantity i_l_shipdate,PRIMARY,i_l_receiptdate,PRIMARY # NULL # Using flush status; select l_orderkey, l_linenumber from lineitem where l_shipdate='1992-07-01' and l_orderkey between 1 and 1000 -@@ -223,7 +223,7 @@ - Handler_read_first 0 - Handler_read_key 2 - Handler_read_last 0 +@@ -220,12 +220,12 @@ + 5959 3 + show status like 'handler_read_next'; + Variable_name Value -Handler_read_next 3 +Handler_read_next 9 - Handler_read_prev 0 - Handler_read_retry 0 - Handler_read_rnd 3 -@@ -233,7 +233,7 @@ + explain select max(l_orderkey) from lineitem where l_partkey between 1 and 10 group by l_partkey; id select_type table type possible_keys key key_len ref rows Extra @@ -177,7 +174,7 @@ flush status; select max(l_orderkey) from lineitem where l_partkey between 1 and 10 group by l_partkey; -@@ -251,9 +251,9 @@ +@@ -243,9 +243,9 @@ show status like 'handler_read%'; Variable_name Value Handler_read_first 0 @@ -190,7 +187,7 @@ Handler_read_prev 0 Handler_read_retry 0 Handler_read_rnd 0 -@@ -263,7 +263,7 @@ +@@ -255,7 +255,7 @@ select max(l_orderkey) from lineitem where l_suppkey in (1,4) group by l_suppkey; id select_type table type possible_keys key key_len ref rows Extra @@ -199,7 +196,7 @@ flush status; select max(l_orderkey) from lineitem where l_suppkey in (1,4) group by l_suppkey; -@@ -273,9 +273,9 @@ +@@ -265,9 +265,9 @@ show status like 'handler_read%'; Variable_name Value Handler_read_first 0 @@ -212,7 +209,7 @@ Handler_read_prev 0 Handler_read_retry 0 Handler_read_rnd 0 -@@ -291,7 +291,7 @@ +@@ -283,7 +283,7 @@ id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE part range i_p_retailprice i_p_retailprice 9 NULL # Using where; Using index 1 SIMPLE orders ref PRIMARY,i_o_orderdate i_o_orderdate 4 const # Using index @@ -221,7 +218,7 @@ flush status; select o_orderkey, p_partkey from part use index (i_p_retailprice), -@@ -305,7 +305,7 @@ +@@ -297,7 +297,7 @@ Handler_read_first 0 Handler_read_key 3 Handler_read_last 0 @@ -230,7 +227,7 @@ Handler_read_prev 0 Handler_read_retry 0 Handler_read_rnd 0 -@@ -322,8 +322,8 @@ +@@ -314,8 +314,8 @@ select * from t0, part ignore index (primary) where p_partkey=t0.a and p_size=1; id select_type table type possible_keys key key_len ref rows Extra @@ -241,7 +238,7 @@ select * from t0, part ignore index (primary) where p_partkey=t0.a and p_size=1; a p_partkey p_name p_mfgr p_brand p_type p_size p_container p_retailprice p_comment -@@ -502,7 +502,7 @@ +@@ -494,7 +494,7 @@ select * from t1, t3 where t3.col1=t1.a and t3.col2=t1.a and t3.pk1=t1.a; id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE t1 ALL NULL NULL NULL NULL # Using where @@ -250,7 +247,7 @@ drop table t1,t2,t3; # # Bug mdev-4340: performance regression with extended_keys=on -@@ -718,13 +718,13 @@ +@@ -710,13 +710,13 @@ select * from t1 force index(index_date_updated) where index_date_updated= 10 and index_id < 800; id select_type table type possible_keys key key_len ref rows Extra @@ -266,7 +263,7 @@ drop table t0,t1,t2; # # MDEV-11196: Error:Run-Time Check Failure #2 - Stack around the variable 'key_buff' -@@ -759,13 +759,14 @@ +@@ -751,13 +751,14 @@ "select_id": 1, "table": { "table_name": "t1", @@ -285,7 +282,7 @@ "index_condition": "t1.pk1 <= 5 and t1.pk2 <= 5 and t1.f2 = 'abc'", "attached_condition": "t1.f1 <= '3'" } -@@ -792,8 +793,8 @@ +@@ -784,8 +785,8 @@ "access_type": "range", "possible_keys": ["k1"], "key": "k1", |