SQLite Forum

insert into view returning id returns null
Login
Working as expected, I think.

I wonder what would happen if <code>bar</code> was a TABLE instead of a VIEW, but still had the same TRIGGER, which still didn't have a RETURNING clause.

Or suppose, inside of your TRIGGER, there were two INSERT commands.  What would you expect to happen ?