Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

关于日志示例问题的疑惑 #17463

Open
fangchieh opened this issue May 28, 2024 · 4 comments
Open

关于日志示例问题的疑惑 #17463

fangchieh opened this issue May 28, 2024 · 4 comments
Assignees

Comments

@fangchieh
Copy link

File: /release-8.1/ticdc/ticdc-open-protocol.md

  1. [partition=0] [key="{"ts":415508881418485761,"scm":"test","tbl":"t1","t":1}"] [value="{"u":{"id":{"t":3,"h":true,"v":3},"val":{"t":15,"v":"ZGQ="}}}"]

Log11 是 UPDATE test.t1 SET val = 'dd' WHERE id = 3; 语句产生的日志,它是更新的; 为什么 value 的对象中没有出现 "p":{"id":{"t":3,"h":true,"v":3},"val":{"t":15,"v":"Y2M="}}

参考:https://docs.pingcap.com/zh/tidb/stable/ticdc-open-protocol#row-changed-event
Update 事件,输出新增的行数据 ("u") 以及修改前的行数据 ("p")。

@qiancai
Copy link
Collaborator

qiancai commented May 31, 2024

@3AceShowHand PTAL, thanks

@3AceShowHand
Copy link
Contributor

请提供表结构 DDL 语句。

@fangchieh
Copy link
Author

@3AceShowHand 您好,可能我的问题没有描述到位,导致您理解的可能有误。
event-流的输出示例
这个示例里的 Log11 输出的结果我认为可能有误:
Log11 是 UPDATE test.t1 SET val = 'dd' WHERE id = 3; 语句产生的日志,它是update事件;
为什么 value 的对象中没有出现 "p":{"id":{"t":3,"h":true,"v":3},"val":{"t":15,"v":"Y2M="}}

@fangchieh
Copy link
Author

请提供表结构 DDL 语句。

CREATE TABLE test.t1(id int primary key, val varchar(16));

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

3 participants