Re: [sqlite] BUG: FTS5 query containing OR + order by rank

2016-05-28 Thread Simon Slavin
On 28 May 2016, at 10:22pm, Jan Berkel wrote: > I'm getting "database disk image is malformed" errors when running a > query containing OR and ordering by > rank against a FTS5 index: What happens when you run PRAGMA integrity_check on it ? Simon.

[sqlite] BUG: FTS5 query containing OR + order by rank

2016-05-28 Thread Jan Berkel
I'm getting "database disk image is malformed" errors when running a query containing OR and ordering by rank against a FTS5 index:   $ sqlite3 SQLite version 3.13.0 2016-05-18 10:57:30 sqlite> create virtual table foo using fts5(bar); sqlite> insert into foo values('test'); sqlite> select rowid

Re: [sqlite] Messages posted on Nabble not getting to list

2016-05-28 Thread r . a . nagy
Gmail track threads - I prefer over just about all html stuff ... Sent from my iPhone > On May 28, 2016, at 3:34 PM, Lauri Nurmi wrote: > > 27.5.2016, 2:48, Balaji Ramanathan kirjoitti: >> Why does SQLite use a mailing list instead of a proper web-hosted >> forum/bulletin board

Re: [sqlite] Messages posted on Nabble not getting to list

2016-05-28 Thread r . a . nagy
@Daren Any reasons for the thumbs down on MySQL? Their workbench is better that Toad ... Sent from my iPhone > On May 27, 2016, at 10:00 PM, Darren Duncan wrote: > >> On 2016-05-27 2:28 PM, Balaji Ramanathan wrote: >> But when I was debating between MySQL and >>

Re: [sqlite] Messages posted on Nabble not getting to list

2016-05-28 Thread Lauri Nurmi
27.5.2016, 2:48, Balaji Ramanathan kirjoitti: Why does SQLite use a mailing list instead of a proper web-hosted forum/bulletin board type setup? Is there any forum platform whose usability is not totally terrible compared to mailing lists? First of all, to keep track of who has replied to

Re: [sqlite] Messages posted on Nabble not getting to list

2016-05-28 Thread R.A. Nagy
FWIW, we are VERY socialized - from Linkedin & Twitter, to YouTube & Facebook (we've about 5 groups there,) over to Sourceforge.NET, Stack Overflow (and of course ... here!), it all eventually gets forwarded to this email account somehow ... even if I have to write a scraper to do it. There is

Re: [sqlite] bug report (security)

2016-05-28 Thread Richard Hipp
On 5/27/16, Jonathan Brossard wrote: > > I'd like to report a heap overflow, please find an advisory attached to > this email. > Thanks of the bug report. I am unable to reproduce the heap overflow. Nevertheless, it looks like this problem may have been addressed by

Re: [sqlite] bug report (2/2) [security]

2016-05-28 Thread Richard Hipp
On 5/27/16, Jonathan Brossard wrote: > > Please find attached a second bug report for a use after free() in sqlite. > Thank you for the bug report. This problem (in the command-line shell, not in SQLite itself) has already been fixed, specifically by check-in

[sqlite] bug report (2/2) [security]

2016-05-28 Thread Jonathan Brossard
Dear Sqlite team, Please find attached a second bug report for a use after free() in sqlite. Kindest regards, j- --- * * * Sqlite3 use

[sqlite] bug report (security)

2016-05-28 Thread Jonathan Brossard
Dear Sqlite team, I hope this email finds you well. I'd like to report a heap overflow, please find an advisory attached to this email. Best regards, j- --- *

Re: [sqlite] SELECT the "middle" of a large ordered table

2016-05-28 Thread Dominique Devienne
On Fri, May 27, 2016 at 10:02 PM, Clay Gerrard wrote: > [...] These container databases are normally small (<1-4M rows) - and you > can have many of them (>10M) - but depending on the usage pattern - they can > also grow big (100+ GB) when there are many many object rows