~drizzle-trunk/drizzle/development

Merge for lp611379

added added

removed removed

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