Hi, On Fri, Dec 27, 2019 at 12:57 PM Bigthing Do <dobigthing...@gmail.com> wrote: > > Dear sqlite developers: > > 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? Thank you. > > > We are using release version of sqlite: `SQLite version 3.30.1 2019-10-10 > 20:19:45` > > Thanks > > Ming Jia > _______________________________________________ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
