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

CDC inbound endpoint decimal value not logging correctly #4064

Open
KalinduGandara opened this issue Mar 4, 2025 · 0 comments
Open

CDC inbound endpoint decimal value not logging correctly #4064

KalinduGandara opened this issue Mar 4, 2025 · 0 comments
Labels

Comments

@KalinduGandara
Copy link

KalinduGandara commented Mar 4, 2025

Description

When logging cdc insert logs decimal values not logging properly.

i have used mysql cdc example and run this sql command

INSERT INTO products (product_name, category, quantity, price) VALUES
('Laptop', 'Electronics', 50, 999.99);

the log printed was

[2025-03-04 10:56:39,339]  INFO {BaseSourceTask} - 1 records sent during previous 00:01:24.924, last recorded offset of {server=CDCIEP_topic} partition is {ts_sec=1741065999, file=binlog.000005, pos=1459, gtids=00764944-f8b7-11ef-916c-0242ac110002:1-4, row=1, server_id=1, event=2}
[2025-03-04 10:56:39,443]  INFO {LogMediator} - {inboundendpoint:CDCIEP} To: , MessageID: urn:uuid:6D26370A486FB56D5B1741065999393, Direction: request, Payload: {"op":"CREATE","before":null,"after":{"product_id":1,"product_name":"Laptop","category":"Electronics","quantity":50,"price":"AYaf","created_at":"2025-03-04T05:26:39Z"}}

Steps to Reproduce

Follow CDC mysql example and run an insert query. see price in not logged properly.

create this table

CREATE TABLE products (
    product_id INT AUTO_INCREMENT PRIMARY KEY,
    product_name VARCHAR(100) NOT NULL,
    category VARCHAR(50),
    quantity INT DEFAULT 0,
    price DECIMAL(10, 2),
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

Version

MI-4.x.x, debezium-2.7.4

Environment Details (with versions)

No response

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

No branches or pull requests

1 participant