I was using sqlite3.exe on windows xp when I discovered it.
Then, for confirmation, I ran the same set of commands on the same
version of sqlite3 (a version I think I compiled) on a linux machine and
got the same thing.
Then, for further confirmation, I *also* ran it on a FreeBSD machine
(where it was compiled from the ports collection) and got the same problem.
I can send you the coredump from each machine if you want.
[EMAIL PROTECTED] wrote:
"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]
-----------------------------------------------------------------------------
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
