I get a crash with 3.3.12 but correct syntax error in 3.4.2 on Windows XP using exe's downloaded from sqlite.org.
Microsoft Windows XP [Version 5.1.2600] (C) Copyright 1985-2001 Microsoft Corp. C:\Documents and Settings\sam>sqlite3 SQLite version 3.3.12 Enter ".help" for instructions sqlite> create table test(field text); sqlite> select * from test group by distinct field; Crash. Windows creates a dmp file but I can't copy it or do anything with it (says in use). All I can do is send it to Microsoft--think they'd help? ;) Downloaded newer exe and... Microsoft Windows XP [Version 5.1.2600] (C) Copyright 1985-2001 Microsoft Corp. C:\Documents and Settings\sam>sqlite3 SQLite version 3.4.2 Enter ".help" for instructions sqlite> create table test(field text); sqlite> select * from test group by distinct field; SQL error: near "distinct": syntax error sqlite> No crash. Not sure what the OP is even trying to accomplish though.. it's certainly not valid SQL. Sam ------------------------------------------- We're Hiring! Seeking a passionate developer to join our team building products. Position is in the Washington D.C. metro area. If interested contact [EMAIL PROTECTED] ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
