Re: [sqlite] name resolution in GROUP BY

On 14 Aug 2013, at 7:13pm, Peter Aronson wrote: > I dug out my copy of THE GUIDE TO THE SQL STANDARD, 4th Edition, by Date and > Darwen, and it states (in a footnote on page 151) that name specified for a > scalar-expression in a SELECT clause can not be used in a WHERE,

Re: [sqlite] name resolution in GROUP BY

strictly on the derived table.   Peter From: Marc L. Allen <mlal...@outsitenetworks.com> >To: General Discussion of SQLite Database <sqlite-users@sqlite.org> >Sent: Wednesday, August 14, 2013 11:28 AM >Subject: Re: [sqlite] name resolution in GROUP BY > > >I understand.  My

Re: [sqlite] name resolution in GROUP BY

.   Peter From: Marc L. Allen <mlal...@outsitenetworks.com> >To: General Discussion of SQLite Database <sqlite-users@sqlite.org> >Sent: Wednesday, August 14, 2013 11:28 AM >Subject: Re: [sqlite] name resolution in GROUP BY > > >I understand.  My previous email had the v

Re: [sqlite] name resolution in GROUP BY

- - 3 z 3 y 3 x -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Richard Hipp Sent: Wednesday, August 14, 2013 2:26 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] name

Re: [sqlite] name resolution in GROUP BY

] On Behalf Of Richard Hipp Sent: Wednesday, August 14, 2013 2:26 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] name resolution in GROUP BY On Wed, Aug 14, 2013 at 2:18 PM, Marc L. Allen <mlal...@outsitenetworks.com>wrote: > Heh... I forgot.. both selects below are

Re: [sqlite] name resolution in GROUP BY

On Wed, Aug 14, 2013 at 2:18 PM, Marc L. Allen wrote: > Heh... I forgot.. both selects below are identical, as 'lower(m1)' is > incorrect. MS SQL does not permit further operations on the derived value. > I think you also missed the name ambiguity issue. The

Re: [sqlite] name resolution in GROUP BY

, August 14, 2013 2:17 PM To: Peter Aronson; General Discussion of SQLite Database Subject: Re: [sqlite] name resolution in GROUP BY I seem to recall having read that as well. I believe, however, that MySQL does allow it, but I think it defaults to base table when available. Also, a modified

Re: [sqlite] name resolution in GROUP BY

-Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Peter Aronson Sent: Wednesday, August 14, 2013 2:13 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] name resolution in GROUP BY I dug out my copy of THE GUIDE

Re: [sqlite] name resolution in GROUP BY

I dug out my copy of THE GUIDE TO THE SQL STANDARD, 4th Edition, by Date and Darwen, and it states (in a footnote on page 151) that name specified for a scalar-expression in a SELECT clause can not be used in a WHERE, GROUP BY or HAVING clause as it is a column in the derived table, not the