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

main.subselect_sj2_jcl6 fails in buildbot

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Critical
    • Resolution: Fixed
    • Affects Version/s: 5.5
    • Fix Version/s: 5.5.43
    • Component/s: Tests
    • Labels:
      None

      Description

      http://buildbot.askmonty.org/buildbot/builders/kvm-bintar-centos5-amd64/builds/1246/steps/test/logs/stdio

      main.subselect_sj2_jcl6 'innodb_plugin'  w1 [ fail ]
              Test ended at 2015-03-17 20:35:53
       
      CURRENT_TEST: main.subselect_sj2_jcl6
      --- /usr/local/mariadb-5.5.42-linux-x86_64/mysql-test/r/subselect_sj2_jcl6,innodb_plugin.result~	2015-03-17 20:35:53.000000000 +0100
      +++ /usr/local/mariadb-5.5.42-linux-x86_64/mysql-test/r/subselect_sj2_jcl6,innodb_plugin.reject	2015-03-17 20:35:53.000000000 +0100
      @@ -1272,7 +1272,7 @@
       );
       id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
       1	PRIMARY	T3_0_	ref	PRIMARY,FK_T3_T2Id	PRIMARY	8	const	3	Using index; Start temporary
      -1	PRIMARY	T2_1_	eq_ref	PRIMARY,FK_T2_T1Id	PRIMARY	8	test.T3_0_.t2idref	1	Using join buffer (flat, BKA join); Key-ordered scan
      +1	PRIMARY	T2_1_	eq_ref	PRIMARY,FK_T2_T1Id	PRIMARY	8	test.T3_0_.t2idref	1	
       1	PRIMARY	T1_1_	eq_ref	PRIMARY	PRIMARY	8	test.T2_1_.t1idref	1	Using index
       1	PRIMARY	T2_0_	ref	FK_T2_T1Id	FK_T2_T1Id	8	test.T2_1_.t1idref	1	Using index; End temporary
       drop table t3,t2,t1;

      The test started failing with this revision:

      Change #46036

      Category None
      Changed by Sergei Petrunia <psergey@askmonty.org>
      Changed at Tue 17 Mar 2015 12:26:33
      Repository https://github.com/MariaDB/server
      Branch 5.5
      Revision c020d362b68d0cfad03cabdeef508ca22e26d485
      Comments

      MDEV-7474: Semi-Join's DuplicateWeedout strategy skipped ...

      JOIN::cur_dups_producing_tables was not maintained correctly in
      the cases of greedy optimization (search_depth < n_tables).

      Moved it to POSITION structure where it will be maintained automatically.

      Removed POSITION::prefix_dups_producing_tables since its value can now
      be calculated.

      Only InnoDB plugin combination fails.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                psergey Sergei Petrunia
                Reporter:
                elenst Elena Stepanova
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: