On Wed, Aug 14, 2013 at 12:22 PM, Rob Golsteijn
<[email protected]>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
[email protected]
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
