Re: [sqlite] cannot set connection while a datareader is active

Stefano Ravagni wrote: > > Hello Joe, here my code for CloseDati to help you to reproduce the error > that i don't understand... > > ++ > Public Sub CloseDati() > > 'chiude i dati del datareader associati all'oggetto DATI cui > ' spesso sono attaccati anche

[sqlite] Windows Phone 8.1

I have used the SQLite on several Windows Store and Windows Phone projects including the latest version 3.8.4.3 on a Windows Phone 8 project from VS 2013, they all work Great. However the 3.8.4.3 version will not recognize in my latest Windows Phone 8.1 project. I am trying to use the new

Re: [sqlite] Bug with FTS3 parenthesis and ICU (2)

This is definitely a bug in sqlite. I have experienced it too. The problem stems from “getNextToken(…)” expecting to find the parentheses in the token delimiters (rather than the tokens themselves). The ICU tokenizer returns the parentheses as tokens, rather than ignoring them as delimiters as

Re: [sqlite] Bug with some combination of unique/partial indices

On Sat, Apr 12, 2014 at 5:04 PM, Alexander Bich wrote: > Hi there, > > I was trying to upgrade SQLite version in my C++ application from > 3.8.0.2 to 3.8.4.3. Unfortunately after upgrade my application became > experience major problems. I tracked down the bug and got an SQL >

Re: [sqlite] Bug with some combination of unique/partial indices

On Sun, 13 Apr 2014 06:55:09 -0400 Richard Hipp wrote: > The following simplified test case causes an assertion fault: > > CREATE TABLE t1(a,b); > CREATE UNIQUE INDEX t1ab ON t1(a,b); > CREATE INDEX t1b ON t1(b) WHERE b=1; > INSERT INTO t1(a,b) VALUES(123,456); > UPDATE OR

Re: [sqlite] Bug with some combination of unique/partial indices

On 13 Apr 2014, at 12:32pm, Tim Streater wrote: >> CREATE INDEX t1b ON t1(b) WHERE b=1; > > I get no assertion fault but rather a syntax error here on "where". Partial indexes were introduced in 3.8.0. See the last section of

Re: [sqlite] Database corruption issue

* Grzegorz Sikorski: > We do fsck on the startup. Occasionally, there are some errors, so we > decided to do 'fsck -p' to fix them before mounting the > filesystem. Here is how we then mount the actual filesystem: > /dev/mmcblk0p2 on /media/DATA type ext4 >

Re: [sqlite] Bug with some combination of unique/partial indices

On 13 Apr 2014 at 11:55, Richard Hipp wrote: > The UPDATE OR REPLACE also seems to be an essential component. The > following simplified test case causes an assertion fault: > > CREATE TABLE t1(a,b); > CREATE UNIQUE INDEX t1ab ON t1(a,b); > CREATE INDEX t1b ON t1(b) WHERE b=1;

Re: [sqlite] Bug with some combination of unique/partial indices

On Sat, Apr 12, 2014 at 5:04 PM, Alexander Bich wrote: > Hi there, > > I was trying to upgrade SQLite version in my C++ application from > 3.8.0.2 to 3.8.4.3. Unfortunately after upgrade my application became > experience major problems. I tracked down the bug and got an SQL >

[sqlite] Bug with some combination of unique/partial indices

Hi there, I was trying to upgrade SQLite version in my C++ application from 3.8.0.2 to 3.8.4.3. Unfortunately after upgrade my application became experience major problems. I tracked down the bug and got an SQL script which gives different result on different versions of SQLite. Original script