Hi,
I am writing to report a possible bug in the Alter Table command. It
seems to fail on a somewhat complex schema with multiple tables and views,
and views that reference other views. I was not able to come up with a
simple one table, one view schema where this error actually shows up. That
is why I am not able to post the schema here for you to view directly. So,
please refer to the database test.db located on Google Drive at the
following address:
https://drive.google.com/open?id=0B5B_T2PA2u7ddTdlc1JST0xyVjg
In this database, I have a table Trip, that has a column
"StartGMTOffset". I have multiple views referencing this column, but no
indexes or triggers on this column. I am running SQLite version 3.25.3. I
now issue the following command at the SQLite command prompt and I get the
response below:
SQLite> Alter Table Trip rename column StartGMTOffset to StartUTCOffset;
Error: error in view CumulativeStatisticsByPlaceName after rename: no such
column: StartGMTOffset
Well, duh! There is no such column because I just renamed it. And I
expected the Alter Table command to find and replace all occurrences of
that column name in my schema with the new name. But maybe, it only works
for a table and views that reference it directly, but not views that
reference views that reference the table? I am not sure. But I thought I
would report it anyway.
I apologize if I misunderstood the documentation regarding the alter
table command, or mangled the syntax in some way. Thank you.
Balaji Ramanathan
_______________________________________________
sqlite-users mailing list
[email protected]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
