t anticipated traffic volume.
>-Original Message-
>From: sqlite-users [mailto:sqlite-users-
>boun...@mailinglists.sqlite.org] On Behalf Of Simon Slavin
>Sent: Thursday, 21 December, 2017 10:50
>To: SQLite mailing list
>Subject: [sqlite] INSERT OR IGNORE ignores constraints.
On 21 Dec 2017, at 5:58pm, Igor Tandetnik wrote:
> Isn't that precisely what happened in your example? Inserting 6 failed
> silently. What again seems to be the problem?
I’m sorry. You and Scott are quite right. I have no idea what I was thinking.
Simon.
___
On Dec 21, 2017 10:50 AM, "Simon Slavin" wrote:
On 21 Dec 2017, at 3:46pm, David Raymond wrote:
> The only potential problem with "insert or ignore into" is that it will
ignore any constraint violation for that record insert
Wait. What ?
SQLite version 3.19.3 2017-06-27 16:48:08
Enter ".he
On 12/21/2017 12:50 PM, Simon Slavin wrote:
SQLite version 3.19.3 2017-06-27 16:48:08
Enter ".help" for usage hints.
Connected to a transient in-memory database.
Use ".open FILENAME" to reopen on a persistent database.
sqlite> CREATE TABLE MyTable (a INTEGER, CONSTRAINT noless CHECK (a > 10));
sq
On 21 Dec 2017, at 3:46pm, David Raymond wrote:
> The only potential problem with "insert or ignore into" is that it will
> ignore any constraint violation for that record insert
Wait. What ?
SQLite version 3.19.3 2017-06-27 16:48:08
Enter ".help" for usage hints.
Connected to a transient i
5 matches
Mail list logo