On 9/7/18, Firecore wrote:
>
> It looks like the latest public version of sqlite v3.24.0 has an issue with
> processing queries with ORDER BY and LIMIT against some datasets.
Thanks for the bug report. The trouble ticket can be found at
On 07 Sep 2018, at 20:20, Richard Hipp wrote:
> On 9/7/18, Firecore wrote:
>>
>> It's easily reproduced with the sqlite3 client and db file available here
>> (https://www.dropbox.com/s/l1xofadq7vi5vjj/lock_issue.db?dl=0):
>
> I cannot reproduce it. It always runs instantly for me. I also ran
On 9/7/18, Stephen Chrzanowski wrote:
> I can reproduce this issue with the SQLite3.exe under Win7.
It depends on compile-time options. I have a repro case now.
--
D. Richard Hipp
d...@sqlite.org
___
sqlite-users mailing list
I can reproduce this issue with the SQLite3.exe under Win7. The first
sqlite3 was pulled from a sqlite3.exe I have somewhere in my path, I then
extracted the 3.24.0 version to the Ramdrive and executed from there. On
the first run, r:\sqlite3.exe did not exist.
R:\>sqlite3 lock_issue.db
SQLite
On 9/7/18, Firecore wrote:
>
> It's easily reproduced with the sqlite3 client and db file available here
> (https://www.dropbox.com/s/l1xofadq7vi5vjj/lock_issue.db?dl=0):
I cannot reproduce it. It always runs instantly for me. I also ran
it under valgrind with no issues reported.
--
D.
al Message-
From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On
Behalf Of Firecore
Sent: Friday, September 07, 2018 1:32 PM
To: sqlite-users@mailinglists.sqlite.org
Subject: [sqlite] Some queries with ORDER BY and LIMIT lock DB
Hi all -
It looks like the latest publ
Hi all -
It looks like the latest public version of sqlite v3.24.0 has an issue with
processing queries with ORDER BY and LIMIT against some datasets. In essence,
sqlite3_step returns SQLITE_LOCKED for some of these statments even if there
are no other active connections. We were able to
7 matches
Mail list logo