Re: [sqlite] Faulty acceptance of non-aggregate value that is notin group by part of the SELECT statement

2011-10-11 Thread Frank Missel
> -Original Message- > From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users- > boun...@sqlite.org] On Behalf Of Petite Abeille > Sent: 12 October 2011 00:15 > > I wonder how much of that feature is intentional vs. accidental. To me it > looks more like an implementation detail leak

Re: [sqlite] Faulty acceptance of non-aggregate value that is notin group by part of the SELECT statement

2011-10-11 Thread Petite Abeille
On Oct 11, 2011, at 6:00 PM, Frank Missel wrote: > Yeah, a pragma strict would be great. I can't be the only one who would > rather make the queries more error proof. I wonder how much of that feature is intentional vs. accidental. To me it looks more like an implementation detail leak being

Re: [sqlite] Faulty acceptance of non-aggregate value that is notin group by part of the SELECT statement

2011-10-11 Thread Frank Missel
> Sometimes, you know that the value of a particular column is in fact unique > across the group (in which case it doesn't matter which row it's taken from). > This knowledge could come from invariants being maintained that are not > perhaps formally captured in the database schema, or else flow

Re: [sqlite] Faulty acceptance of non-aggregate value that is notin group by part of the SELECT statement

2011-10-11 Thread Igor Tandetnik
Frank Missel wrote: > As for the advantages, I just don't see how it could be practical to have an > arbitrary group value together with the total number of records in an > application. Sometimes, you know that the value of a particular column is in fact unique across the group