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

2011-10-11 Thread Petite Abeille
On Oct 11, 2011, at 2:39 PM, Frank Missel wrote: >> SQLite allows this as an extension. When this happens, a value from an >> arbitrary row within the group is reported. This is often convenient. >> > Ha ha, you must be joking, right? Think about it as a, hmmm, practical joke.

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

2011-10-11 Thread Frank Missel
> > SQLite allows this as an extension. When this happens, a value from an > arbitrary row within the group is reported. This is often convenient. > Ha ha, you must be joking, right? Otherwise, you must enlighten me on how it could have a practical use to have an arbitrary value in the group

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

2011-10-11 Thread Igor Tandetnik
Frank Missel wrote: > I would have expected an error message here to the effect that a non > aggregate value was not part of the grouping. SQLite allows this as an extension. When this happens, a value from an arbitrary row within the group is reported. This is often