Re: [sqlite] "INSERT INTO table AS alias" is invalid inside triggers

On Mon Feb 10, 2020 at 01:34:12AM +0100, no...@null.net wrote: > I suspect I have found a parsing error in SQLite 3.30.1. Given the > ... > However if I wrap it inside a trigger: > > CREATE TABLE t2(b INTEGER); > > CREATE TRIGGER t2_ai > AFTER INSERT ON t2 > FOR EACH ROW BEGIN >

[sqlite] "INSERT INTO table AS alias" is invalid inside triggers

I suspect I have found a parsing error in SQLite 3.30.1. Given the following: CREATE TABLE t1(a INTEGER PRIMARY KEY); The following statement is accepted by the parser: INSERT INTO t1 AS original (a) VALUES(1) ON CONFLICT DO NOTHING; However if I wrap it inside a trigger: CRE