Re: [sqlite] Cascaded delete unexpectedly triggered by upsert

This does look very useful - I’ve often thought of the INSERT/EPLACE style but the implicit DELETE [when REPLACE occurs] was a barrier - it causes [as I understand it] CASCADE DELETE to be in effect. It seems that this UPSERT style does not cause that effect. > On Jan 8, 2020, at 5:22 AM,

Re: [sqlite] Error or Crash using OR in MATCH clause

Dan Thank you, and another member - Simon Slavin, for replying so quickly. It does look exactly like my problem: we'll await 3.14 with interest. Julian Dohmen | developer Evelyn Manufacturing | Alexandria & KeepnTrack 801.943.7277 ext 565 | jdoh...@companioncorp.com From: Dan Ken

Re: [sqlite] Error or Crash using OR in MATCH clause

In SQLite.exe [the source of the simple example I sent] PRAGMA integrity_check; Ok Julian Dohmen | developer Evelyn Manufacturing | Alexandria & KeepnTrack 801.943.7277 ext 565 | jdoh...@companioncorp.com From: Simon Slavin <slav...@bigfraud.org> To: SQLite mailing li

[sqlite] Error or Crash using OR in MATCH clause

DER BY rank LIMIT 50; ========= Julian Dohmen | developer Evelyn Manufacturing | Alexandria & KeepnTrack 801.943.7277 ext 565 | jdoh...@companioncorp.com ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailing