cockroachdb / cockroachdb/cockroach
bundle: include dependencies from DEFAULT column expressions
Open
A-sql-debug-bundle
C-cleanup
E-quick-win
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 FUNCTION f(id INT) RETURNS INT LANGUAGE SQL AS $$ SELECT id; $$;
CREATE SEQUENCE s;
CREATE TABLE t (k INT PRIMARY KEY, id INT NOT NULL DEFAULT f(nextval('s'::REGCLASS)));
```
Neither UDF `f` nor sequence `s` are included into the stmt bundle which will prevent easy recreation. We do include some dependent UDFs and sequences, so perhaps we're missing tracking of the DEFAULT column expression (maybe more).
Jira issue: CRDB-39474
Contributor guide
Assessment
This issue has not been assessed yet.