debezium / debezium/dbz

SQL Server Signal table Id mismatch [DBZ-8753]

Open
#65 0 comments 0 reactions 0 assignees View on GitHub
component/sqlserver-connector migrated-from-jira type/bug
Dominant language
HTML
Stars
6
Forks
8
Avg merge
2d 19h
Merged PRs (30d)
1

Description

Migrated from [DBZ-8753](https://issues.redhat.com/browse/DBZ-8753)

h2. What Debezium connector do you use and what version?

I'm using the SQL Server Connector version 3.0.6
h2. What behavior do you expect?

When the Signal table have a 'uniqueidentifier' Id type the request should match the one from the Kafka topic.
h2. What behavior do you see?

What happens is the window is ignored due to casing with the message: 
{code:java}
Received request to open window with id = '691816A5-9E71-4BCB-9569-9D679E09E47B', expected = '691816a5-9e71-4bcb-9569-9d679e09e47b', request ignored

Received request to close window with id = '691816A5-9E71-4BCB-9569-9D679E09E47B', expected = '691816a5-9e71-4bcb-9569-9d679e09e47b', request ignored{code}
A workaround is to use another column type, but even after changing the column type new incremental requests do not work (this may be due offsets).
h2. Do you see the same behaviour using the latest released Debezium version?

Yes

 

Contributor guide

Open the contributing guide

Research direction

No source files or tests are named. Start by reproducing the SQL Server Connector 3.0.6 case with a uniqueidentifier Signal table and compare the Signal table ID with the Kafka topic request; done means open and close window requests match despite casing, and incremental requests still work after changing the column type.

Written by the indexing model from the issue text.

Assessment

Tech stack
sql
Domain
databases
Issue type
Bug
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
35/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.