Does TICDC not support synchronizing functions and views?

Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.

Original topic: TICDC不支持同步函数以及视图吗?

| username: TiDBer_5VobY5Th

I created a CDC task and created a view on the source side, but found that the view was not created on the target side. Does TiCDC not support views, functions, etc.?

| username: zhaokede | Original post link

Custom functions are not supported.

| username: 友利奈绪 | Original post link

Custom functions are not supported.

| username: TiDBer_5VobY5Th | Original post link

What about views? Are they not supported either?

| username: 友利奈绪 | Original post link

You can use views.

| username: TiDBer_5VobY5Th | Original post link

However, the new view created on the source end has not been synchronized to the target end.

| username: Daniel-W | Original post link

System Table Unable to Sync
Users and Permissions Unable to Sync
Binding Unable to Sync
Sequence Unable to Sync
View Can Sync
Global Temporary Table Can Sync
| username: Daniel-W | Original post link

I previously tested that views can be synchronized.

| username: WinterLiu | Original post link

I just checked the CDC documentation, and the downstream requires * Create View permission. Could it be caused by a lack of permission?

| username: 小龙虾爱大龙虾 | Original post link

Ticdc supports view synchronization, but functions are not supported (because TiDB itself does not support custom functions).

| username: Jack-li | Original post link

Unable to support TiDB custom functions.

| username: TiDBer_5VobY5Th | Original post link

I’m using 8.0 and the views are not synchronized either.

| username: TiDBer_5VobY5Th | Original post link

All are root accounts, and all have permissions.

| username: 小龙虾爱大龙虾 | Original post link

Send the cdc changefeed configuration file.

| username: TiDBer_5VobY5Th | Original post link

It’s because only a few tables in the database were selected; it must be done using the db.* method.

| username: Kongdom | Original post link

Does it mean that after changing to db.*, synchronization is already possible?

| username: TiDBer_QYr0vohO | Original post link

Custom functions are not supported.

| username: kkpeter | Original post link

TiDB does not support custom functions.

| username: TiDBer_5VobY5Th | Original post link

Yes, changing it to db.* can synchronize.

| username: Kongdom | Original post link

:handshake: :handshake: :handshake: