|
1701.2.2
by Stewart Smith
fix query plan results fro bug lp611379 |
1 |
#
|
|
1701.2.1
by Stewart Smith
bug lp:611379 Equivalent queries with Impossible where return different results |
2 |
#test for LP Bug#611379
|
3 |
#
|
|
4 |
create table t1 (a int not null);
|
|
5 |
insert into t1 values (1);
|
|
6 |
create table t2 (a int not null primary key);
|
|
7 |
insert into t2 values (10);
|
|
8 |
explain select sum(distinct t1.a) from t1,t2 where t1.a=t2.a;
|
|
9 |
id select_type table type possible_keys key key_len ref rows Extra
|
|
|
1701.2.2
by Stewart Smith
fix query plan results fro bug lp611379 |
10 |
1 SIMPLE t1 ALL NULL NULL NULL NULL 1
|
11 |
1 SIMPLE t2 eq_ref PRIMARY PRIMARY 4 test.t1.a 1 Using index
|
|
|
1701.2.1
by Stewart Smith
bug lp:611379 Equivalent queries with Impossible where return different results |
12 |
explain select * from (select sum(distinct t1.a) from t1,t2 where t1.a=t2.a)
|
13 |
as t;
|
|
14 |
id select_type table type possible_keys key key_len ref rows Extra
|
|
15 |
1 PRIMARY <derived2> system NULL NULL NULL NULL 1
|
|
|
1701.2.2
by Stewart Smith
fix query plan results fro bug lp611379 |
16 |
2 DERIVED t1 ALL NULL NULL NULL NULL 1
|
17 |
2 DERIVED t2 eq_ref PRIMARY PRIMARY 4 test.t1.a 1 Using index
|
|
|
1701.2.1
by Stewart Smith
bug lp:611379 Equivalent queries with Impossible where return different results |
18 |
select sum(distinct t1.a) from t1,t2 where t1.a=t2.a;
|
19 |
sum(distinct t1.a)
|
|
20 |
NULL
|
|
21 |
select * from (select sum(distinct t1.a) from t1,t2 where t1.a=t2.a) as t;
|
|
22 |
sum(distinct t1.a)
|
|
23 |
NULL
|
|
24 |
drop table t1,t2;
|