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
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
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
>
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
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
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;
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
7 matches
Mail list logo