[sqlite] Obtaining rowid of an updated row in UPSERT

2020-01-16 Thread Daniel Janus
Dear SQLiters, If an INSERT ... ON CONFLICT DO UPDATE statement detects that a row already exists and needs to be updated, it doesn't seem to set lastRowid to the rowid of that row. Observe (sqlite 3.30.1): > create table users (id integer primary key, firstname text, lastname text,

Re: [sqlite] sqlite3_limit equivalent in System.Data.SQLite.dll

2020-01-16 Thread Simon Slavin
On 16 Jan 2020, at 4:19pm, Simon Slavin wrote: > The actual limit is 125. You can set SQLITE_MAX_ATTACHED to more than 125. 'can' should be 'can't'. Sorry. ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org

Re: [sqlite] sqlite3_limit equivalent in System.Data.SQLite.dll

2020-01-16 Thread Keith Bertram
Ok. I was hoping I could set the value to a value higher than 10 without compiling. I'm curious why the limit is set by default to 10. Keith -Original Message- From: sqlite-users On Behalf Of Keith Medcalf Sent: Wednesday, January 15, 2020 2:54 PM To: SQLite mailing list Subject: Re:

Re: [sqlite] sqlite3_limit equivalent in System.Data.SQLite.dll

2020-01-16 Thread Simon Slavin
On 16 Jan 2020, at 3:21pm, Keith Bertram wrote: > Ok. I was hoping I could set the value to a value higher than 10 without > compiling. I'm curious why the limit is set by default to 10. The actual limit is 125. You can set SQLITE_MAX_ATTACHED to more than 125. It's worth explaining why you

Re: [sqlite] sqlite3_limit equivalent in System.Data.SQLite.dll

2020-01-16 Thread Joe Mistachkin
I’ll raise the default limit for the next release of System.Data.SQLite. Sent from my iPhone > On Jan 16, 2020, at 2:01 PM, Keith Bertram wrote: > > Yes I recognize that this would be a problem. I plan on having no more than > 20-25 attachments. > > If I understand correctly, the only way

[sqlite] Request: Allow virtual tables to make use of partial indexes

2020-01-16 Thread Jens Alfke
I believe I've found another limitation for efficient querying of virtual tables. The xBestIndex call communicates column constraints, but it doesn't specify whether a constraint's value is known at compile time, nor pass such a compile-time value to xBestIndex. This means that the

Re: [sqlite] sqlite3_limit equivalent in System.Data.SQLite.dll

2020-01-16 Thread Keith Bertram
Yes I recognize that this would be a problem. I plan on having no more than 20-25 attachments. If I understand correctly, the only way to set the value above 10, is to recompile the source and set the SQLITE_MAX_ATTACHED variable to a number higher than my 20-25 and also below 125. I was

Re: [sqlite] Next Release? Visual release timeline?

2020-01-16 Thread Dominique Devienne
On Wed, Jan 15, 2020 at 4:54 PM R Smith wrote: > On 2020/01/15 1:24 PM, Richard Hipp wrote: > >> (2) Assume the data is a JSON array of pairs. The first element of > >> each pair is the release name (ex: "3.30.0") and the second element is > >> the time as a fractional year (ex: "2019.7775").