cockroachdb / cockroachdb/cockroach
stmtbundle: dependencies between views aren't respected
Open
A-sql-debug-bundle
branch-master
C-bug
O-support
P-3
T-sql-queries
- Dominant language
- Go
- Stars
- 32.5k
- Forks
- 4.1k
- PR merge metrics
- PR metrics pending
Description
Consider the following setup:
```sql
CREATE TABLE t (k INT PRIMARY KEY);
CREATE VIEW v1(k1) AS SELECT k FROM t;
CREATE VIEW v2(k2) AS SELECT k1 FROM v1;
EXPLAIN ANALYZE (DEBUG) SELECT * FROM v2;
```
This bundle cannot be automatically recreated because we include `v2` before `v1` into `schema.sql`.
Jira issue: CRDB-55447
Contributor guide
Assessment
This issue has not been assessed yet.