Re: [sqlite] Stored Procedure or Functions

2013-05-21 Thread Ron Fox
Actually in any scripting language that has a binding to sqlite it's trival to make a table that contains scripts (stored procedures), and then execute them by selecting the script out of the table etc. I have done this with Tcl. I can't imagine any other scripting language that can run a string

Re: [sqlite] Potential bug in crash-recovery code: unlink() and friends are not synchronous

2013-05-21 Thread Thanumalayan Sankaranarayana Pillai
Hi all, Did anyone look into this? I might be setting some config option wrong, so it would be great if you sent me a "you did something wrong" reply if you feel that I might have the wrong config (or might be doing something totally idiotic). I tested with a few other Linux machines and a few di

Re: [sqlite] Potential bug in crash-recovery code: unlink() and friends are not synchronous

2013-05-21 Thread Simon Slavin
On 21 May 2013, at 5:04pm, Thanumalayan Sankaranarayana Pillai wrote: > Did anyone look into this? I might be setting some config option wrong, > so it would be great if you sent me a "you did something wrong" reply if > you feel that I might have the wrong config (or might be doing something >

Re: [sqlite] Potential bug in crash-recovery code: unlink() and friends are not synchronous

2013-05-21 Thread Richard Hipp
On Tue, May 21, 2013 at 12:04 PM, Thanumalayan Sankaranarayana Pillai < madth...@cs.wisc.edu> wrote: > Hi all, > > Did anyone look into this? I might be setting some config option wrong, > so it would be great if you sent me a "you did something wrong" reply if > you feel that I might have the wro

[sqlite] Using "COLLATE nocase" with BETWEEN

2013-05-21 Thread Yongil Jang
I've found some unexpected result with "COLLATE" operator. I don't know what if it is a bug or my misunderstanding. Please, check below description. CREATE TABLE mytable (data); INSERT INTO "mytable" VALUES('abc'); INSERT INTO "mytable" VALUES('ABC'); INSERT INTO "mytable" VALUES('abc/'); INSERT I

Re: [sqlite] Using "COLLATE nocase" with BETWEEN

2013-05-21 Thread Yongil Jang
It works very well if I use "COLLATE" as like as follows. sqlite> select * from mytable where data between 'abc/' COLLATE nocase and 'abc0' COLLATE nocase; abc/ ABC/ abc/a ABC/A abc/b ABC/B abc0 ABC0 sqlite> select * from mytable where data between 'abc0' COLLATE nocase and 'abc/' COLLATE nocase;

Re: [sqlite] Potential bug in crash-recovery code: unlink() and friends are not synchronous

2013-05-21 Thread Thanumalayan Sankaranarayana Pillai
Thank you for your replies! I now fully understand (and appreciate) that the "ACI" part of transactions is the most important. Also, I didn't notice any of ACI being broken: SQLite guarantees those conditions really well. However, just to be clear, my "potential bug" affects out-of-the-box Fedora