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));