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

main.subselect_sj2_jcl6 fails in buildbot

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Critical
    • Resolution: Fixed
    • 5.5(EOL)
    • 5.5.43
    • Tests
    • 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

              psergei Sergei Petrunia
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

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