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

main.subselect, main.subselect_no_exists_to_in, main.subselect_no_mat, main.subselect_no_opts failed in buildbot

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Fixed
    • 10.0
    • N/A
    • Tests
    • None

    Description

      Timeouts – happened a few times in April, logs not available:

      main.subselect                           w5 [ fail ]  timeout after 9000 seconds
              Test ended at 2016-04-26 22:55:19
       
      Test case timeout after 9000 seconds
       
      == /mnt/data/buildot/maria-slave/work-opensuse-amd64/build/mysql-test/var/5/log/subselect.log == 
      set optimizer_switch = 'subquery_cache=off';
      SELECT * FROM t1 WHERE ( 3, 3 ) NOT IN ( SELECT NULL, NULL ) OR a > 100;
      a
      SELECT *, ( 3, 3 ) NOT IN ( SELECT NULL, NULL ) FROM t1;
      a	( 3, 3 ) NOT IN ( SELECT NULL, NULL )
      1	NULL
      2	NULL
      3	NULL
      set optimizer_switch=@mdev367_optimizer_switch;
      DROP TABLE t1;
      #
      # MDEV-521 single value subselect transformation problem
      #
      CREATE TABLE t1 (f1 char(2), PRIMARY KEY (f1)) ENGINE=MyISAM;
      INSERT INTO t1 VALUES ('u1'),('u2');
      SELECT a.* FROM t1 a WHERE ( SELECT EXISTS ( SELECT 1 FROM t1 b WHERE b.f1 = a.f1 ) );
      f1
      u1
      u2
      FLUSH TABLES;
      

      main.subselect                           w2 [ fail ]  timeout after 900 seconds
              Test ended at 2016-04-26 13:09:12
       
      Test case timeout after 900 seconds
       
      == /usr/local/mariadb-10.0.24-linux-i686/mysql-test/var/2/log/subselect.log == 
      set optimizer_switch = 'subquery_cache=off';
      SELECT * FROM t1 WHERE ( 3, 3 ) NOT IN ( SELECT NULL, NULL ) OR a > 100;
      a
      SELECT *, ( 3, 3 ) NOT IN ( SELECT NULL, NULL ) FROM t1;
      a	( 3, 3 ) NOT IN ( SELECT NULL, NULL )
      1	NULL
      2	NULL
      3	NULL
      set optimizer_switch=@mdev367_optimizer_switch;
      DROP TABLE t1;
      #
      # MDEV-521 single value subselect transformation problem
      #
      CREATE TABLE t1 (f1 char(2), PRIMARY KEY (f1)) ENGINE=MyISAM;
      INSERT INTO t1 VALUES ('u1'),('u2');
      SELECT a.* FROM t1 a WHERE ( SELECT EXISTS ( SELECT 1 FROM t1 b WHERE b.f1 = a.f1 ) );
      f1
      u1
      u2
      FLUSH TABLES;
      

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              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.