Older versions result in an SQL error: SQLite version 3.3.13 Enter ".help" for instructions sqlite> create table a (b); sqlite> select max(b) as q from a where q = 1; SQL error: misuse of aggregate:
Same on Linux, Solaris, and Win32 ----- Original Message ---- From: Daniel Zingaro <[EMAIL PROTECTED]> To: General Discussion of SQLite Database <sqlite-users@sqlite.org> Sent: Wednesday, November 26, 2008 12:18:42 PM Subject: [sqlite] Query Crashing SQLite Hi all, The following session crashes SQLite3.exe 3.6.6.2 on Windows XP: sqlite> create table a (b); sqlite> select max(b) as q from a where q = 1; SQLite prevents me from directly using max(b) in the 'where' clause, but I think it gets fooled by the alias. Thanks, Dan _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
