On Thu, Jan 9, 2014 at 10:18 AM, Dominique Devienne <ddevie...@gmail.com>wrote:
> On Thu, Jan 9, 2014 at 10:02 AM, Dan Kennedy <danielk1...@gmail.com>wrote: > >> On 01/09/2014 03:38 PM, Dominique Devienne wrote: >> >>> Someone will soon point out exactly what commit/bug was fixed in SQLite >>> I'm sure. >>> >> >> Probably this: >> http://www.sqlite.org/src/info/f2d175f975 >> >> Fix first appeared in 3.8.0. >> > > Thanks Dan. FWIW, the test cases added look more complex than the one from > this report. And the comments I read do seem to indicate that the ability > to use output column names ("as" aliases) in later clauses like group-by is > an SQLite extension over SQL indeed. --DD > Why made me think. There's a page in the doc listing what SQL SQLite does not support, but is there one about what "extensions" SQLite does support in its SQL "dialect" which are not standard SQL? This is obviously one such extension, and such a page (if it does not exist) would help write more portable SQL in SQLite, if users could be made aware of these subtle differences. My $0.02. --DD _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
