debezium / debezium/dbz

SQLServer connector using incorrect columns for sorting changes [DBZ-8639]

Open
#1,327 2 comments 1 reaction 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-8639](https://issues.redhat.com/browse/DBZ-8639)

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

SQL Server version 2.7.3
h2. What behavior do you expect?

The [SQL Server docs|https://learn.microsoft.com/en-us/sql/relational-databases/system-tables/cdc-capture-instance-ct-transact-sql?view=sql-server-ver16] recommend that changes from the change table should be {{{}ORDER BY [__$start_lsn] ASC, [__$command_id] ASC, [__$operation] ASC{}}}.
h2. What behavior do you see?

The connector is ordering changes from the change table by {{ORDER BY [__$start_lsn] ASC, [__$seqval] ASC, [__$operation] ASC}}

 

This was originally raised as a [question on Zulip|https://debezium.zulipchat.com/#narrow/stream/348252-community-sqlserver/topic/Ordering.20of.20changes.20from.20SQL.20Server].

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.