On Wed, Aug 14, 2013 at 12:22 PM, Rob Golsteijn
<rob.golste...@mapscape.eu>wrote:
> create table test(name);
> insert into test values (NULL);
> insert into test values ('abc');
>
> select count(),
> NULLIF(name,'abc') AS name
> from test
> group by lower(name);
>
So the question is, should the "name" symbol in the GROUP BY clause refer
to the original column name in the TEST table, or should it refer to the
result column called "name". SQLite version 3.7.15 picks the TEST table
column. Version 3.7.17 picks the result column.
Anybody know which is correct?
--
D. Richard Hipp
d...@sqlite.org
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
