SQLite Forum

"ALTER TABLE ..." looks at other tables
Login
My db has a table that I don't use very often that has a custom collation (in Tcl), which I load only when I am going to be using that table. This has not caused any problems until now.

I have been doing some things with the native ALTER TABLE command and it seems that ADD COLUMN is not a problem, but both RENAME TO and RENAME COLUMN fail with errors because of the missing collation in another table.

Is this expected?

I tried creating a tiny example, but the problem did not arise.

The file the situation occurs in passes the INTEGRITY_CHECK, and I use it all the time, but there could be some problem that the check does not see.

My file is 137,312 KB, and I can send it or a link to it if you (drh) care to look into it.

Gerry Snyder