Re: [sqlite] Performance regression since 3.19.0

2020-01-25 Thread Peter Inglesby
Hi -- I've not heard anything more about this, and I don't see a bug listed at https://www.sqlite.org/src/rptview?rn=1. Will it be addressed as a bug? I hope I'm not coming across as demanding a fix -- I just want to make sure this hasn't fallen through the gaps! On Mon, 6 Jan 2020 at 20:24,

Re: [sqlite] SSL: cannot connect to host www3.sqlite.org:443 (Connection refused)

2020-01-25 Thread Richard Hipp
On 1/25/20, Richard Hipp wrote: > On 1/25/20, Domingo Alvarez Duarte wrote: >> Hello Richard ! >> >> Since yesterday I'm getting this message when trying to use fossil for >> sqlite3. > > Yeah. That machine went completely bonkers and I had to rebuild it > from scratch, using a new IP address.

Re: [sqlite] List of innocuous functions?

2020-01-25 Thread sky5walk
SELECT DISTINCT name FROM pragma_function_list --WHERE (flags & 0x20)!=0 -- no such column: flags ORDER BY name; Works if I drop the WHERE. Is there a special compile flag that must be used? On Fri, Jan 24, 2020 at 5:42 PM Brian Curley wrote: > separate but somewhat related question, based

Re: [sqlite] List of innocuous functions?

2020-01-25 Thread sky5walk
Doh! I'm on 3.30.0. Gotcha, thanks. On Sat, Jan 25, 2020 at 8:22 PM Richard Hipp wrote: > On 1/25/20, sky5w...@gmail.com wrote: > > SELECT DISTINCT name FROM pragma_function_list > > --WHERE (flags & 0x20)!=0 -- no such column: flags > > ORDER BY name; > > > > Works if I drop the WHERE. >

Re: [sqlite] List of innocuous functions?

2020-01-25 Thread Richard Hipp
On 1/25/20, sky5w...@gmail.com wrote: > SELECT DISTINCT name FROM pragma_function_list > --WHERE (flags & 0x20)!=0 -- no such column: flags > ORDER BY name; > > Works if I drop the WHERE. > Is there a special compile flag that must be used? You need to be using SQLite 3.31.0 or later. -- D.

[sqlite] SSL: cannot connect to host www3.sqlite.org:443 (Connection refused)

2020-01-25 Thread Domingo Alvarez Duarte
Hello Richard ! Since yesterday I'm getting this message when trying to use fossil for sqlite3. Autosync:  https://www3.sqlite.org/cgi/src SSL: cannot connect to host www3.sqlite.org:443 (Connection refused) Cheers ! ___ sqlite-users mailing list

Re: [sqlite] CVE-2019-16168

2020-01-25 Thread Richard Hipp
On 1/24/20, Naumowicz, Ken E wrote: > Hello, > > I need to know if there is a security patch for this CVE on Windows Server > 2012: > > Java SE Vulnerability CVE-2019-16168 Related to JavaFX (SQLite) <<<=== > https://www.symantec.com/security-center/vulnerabilities/writeup/111496 >> NO

Re: [sqlite] 64 bits version missing

2020-01-25 Thread Richard Hipp
On 1/23/20, Evert van Dijken wrote: > The 64-bits DLL is missing from the download page, Which download page are you looking at? -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org

Re: [sqlite] SSL: cannot connect to host www3.sqlite.org:443 (Connection refused)

2020-01-25 Thread Richard Hipp
On 1/25/20, Domingo Alvarez Duarte wrote: > Hello Richard ! > > Since yesterday I'm getting this message when trying to use fossil for > sqlite3. Yeah. That machine went completely bonkers and I had to rebuild it from scratch, using a new IP address. And because it used a new IP address, I

[sqlite] 64 bits version missing

2020-01-25 Thread Evert van Dijken
The 64-bits DLL is missing from the download page, -- Evert van Dijken ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Sqlite 3.31.0 breaks firefox and thunderbird

2020-01-25 Thread Ferdinand
Thank you for the suggestion, Warren. Bisect first pointed to commit df51ae19c1aa4c26, but sometime after that this segfault seemed to be fixed, a second bisect blamed commit 2ae77bd233570834: https://www.sqlite.org/src/info/2ae77bd233570834 I've attached a backtrace from a crash at this

[sqlite] CVE-2019-16168

2020-01-25 Thread Naumowicz, Ken E
Hello, I need to know if there is a security patch for this CVE on Windows Server 2012: Java SE Vulnerability CVE-2019-16168 Related to JavaFX (SQLite) <<<=== https://www.symantec.com/security-center/vulnerabilities/writeup/111496 > NO UPDATE/PATCH FOUND at SQLite - SQLite Homepage

Re: [sqlite] 64 bits version missing

2020-01-25 Thread Simon Slavin
On 23 Jan 2020, at 10:22pm, Evert van Dijken wrote: > The 64-bits DLL is missing from the download page, "sqlite-dll-win64-x64-331.zip" works without problems for me. Please try again, or tell us what other thing you're referring to. ___

Re: [sqlite] SSL: cannot connect to host www3.sqlite.org:443 (Connection refused)

2020-01-25 Thread Donald Griggs
And for anyone who might not be aware, there are official mirror servers including https://www.sqlite.org/cgi/src/doc/trunk/README.md ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org