Re: [sqlite] Sqlite crash in two lines...

2007-08-15 Thread Christopher J. McKenzie
Ok great - I guess I need to check for upgrades more often. And as for what I was doing - well I have a program that generates queries (not very well it appears) and it would occasionally crash - when I tracked the bug down I was able to simplify it to two lines. Samuel R. Neff wrote: I get

RE: [sqlite] Sqlite crash in two lines...

2007-08-15 Thread Samuel R. Neff
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> crea

Re: [sqlite] Sqlite crash in two lines...

2007-08-15 Thread Christopher J. McKenzie
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

Re: [sqlite] Sqlite crash in two lines...

2007-08-15 Thread drh
"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 ".h