I haven’t tested many versions. But the most up-to-date master branch and the release version has this bug.
> On Dec 8, 2019, at 4:55 PM, Simon Slavin <slav...@bigfraud.org> wrote: > > On 8 Dec 2019, at 7:51pm, Yongheng Chen <changoch...@gmail.com> wrote: > >> The bug exists in "SQLite version 3.31.0 2019-12-08 00:06:39” and before. > > SQLite version 3.28.0 2019-04-15 14:49:49 > Enter ".help" for usage hints. > Connected to a transient in-memory database. > Use ".open FILENAME" to reopen on a persistent database. > sqlite> CREATE TABLE v0 ( v1 ) ; > sqlite> CREATE TABLE v2 ( v3 ) ; > sqlite> CREATE VIEW v4 AS WITH x AS ( SELECT x () OVER( ) FROM v4 ) SELECT v3 > AS x FROM v2 ; > sqlite> DROP TRIGGER IF EXISTS x ; > sqlite> ALTER TABLE v2 RENAME TO t3; > sqlite> > > Not a problem for this version. > _______________________________________________ > 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