Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
12.3
Description
CURRENT_TEST: main.innodb_mrr_cpk
|
--- /home/dan/repos/mariadb-server-12.3/mysql-test/main/innodb_mrr_cpk.result 2026-03-04 11:35:07.883462572 +1100
|
+++ /home/dan/repos/mariadb-server-12.3/mysql-test/main/innodb_mrr_cpk.reject 2026-05-27 12:01:14.405979837 +1000
|
@@ -91,7 +91,7 @@
|
explain select * from t1, t2 where t1.a=t2.a;
|
id select_type table type possible_keys key key_len ref rows Extra
|
1 SIMPLE t2 ALL NULL NULL NULL NULL 3 Using where
|
-1 SIMPLE t1 ref PRIMARY PRIMARY 26 test.t2.a 1 Using where; Using join buffer (flat, BKA join); Key-ordered scan
|
+1 SIMPLE t1 ref PRIMARY PRIMARY 26 test.t2.a 250 Using where; Using join buffer (flat, BKA join); Key-ordered scan
|
select * from t1, t2 where t1.a=t2.a;
|
a b filler a b
|
a-1010=A 1010 filler a-1010=A 1010
|
@@ -140,7 +140,7 @@
|
explain select * from t1, t2 where t1.a=t2.a and t2.b + t1.b > 100;
|
id select_type table type possible_keys key key_len ref rows Extra
|
1 SIMPLE t2 ALL NULL NULL NULL NULL 3 Using where
|
-1 SIMPLE t1 ref PRIMARY PRIMARY 4 test.t2.a 1 Using where; Using join buffer (flat, BKA join); Key-ordered scan
|
+1 SIMPLE t1 ref PRIMARY PRIMARY 4 test.t2.a 100 Using where; Using join buffer (flat, BKA join); Key-ordered scan
|
select * from t1, t2 where t1.a=t2.a and t2.b + t1.b > 100;
|
a b c filler a b
|
set optimizer_switch='index_condition_pushdown=on';
|
 |
Result length mismatch
|
Rows varies signficantly. Fails in %50 of cases.
Attachments
Issue Links
- links to