Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-39763

main.innodb_mrr_cpk fails under view protocol

    XMLWordPrintable

Details

    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

          Activity

            People

              Unassigned Unassigned
              danblack Daniel Black
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.