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, Richar

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: Da

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 To: SQLite mailing list Sent: 7/21/2016 11:4

[sqlite] Error or Crash using OR in MATCH clause

()(const std::basic_string,std::allocator > & csQuery, unsigned int nMaxToFind, std::vector > & vecResp) Line 76    C++ With this query: SELECT T2TFTSrsn FROM T2TitleFTS WHERE  T2TitleFTS MATCH '{T2TFTStitle T2TFTSseries}:a wrinkle in time OR wrinkle in time' ORDER BY