'select t1.* from t1'; select statements with wildcards on columns are not returning all records
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Drizzle |
Fix Released
|
Low
|
Stewart Smith |
Bug Description
Refer to alias.test, line 176.
Select statement with wildcard on column is not returning all records.
The same results were generated when when the create table was changed to MyISAM.
Variations of the select statements are not returning all records. See example of select statement listing below.
create table t1 (a int, b int, c int);
create table t2 (d int);
create table t3 (a1 int, b1 int, c1 int);
insert into t1 values(1,2,3);
insert into t1 values(11,22,33);
insert into t2 values(99);
select t1.* from t1;
a b c
1 2 3
drizzletest: Result content mismatch
select t2.* from t2;
d
99
drizzletest: Result content mismatch
Variations of the select statement with wildcards in the column also fail to produce the correct results.
select a, t1.* from t1;
select t1.*, a from t1;
select a, t1.*, b from t1;
select (select d from t2 where d > a), t1.* from t1;
select t1.*, (select a from t2 where d > a) from t1;
select a as 'x', t1.* from t1;
select t1.*, a as 'x' from t1;
select a as 'x', t1.*, b as 'x' from t1;
select (select d from t2 where d > a) as 'x', t1.* from t1;
select t1.*, (select a from t2 where d > a) as 'x' from t1;
All of these produce 'drizzletest: Result content mismatch' and do not produce all the results.
Related branches
- Drizzle Developers: Pending requested
-
Diff: 165 lines (+104/-27)2 files modifiedtests/r/alias.result (+77/-0)
tests/t/alias.test (+27/-27)
Changed in drizzle: | |
status: | Fix Committed → Fix Released |
This is not an error, but expected SQL behaviour.