[sqlite] fts1, rowid, and insert ... select ... bug?

2006-10-13 Thread Glen Nakamura
Aloha, While testing the new full text search feature, I noticed the following: SQLite version 3.3.8 Enter ".help" for instructions sqlite> CREATE TABLE a (data TEXT); sqlite> INSERT INTO a VALUES ('some data'); sqlite> CREATE VIRTUAL TABLE b USING fts1 (data TEXT); sqlite> INSERT INTO b (ROWID,

Re: [sqlite] Please test prior to version 3.1.5. Was: Delete crashes with Version 3.2.4 in Windows XP

2005-08-26 Thread Glen Nakamura
On Wed, Aug 24, 2005 at 04:19:09PM -0400, D. Richard Hipp wrote: > On Wed, 2005-08-24 at 10:08 -1000, Glen Nakamura wrote: > > The problem could be the following lines in Makefile.in: > > > > # In LIBOBJ but not TESTSRC > > COMMONOBJ = $(foreach obj,$(LIBOBJ),

Re: [sqlite] Please test prior to version 3.1.5. Was: Delete crashes with Version 3.2.4 in Windows XP

2005-08-24 Thread Glen Nakamura
On Wed, Aug 24, 2005 at 02:50:04PM -0500, Jolan Luff wrote: > OpenBSD/amd64 with gcc 3.3.5. I noticed that with 3.2.2 it was possible > to run "make test" without having done "make" first and this is no > longer the case with CVS HEAD. The problem could be the following lines in Makefile.in: #

[sqlite] [PATCH] Fix --enable-threadsafe for version 3.2.3

2005-08-22 Thread Glen Nakamura
Aloha, The -DTHREADSAFE=1 option is added to the OPTS variable, but is not used when compiling the source files. I think the option needs to be added to the TCC variable instead... - glen diff -Nru3p sqlite-3.2.3.orig/Makefile.in sqlite-3.2.3/Makefile.in --- sqlite-3.2.3.orig/Makefile.in

[sqlite] Question regarding patch for Ticket 1198

2005-05-06 Thread Glen Nakamura
Aloha, I noticed symptoms of Ticket 1198 on my system and was looking over the patch to fix the problem: http://www.sqlite.org/cvstrac/chngview?cn=2447 After applying the patch, the default busy callback handler contains: if( count < NDELAY ){ delay = delays[count]; prior =