Geo Carncross wrote: > On Tue, 2006-06-20 at 09:45 +0200, Paul J Stevens wrote: >> Geo Carncross wrote: >> >>> Just FYI: VACUUM is no longer required in sqlite3- the database can >>> AutoVacuum as necessary. >> Great. > > This change is in the DIFF. > >>> ... and I thought we were stopping the REGEX stuff to take advantage of >>> the indexes where possible? >> Yes, but I've just been porting dbsqlite.c as-is, and the regex stuff >> was there. I guess Aaron's to blame there :-) > > Okay good. Then I have an excellent (I hope) solution to your > sensitive/insensitive problem. > > I haven't tested this (just built it)- but I wanted to get the idea > reviewed as soon as possible... If it's not the definition of hackish, I > don't know what is :)
There's something wrong with setting up the sqlite3_create_function calls. I keep getting: check_dbmail_deliver: Debug dbsqlite.c,db_query: INSERT INTO dbmail_users (userid,user_idnr,passwd,client_idnr,maxmail_size,encryption_type, last_login) VALUES ('testuser1',10005,'UNUSED',65535,'0','md5', CURRENT_TIMESTAMP()) check_dbmail_deliver: Error dbsqlite.ci,db_query: sqlite3_get_table failed: near "(": syntax error check_dbmail_deliver: Error db.c,db_user_create: query for adding user failed -- ________________________________________________________________ Paul Stevens paul at nfg.nl NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31 The Netherlands________________________________http://www.nfg.nl