1
2
3
4
5
6
7
8
9
10
11
12
13
14
|
--echo #
--echo #test for LP Bug#611379
--echo #
create table t1 (a int not null);
insert into t1 values (1);
create table t2 (a int not null primary key);
insert into t2 values (10);
explain select sum(distinct t1.a) from t1,t2 where t1.a=t2.a;
explain select * from (select sum(distinct t1.a) from t1,t2 where t1.a=t2.a)
as t;
select sum(distinct t1.a) from t1,t2 where t1.a=t2.a;
select * from (select sum(distinct t1.a) from t1,t2 where t1.a=t2.a) as t;
drop table t1,t2;
|