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

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 10.0
    • Fix Version/s: N/A
    • Component/s: Tests
    • Labels:
      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

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

                Dates

                • Created:
                  Updated:
                  Resolved: