Re: Trigger name missing
Richard Hipp <[email protected]> Wed, 26 Feb 2020 06:18:43 -0500
| Newsgroups | gmane.comp.db.sqlite.general |
|---|---|
| Message-ID | <CALwJ=MzwJ=Ze6U5k=zL2et38gZf0pUaXohgwLoCUEL1Wp6O3cg@mail.gmail.com> |
On 2/26/20, Jean-Luc Hainaut <[email protected]> wrote: > Hi all, > > It seems that SQLite (version 31.1) accepts a trigger declaration in > which the name is missing. When fired, this trigger doesn't crashes but > exhibits a strange behaviour. In particular, while expression > "new.<colName>" in an "insert" trigger returns the correct value, the > equivalent expression "select <colName> from T where Id = new.Id" always > returns null (column "Id" is the PK of table "T"). Similarly, "update T > set <columnName> = <expression> where Id = new.Id" (silently) fails. > What is the text of your trigger? -- D. Richard Hipp [email protected] _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users