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

main.derived_opt, main.count_distinct2 failed with timeout in buildbot

    Details

    • Type: Bug
    • Status: Open (View Workflow)
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 10.0
    • Fix Version/s: 10.0
    • Component/s: Tests
    • Labels:
      None
    • Sprint:
      5.5.55

      Description

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

      main.count_distinct2                     w3 [ fail ]  timeout after 900 seconds
              Test ended at 2017-01-08 18:08:51
       
      Test case timeout after 900 seconds
       
      == /usr/local/mariadb-10.0.29-linux-x86_64/mysql-test/var/3/log/count_distinct2.log == 
      5
      select count(distinct n1), count(distinct n2) from t1;
      count(distinct n1)	count(distinct n2)
      2	3
      select count(distinct n2), n1 from t1 group by n1;
      count(distinct n2)	n1
      1	NULL
      1	1
      3	2
      drop table t1;
      create table t1 (n int default NULL);
      flush status;
      select count(distinct n) from t1;
      count(distinct n)
      5000
      show status like 'Created_tmp_disk_tables';
      Variable_name	Value
      Created_tmp_disk_tables	0
      drop table t1;
      create table t1 (s text);
      

      main.derived_opt                         w1 [ fail ]  timeout after 900 seconds
              Test ended at 2017-01-08 18:13:15
       
      Test case timeout after 900 seconds
       
      == /usr/local/mariadb-10.0.29-linux-x86_64/mysql-test/var/1/log/derived_opt.log == 
      1	a	3	c
      2	b	3	c
      3	c	3	c
      3	c	3	c
      explain select * from t1 as x1, (select * from t1) as x2;
      id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
      1	SIMPLE	x1	ALL	NULL	NULL	NULL	NULL	4	
      1	SIMPLE	t1	ALL	NULL	NULL	NULL	NULL	4	Using join buffer (flat, BNL join)
      drop table if exists  t2,t3;
      CREATE TABLE t2 (a int not null);
      insert into t2 values(1);
      select * from (select t1.*, t2.a as t2a from t1,t2 where t1.a=t2.a) t1;
      a	b	t2a
      1	a	1
      explain select * from (select t1.*, t2.a as t2a from t1,t2 where t1.a=t2.a) t1;
      id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
      1	SIMPLE	t2	system	NULL	NULL	NULL	NULL	1	
      1	SIMPLE	t1	ALL	NULL	NULL	NULL	NULL	4	Using where
      drop table t1, t2;
      create table t1(a int not null, t char(8), index(a));
      

        Attachments

          Issue Links

            Activity

              People

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

                Dates

                • Created:
                  Updated: