sql: truncate fails when an index is referenced by a view

[ajwerner]

Describe the problem

When an index is referenced by a view, we fail to TRUNCATE the table containing the index with an unclassified error.

To Reproduce

CREATE TABLE t (
    k INT, v INT, INDEX idx (v)
);
CREATE VIEW v AS SELECT v FROM t@idx;
TRUNCATE t;

Results in:

demo@127.0.0.1:26257/movr> truncate t;
ERROR: internal error: relation "t" (118): index ID 2 found in depended-on-by references, no such index in this relation
SQLSTATE: XX000
DETAIL: stack trace:
github.com/cockroachdb/cockroach/pkg/sql/catalog/tabledesc/validate.go:561: ValidateSelf()
...

Expected behavior

TRUNCATE works. We need to rewrite the index references in the dependencies.

Jira issue: CRDB-18122