cockroachdb / cockroachdb/cockroach

bundle: include dependencies from DEFAULT column expressions

Open
#125,462 0 comments 0 reactions 0 assignees View on GitHub
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

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.