cockroachdb / cockroachdb/cockroach

changefeedccl: show changefeed jobs delegate query has hard to parse CTEs

Open
#157,764 1 comment 0 reactions 0 assignees View on GitHub
A-cdc C-enhancement T-cdc
Dominant language
Go
Stars
32.5k
Forks
4.1k
PR merge metrics
PR metrics pending

Description

**Is your feature request related to a problem? Please describe.**
With DB-level changefeeds, and especially withtheir need to apply table filters, the delegate query for SHOW CHANGEFEED JOBS has many CTEs and has become hard to reason about.

**Describe the solution you'd like**
SHOW CHANGEFEED JOBS should be implemented as an opaque statement.

**Describe alternatives you've considered**
I implemented the query as a delegate [https://github.com/cockroachdb/cockroach/pull/156873](url), but it's difficult for reviewers to follow. I've attempted a few different ways, but the intermediate CTEs remain difficult to parse.

May relate to https://github.com/cockroachdb/cockroach/issues/146640

Jira issue: CRDB-56942

Epic CRDB-55919

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.