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