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 t
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 hopin
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 virtual-tabl
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
http://mailinglists.sqlite.
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 w
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:
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,
phonenumb
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").
No
8 matches
Mail list logo