On 11/11/2014 8:37 PM, Richard Hipp wrote:
On Tue, Nov 11, 2014 at 8:22 PM, Igor Tandetnik <i...@tandetnik.org> wrote:
On 11/11/2014 6:15 PM, Ben Newberg wrote:
Looks like a bug to me. The statement works standalone, but not within a
trigger.
There are many limitations and restrictions on the statements inside of
triggers. See the trigger documentation (
https://www.sqlite.org/lang_createtrigger.html) for details. It looks like
I need to add "no CTEs" to the list of restrictions.
This is not a bug - it is an intentional omission.
INSERT INTO ... WITH RECURSIVE ... SELECT does work though. Is this just
a happy accident?
--
Igor Tandetnik
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
