On 08 Dec 2019, at 21:55, 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.
macOS 10.14.6: Third-Mini% sqlite3 -- Loading resources from /Users/tim/.sqliterc SQLite version 3.28.0 2019-04-16 19:49:53 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; zsh: segmentation fault sqlite3 Third-Mini% My .sqliterc has: Third-Mini% more .sqliterc .mode column .width 0 .headers on -- Cheers -- Tim _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users