If I understand Dominique's post, Oracle works like SQLite 3.7.15 as well. Things only got confusing when we moved from discussing GROUP BY to discussing ORDER BY for some reason.
From: Richard Hipp <d...@sqlite.org> >To: General Discussion of SQLite Database <sqlite-users@sqlite.org> >Sent: Wednesday, August 14, 2013 12:40 PM >Subject: Re: [sqlite] name resolutionn in GROUP BY > > >On Wed, Aug 14, 2013 at 3:08 PM, Igor Tandetnik <i...@tandetnik.org> wrote: > >> >> Most DBMS allow sorting (and grouping) by arbitrary expressions, which >> means that the standard is not directly applicable. One has to extrapolate. >> > >PostgreSQL, MS-SQL, and SQLite 3.7.15 work one way. Oracle and SQLite >3.7.17 work the other. I think I'm going to revert SQLite to working as >does PostgreSQL. > >-- >D. Richard Hipp >d...@sqlite.org >_______________________________________________ >sqlite-users mailing list >sqlite-users@sqlite.org >http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users