Re: [sqlite] Using a "custom" version of SQLite under Python in Ubuntu.

On 10/26/16, Smith, Randall wrote: > This question may be off-topic for this list, since it deals with using > SQLite in a specific setting rather than SQLite itself. Apologies if so. > Thanks very much if anyone can provide any insight. > > I am one of the hapless souls

Re: [sqlite] Using a "custom" version of SQLite under Python in Ubuntu.

On Wednesday, 26 October, 2016 19:05, Smith, Randall wrote: > This question may be off-topic for this list, since it deals with using > SQLite in a specific setting rather than SQLite itself. Apologies if so. > Thanks very much if anyone can provide any insight. > I

[sqlite] Using a "custom" version of SQLite under Python in Ubuntu.

This question may be off-topic for this list, since it deals with using SQLite in a specific setting rather than SQLite itself. Apologies if so. Thanks very much if anyone can provide any insight. I am one of the hapless souls who need access to SQLite's CTE capabilities (introduced in

Re: [sqlite] Bug report: Incorrect output of a LEFT JOIN with row-values in expression

On 10/26/16, Ján Hric wrote: > Hello > I would like to report a bug in the latest version of SQLite (3.15.0). Thanks for a very clear and succinct bug report. Well done! The ticket is here: https://www.sqlite.org/src/tktview/fef4bb4bd9185ec8f18d9912abb444da61d02ff2 > >

[sqlite] Bug report: Incorrect output of a LEFT JOIN with row-values in expression

Hello I would like to report a bug in the latest version of SQLite (3.15.0). Description: If comparison of row-values is used in the expression of a LEFT JOIN clause and no mach is found, instead of one row with values from the left-hand table, no rows are returned. Example code: CREATE TABLE

Re: [sqlite] Bug in latest sqlite Release vacuum crashes?

On 10/25/2016 01:25 AM, Christian Czech wrote: We have a problem with the latest stable release of SQLite. When compiled for 32 bit under windows and vacuum a database file larger than 2GB, memory storage usage gets up to 2GB and than vacuum crashes with not enough memory. It seems that a temp

Re: [sqlite] How to get these ordered correctly

On 10/26/2016 10:53 AM, Jeff Archer wrote: Hi and thanks in advance for your help. I have a table of words and counts and I am trying to make a query which sorts in descending order of count but with each group of words that have the same count sorted alphabetically. MY table: CREATE TABLE

Re: [sqlite] How to get these ordered correctly

On 2016/10/26 4:53 PM, Jeff Archer wrote: Hi and thanks in advance for your help. I have a table of words and counts and I am trying to make a query which sorts in descending order of count but with each group of words that have the same count sorted alphabetically. MY table: CREATE TABLE

[sqlite] How to get these ordered correctly

Hi and thanks in advance for your help. I have a table of words and counts and I am trying to make a query which sorts in descending order of count but with each group of words that have the same count sorted alphabetically. MY table: CREATE TABLE words (id INTEGER PRIMARY KEY AUTOINCREMENT ,cnt

Re: [sqlite] no such column error

On 2016/10/25 5:44 PM, Bart Smissaert wrote: Try this: UPDATE mytable SET myfield1 = (SELECT 1 from mytable ORDER BY EXISTS (SELECT 1 WHERE mytable.myfield2 = 1 ) ) RBS

Re: [sqlite] Bug in latest sqlite Release vacuum crashes?

I've gotten this with this version and with some previous ones (Windows 7). Closest I was ever able to guess as to what was going on was that Windows was memory mapping the file even though I had the CLI compiled with SQLITE_DEFAULT_MMAP_SIZE=0, and SQLITE_MAX_MMAP_SIZE=0. (First should be