Re: [sqlite] [regression] SQLite 3.8.7 causes Evolution to crash

On Wed, Oct 22, 2014 at 5:14 PM, Paul Menzel < paulepan...@users.sourceforge.net> wrote: > Dear SQLite folks, > > > after the upgrade of libsqlite3 from 3.8.6 to 3.8.7 Evolution crashes > with a segmentation fault. > > pool[6371]: segfault at 0 ip (null) sp a67d26ec error 14 > > Several

Re: [sqlite] Performance regression in Banshee with sqlite 3.8.7 on Arch Linux

Thanks for sending in the performance regression report. On Wed, Oct 22, 2014 at 1:51 PM, Tomislav Ljubej wrote: > Hello, > > There is a performance regression in the media player Banshee on the > query that is in the attachment. The query takes about 13 seconds on > my i7

[sqlite] [regression] SQLite 3.8.7 causes Evolution to crash

Dear SQLite folks, after the upgrade of libsqlite3 from 3.8.6 to 3.8.7 Evolution crashes with a segmentation fault. pool[6371]: segfault at 0 ip (null) sp a67d26ec error 14 Several people have reproduced this [1]. Milan, one of the main developers of Evolution, analyzed the crash a

[sqlite] [regression] SQLite 3.8.7 causes Evolution to crash

Dear SQLite folks, after the upgrade of libsqlite3 from 3.8.6 to 3.8.7 Evolution crashes with a segmentation fault. pool[6371]: segfault at 0 ip (null) sp a67d26ec error 14 Several people have reproduced this [1]. Milan, one of the main developers of Evolution, analyzed the crash a

[sqlite] Performance regression in Banshee with sqlite 3.8.7 on Arch Linux

Hello, There is a performance regression in the media player Banshee on the query that is in the attachment. The query takes about 13 seconds on my i7 4770 processor. I tried the latest stable version before the current one which is 3.8.6.1 and the performance regression doesn't happen, the query

[sqlite] strchrnul compilation error

Related to this issue, http://www.sqlite.org/src/info/0fac2c045f47c7735af4eb68ced81d8b43622a1f, sqlite 3.8.7 fails to compile on Android by default, plus there is a suspicious warning. The compiled code is the amalgamation: jni/sqlite/sqlite3.c: In function 'sqlite3VXPrintf':

Re: [sqlite] Index on expressions

On Wed, Oct 22, 2014 at 3:42 PM, Philippe Riand wrote: > Hello, > If there any plan to get this in? (see: > http://sqlite.org:8080/cgi-bin/mailman/private/sqlite-users/2014-September/055065.html > ) You'll notice that the SQLite3 developers don't often discuss what features they

Re: [sqlite] JSON indexing

On Tue, Oct 21, 2014 at 4:01 PM, Mike Jarmy wrote: > something like that seems like its probably a necessary first step to being > able to build a JSON index on disk. To be fair, there are other ways it could be done. But I would prefer a mechanism that allows for external

[sqlite] Index on expressions

Hello, If there any plan to get this in? (see: http://sqlite.org:8080/cgi-bin/mailman/private/sqlite-users/2014-September/055065.html ) Note that this seems implemented by several databases now, and this is a bit different from virtual columns, which is what the previous discussion ended with.

Re: [sqlite] Full outer joins

Saying I 'would like this type of join' is something I say very lightly. By that I mean it'd be good to see them, but, really, I'm not going to put any pressure on anyone to get it implemented. I'd been using these joins in SQL2K for years before I found out about SQLite and a lot of what I was

Re: [sqlite] Is msvcrt coupling now unavoidable (3.8.7)?

On Wed, Oct 22, 2014 at 4:50 PM, dave wrote: > > > -Original Message- > > From: sqlite-users-boun...@sqlite.org > > [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Max Vlasov > > Sent: Wednesday, October 22, 2014 5:25 AM > > To: General Discussion of SQLite

Re: [sqlite] Is msvcrt coupling now unavoidable (3.8.7)?

Max Vlasov wrote: > my static linking with Delphi for 3.7.8 version now complains about > _beginthreadex_/_endthreadex_. > Quick search shows than everywhere there's a recommendation to use these > functions instead of API CreateThread if one plans to use Visual c run-time > (msvcrt). Well, by

Re: [sqlite] Is msvcrt coupling now unavoidable (3.8.7)?

> -Original Message- > From: sqlite-users-boun...@sqlite.org > [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Max Vlasov > Sent: Wednesday, October 22, 2014 5:25 AM > To: General Discussion of SQLite Database > Subject: [sqlite] Is msvcrt coupling now unavoidable (3.8.7)? ... > my

[sqlite] what is wrong with this query

I have two versions of the same table with minor differences. I open one database (test1) and attach the second (test2) SELECT test2.table1.* FROM test2.table1 LEFT JOIN table1 table11 ON test2.table1.id = table11.id Gives an error condition near "*": syntax error. provide an alias for

[sqlite] Is msvcrt coupling now unavoidable (3.8.7)?

Hi, my static linking with Delphi for 3.7.8 version now complains about _beginthreadex_/_endthreadex_. Quick search shows than everywhere there's a recommendation to use these functions instead of API CreateThread if one plans to use Visual c run-time (msvcrt). All my previous linking with

Re: [sqlite] Full outer joins

Really!! I can accept that it would not be needed as often as other joins but I can imagine that anyone who wrtes software that populates databases and who subsequently changes their software or needs to benchmark against some other datasource would find this useful. Cheers Paul On 22 October

[sqlite] hot jounal and read-only

Hi, https://www.sqlite.org/wal.html says: *It is not possible to open read-only WAL databases . The opening process must have write privileges for "-shm" wal-index shared memory file associated