Re: [sqlite] Bug when modifying user-defined function with -1 arguments

At 01:32pm on 2012 April 06, Richard Hipp did write: > On Fri, Apr 6, 2012 at 1:54 PM, Jim Ursetto <jim+sql...@3e8.org> wrote: > > Create a function foo with 1 argument, encoding UTF8 > > Create a function foo with -1 arguments, encoding UTF8 > > Delete or modify foo

[sqlite] Bug when modifying user-defined function with -1 arguments

I believe there is a bug when deleting or modifying an existing function with nArg == -1, when there is also an existing function of the same name with nArg >= 0. It occurs because when nArg == -1, the match quality is always 6 for the first function encountered regardless of arity, assuming

Re: [sqlite] SQLite Transaction Rate and speed...

At 03:47am on 2009 March 08, VF did write: > CREATE UNIQUE INDEX MAP_IDX_$idx ON MAPPINGS_$idx (key, mapping); > CREATE INDEX KEY_IDX_$idx ON MAPPINGS_$idx(key); > > I am trying to do an upsert with the following logic: > > UPDATE MAPPINGS_$idx > SET counter = counter + 1 > , timeModified =

[sqlite] Proxy locking and NFS

Hello. The new Proxy Locking code for OS X says it is intended for AFP filesystems, but it seems it also addresses a cache coherency issue on NFS in general. Is that the case, and if so, should the option be made available for other UNIX systems? I am thinking of modifying my copy to allow it.

[sqlite] bail out patch

Hi, I created a patch which adds "-bail" and ".bail" commands to the sqlite3 shell. When bail is enabled, the shell will exit with a non-zero return code immediately upon encountering the first SQL error. This is useful when you pass a number of commands to the shell non-interactively and wish