On Tue, Nov 11, 2014 at 9:01 PM, Igor Tandetnik <[email protected]> wrote:
> On 11/11/2014 8:37 PM, Richard Hipp wrote: > >> On Tue, Nov 11, 2014 at 8:22 PM, Igor Tandetnik <[email protected]> >> 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? > Yes. -- D. Richard Hipp [email protected] _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
