On Mon, Nov 26, 2018 at 2:52 AM Balaji Ramanathan < balaji.ramanat...@gmail.com> wrote:
> SQLite> Alter Table Trip rename column StartGMTOffset to StartUTCOffset; > Error: error in view CumulativeStatisticsByPlaceName after rename: no such > column: StartGMTOffset > > I was able to reproduce this behaviour: C:\temp>sqlite3 bug.sqlite SQLite version 3.25.3 2018-11-05 20:37:38 Enter ".help" for usage hints. sqlite> create table t1 (c1 int); sqlite> create view v1 as select c1 from t1; sqlite> create view v11 as select null from t1 left join v1 on v1.c1=t1.c1; sqlite> alter table t1 rename column c1 to c2; Error: error in view v11 after rename: no such column: v1.c1 sqlite> _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users