Re: [sqlite] [EXTERNAL] Difference between hex notation and string notation

2019-12-15 Thread Hick Gunter
The X'' notation returns a blob. LIKE works with strings. Comparing a string to a blob of the same content always returns false. -Ursprüngliche Nachricht- Von: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] Im Auftrag von Sascha Ziemann Gesendet: Freitag, 13.

[sqlite] SQL Murder Mystery

2019-12-15 Thread Simon Slavin
A little light relief: Chosen SQL variation is SQLite ! ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Persisting Database Lock Issue

2019-12-15 Thread Rowan Worth
On Fri, 13 Dec 2019 at 23:50, 고예찬 wrote: > Hello, I am experiencing `database is locked` error. I wonder if anyone has > gone through or resolved similar issue. > > To illustrate, I have a .db file with below settings: > ``` > PRAGMA journal_mode=WAL; > PRAGMA wal_autocheckpoint=128; > PRAGMA

Re: [sqlite] A crash bug in sqlite

2019-12-15 Thread Chris Brody
> Yes. I discovered the same thing independently. The previous fix was > subtly wrong. Please try the latest trunk version. Will there be a patch release, or should we just wait for the next minor? ___ sqlite-users mailing list

Re: [sqlite] Performance vs. memory trade-off question

2019-12-15 Thread Andy Bennett
Hi, (3) Each database connection uses about 72 KB less heap space. How much is this as a percentage of a freshly initialised connection and how much as a percentage of some kind of "typical" connection (is there even one?)? andy...@ashurst.eu.org http://www.ashurst.eu.org/

Re: [sqlite] Coding standard

2019-12-15 Thread Richard Hipp
On 12/12/19, Richard Hipp wrote: > On 12/12/19, Arthur Blondel wrote: > Authur sent me a spreadsheet with 432 warnings (not 32000 as > originally mentioned). Apparently the first list the OP sent was filtered to show only "security" warnings. Arthur sent me the complete list of 31859 warnings

Re: [sqlite] CVE-2019-19317

2019-12-15 Thread Gary R. Schmidt
On 15/12/2019 10:16, Yongheng Chen wrote: When we report the bugs, we said that they were from 3.31 version, but people in mitre changed them to 3.30.1. We just reported what we found. And the commit we reported in the bug report is referencing to the official GitHub repo. Of course the