sql: TRUNCATE after CREATE VIEW using FORCE_INDEX results in schema assertion

[knz]

Describe the problem

(Discovered by @DerZc using random testing with sqllancer.)

The validate call during a TRUNCATE after a CREATE VIEW results in the following assertion error:

ERROR: internal error: relation "t1" (107): 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:686: ValidateSelf()
github.com/cockroachdb/cockroach/pkg/sql/catalog/internal/validate/validate.go:80: func1()
github.com/cockroachdb/cockroach/pkg/sql/catalog/internal/validate/validate.go:198: validateDescriptorsAtLevel()
github.com/cockroachdb/cockroach/pkg/sql/catalog/internal/validate/validate.go:76: Validate()
github.com/cockroachdb/cockroach/pkg/sql/catalog/internal/validate/validate.go:41: Self()
github.com/cockroachdb/cockroach/pkg/sql/catalog/tabledesc/structured.go:539: AllocateIDs()
github.com/cockroachdb/cockroach/pkg/sql/truncate.go:222: truncateTable()
github.com/cockroachdb/cockroach/pkg/sql/truncate.go:126: startExec()

To Reproduce

Run the following on a freshly created cluster:

CREATE DATABASE IF NOT EXISTS test;
USE test;
CREATE TABLE t0 (c0 INT PRIMARY KEY);
CREATE TABLE t1 (c0 INT UNIQUE  PRIMARY KEY);
CREATE INDEX ON t1(c0);
CREATE VIEW v0(c0) AS SELECT NULL FROM t0 CROSS JOIN t1 @{FORCE_INDEX=t1_c0_idx,DESC};
TRUNCATE t1 RESTRICT;

Expected behavior

No error

Jira issue: CRDB-26815

[blathers-crl]

Hi @knz, please add branch-* labels to identify which branch(es) this release-blocker affects.

_{🦉 Hoot! I am a Blathers, a bot for CockroachDB. My owner is dev-inf.}

[DerZc]

@knz thanks for your report, but this is a duplicate bug which I have reported #100681

[knz]

dup #85230