"Christopher J. McKenzie" <[EMAIL PROTECTED]> wrote: > Try this: > > $ sqlite3 > SQLite version 3.4.0 > Enter ".help" for instructions > sqlite> create table test (field text); > sqlite> select * from test group by distinct field; > Segmentation fault > $ >
I get: SQLite version 3.4.0 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> So did you compile SQLite yourself or did you use a prebuilt binary? -- D. Richard Hipp <[EMAIL PROTECTED]> ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
