cockroachdb / cockroachdb/cockroach
changefeedccl: changefeed targets are not changed when target is renamed
- 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
Assessment
This issue has not been assessed yet.