Re: [sqlite] Is this a bug?

2008-07-04 Thread Alex Katebi
I am not sure about the email server. You're probably correct. I spent couple of painful hours on this issue. I just moved the error printf after finalize now. Thanks Roger! -Alex On Fri, Jul 4, 2008 at 7:03 PM, Roger Binns <[EMAIL PROTECTED]> wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash:

Re: [sqlite] Is this a bug?

2008-07-04 Thread Roger Binns
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Alex Katebi wrote: > I was able to get the attachment myself. It could be your email server. Are you sure? I was looking at the actual raw message. My mail server is postfix with messages funneled through clamassassin and spamassassin. It could be

Re: [sqlite] Is this a bug?

2008-07-04 Thread Roger Binns
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Alex Katebi wrote: > How about this one? Still no attachment. It is a mime message with two parts. The first is your message and the second is a mailing list information trailer. Roger -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.6

Re: [sqlite] Is this a bug?

2008-07-04 Thread Alex Katebi
How about this one? On Thu, Jul 3, 2008 at 9:39 PM, Roger Binns <[EMAIL PROTECTED]> wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > Alex Katebi wrote: > > sqlite3_errmsg(db) does not provide the correct error message but > > sqlite_exec(...) does. > > The message gets cleared on

[sqlite] rtree module crashes

2008-07-04 Thread Hartwig Wiesmann
Hi, I posted a while ago the mail attached below but did not receive any answer. If there is any better place to discuss it please let me know. When I compile SQLite using SQLITE_ENABLE_RTREE set to 1 SQLite will crash when opening a database (Mac OSX). The reason seems to be that in

Re: [sqlite] counting tables

2008-07-04 Thread Tim Streater
At 18:02 03/07/2008, Simon Davies wrote: >Hi Tim, > >select count(*) from sqlite_master; > >will return 0 on a brand new db > >Rgds, >Simon Thanks - that's a handy pointer. At 18:04 03/07/2008, Igor Tandetnik wrote: >Tim Streater <[EMAIL PROTECTED]> >wrote: > > As a work around I thought I

Re: [sqlite] Fuzzy Matching

2008-07-04 Thread D. Richard Hipp
On Jul 3, 2008, at 4:09 PM, John Stanton wrote: > I believe Sqlite implemens Soundex as standard. Thet might work for > you. If you compile with -DSQLITE_SOUNDEX=1 then there is an SQL function named soundex() built-in. That function takes a single argument and returns the soundex