Re: [sqlite] Triggers for generated columns?

2019-12-02 Thread Stephen F. Booth
Hi Keith, Thanks for the reply. On Mon, Dec 2, 2019 at 6:31 PM Keith Medcalf wrote: > Well, of course the trigger did not fire. You created an AFTER UPDATE > trigger, but only did an insert. So of course one would not expect the > trigger to fire. You're right- this was a copy/paste error

Re: [sqlite] Triggers for generated columns?

2019-12-02 Thread Keith Medcalf
On Monday, 2 December, 2019 17:10, Stephen F. Booth wrote: >I have been trying out generated column support in the 3.31.0 prerelease. >Thank you for adding such a useful feature! >When I create a trigger for an update of a generated column the trigger >is successfully created but it never

[sqlite] Triggers for generated columns?

2019-12-02 Thread Stephen F. Booth
I have been trying out generated column support in the 3.31.0 prerelease. Thank you for adding such a useful feature! When I create a trigger for an update of a generated column the trigger is successfully created but it never fires. I could not find any mention in the draft documentation of