Re: [sqlite] Infinite loop when updating indexed with case and where clause

Please unsubscribe me. Christian Hoehne Il 16 gen 2018 13:34, "Harald Klimach" ha scritto: > Hi there, > > here is a weird behavior I observe with the following kind of setup: > > BEGIN TRANSACTION; > CREATE TABLE simple("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "lft" > INTEGER, "rgt" IN

[sqlite] Misleading example of INSTEAD OF trigger

The CREATE TRIGGER example shown in the INSTEAD OF page ( http://www.sqlite.org/lang_createtrigger.html#instead_of_trigger) is misleading because it does not show the correct use of the INSTEAD OF clause in the trigger statement, it actually misses this clause altogether: Examples Assuming that c