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

TableMapEvent 中 ColumnName 获取列名称是空数据。mysql是5.7版本 #806

Open
baozinihao opened this issue Jul 5, 2023 · 6 comments

Comments

@baozinihao
Copy link

=======TableMapEvent======
TableID: 109
TableID size: 6
Flags: 1
Schema: golang
Table: test
Column count: 5
Column type:
00000000 03 0f 0f 03 03 |.....|
NULL bitmap:
00000000 06 |.|
Signedness bitmap:
Default charset: []
Column charset: []
Set str value: []
Enum str value: []
Column name: []
Geometry type: []
Primary key: []
Primary key prefix: []
Enum/set default charset: []
Enum/set column charset: []
UnsignedMap: map[int]bool(nil)
CollationMap: map[int]uint64(nil)
EnumSetCollationMap: map[int]uint64(nil)
EnumStrValueMap: map[int][]string(nil)
SetStrValueMap: map[int][]string(nil)
GeometryTypeMap: map[int]uint64(nil)
Columns:
<n/a> type=3 unsigned=<n/a> null=no
<n/a> type=15 collation=<n/a> null=yes
<n/a> type=15 collation=<n/a> null=yes
<n/a> type=3 unsigned=<n/a> null=no
<n/a> type=3 unsigned=<n/a> null=no

@afocus
Copy link

afocus commented Jul 7, 2023

8.0 too

@dveeden
Copy link
Collaborator

dveeden commented Jul 7, 2023

Do you have exact versions for both 5.7, 8.0 and the go-mysql version? This might make it easier to reproduce.

What does the same entry look like in mysqlbinlog?

@lance6716
Copy link
Collaborator

@dveeden
Copy link
Collaborator

dveeden commented Jul 7, 2023

Ah so to reproduce this one needs to set binlog_row_metadata=full?

@xpfo-go
Copy link

xpfo-go commented Sep 27, 2023

Ah so to reproduce this one needs to set binlog_row_metadata=full?

I had the same problem, set binlog_row_metadata=full solve this problem. many thanks.

@herouu
Copy link

herouu commented May 26, 2024

Ah so to reproduce this one needs to set binlog_row_metadata=full?

thanks,setting this resolve it

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

6 participants