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. A lot of extra code would need to be added to support this and that is not something we want to do right now. -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users