On Friday, 27 December, 2019 12:50, Igor Korot <ikoro...@gmail.com> wrote:
>On Fri, Dec 27, 2019 at 12:57 PM Bigthing Do <dobigthing...@gmail.com> wrote: >> We met an accidental crash in sqlite with the following sample: >> CREATE VIEW table1 ( col1 , col2 ) AS WITH aaa AS ( SELECT * FROM table1 ) >> SELECT col2 FROM table1 ORDER BY 1 ; >> WITH aaa AS ( SELECT * FROM table1 ) SELECT col1 , rank () OVER( ORDER BY >> col1 DESC ) FROM table1 ; >Could you please provide the schema for table1? table1 is a circular view ... that is table1 is a view that tries to select from table1 which is a view which selects from table1 which is a view which selects from table1 ... until eventually all memory and stack is consumed and sqlite crashes. -- The fact that there's a Highway to Hell but only a Stairway to Heaven says a lot about anticipated traffic volume. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
