[prev in list] [next in list] [prev in thread] [next in thread] 

List:       sqlite-users
Subject:    [sqlite] unexpected error with "GROUP BY 0"
From:       Mark Brand <mabrand () mabrand ! nl>
Date:       2018-05-30 9:32:14
Message-ID: 1ba3feef-d0ca-e22a-6c6f-15e3fa263dfd () mabrand ! nl
[Download RAW message or body]

Hi,

Is there a good reason for this error:

sqlite> SELECT   0 GROUP BY 0;
Error: 1st GROUP BY term out of range - should be between 1 and 1
sqlite> SELECT 0 GROUP BY 1;
0

_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[prev in list] [next in list] [prev in thread] [next in thread]