cockroachdb / cockroachdb/cockroach

changefeedccl: changefeed targets are not changed when target is renamed

Open
#117,518 2 comments 0 reactions 0 assignees View on GitHub
A-cdc C-bug T-cdc
Dominant language
Go
Stars
32.5k
Forks
4.1k
PR merge metrics
PR metrics pending

Description

We change the table name of users to user1 and the description in the job record stays the same.
```
demo@127.0.0.1:26257/movr> create changefeed for users into 'null://';
job_id
----------------------
932832786050809857
(1 row)

Time: 28ms total (execution 27ms / network 1ms)

demo@127.0.0.1:26257/movr> show changefeed jobs;
job_id | description | user_name | status | running_status | created | started | finished | modified | high_water_timestamp | error | sink_uri | full_table_names | topics | format
---------------------+------------------------------------------------------+-----------+---------+------------------------------------------+----------------------------+----------------------------+----------------------------+----------------------------+--------------------------------+-----------------------------+----------+---------------------------+--------+---------
932832786050809857 | CREATE CHANGEFEED FOR TABLE users INTO 'null:' | demo | running | running: resolved=1704748374.243765000,0 | 2024-01-08 21:12:54.258708 | 2024-01-08 21:12:54.28223 | NULL | 2024-01-08 21:12:54.296086 | 1704748374243765000.0000000000 | | null:// | {movr.public.users} | NULL | json
(1 rows)

Time: 23ms total (execution 23ms / network 0ms)

demo@127.0.0.1:26257/movr> alter table users rename to users1;
ALTER TABLE

Time: 50ms total (execution 50ms / network 0ms)

show changefeed jobs;
job_id | description | user_name | status | running_status | created | started | finished | modified | high_water_timestamp | error | sink_uri | full_table_names | topics | format
---------------------+------------------------------------------------------+-----------+---------+------------------------------------------+----------------------------+----------------------------+----------------------------+----------------------------+--------------------------------+-----------------------------+----------+---------------------------+--------+---------
932832786050809857 | CREATE CHANGEFEED FOR TABLE users INTO 'null:' | demo | running | running: resolved=1704748374.243765000,0 | 2024-01-08 21:12:54.258708 | 2024-01-08 21:12:54.28223 | NULL | 2024-01-08 21:13:24.446214 | 1704748401278315000.0000000000 | | null:// | {movr.public.users1} | NULL | json
(1 row)

Time: 33ms total (execution 33ms / network 1ms)
```

Jira issue: CRDB-35224

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.