Flink CDC Issue Import created FLINK-34799:
----------------------------------------------
Summary: SQL server cannot read the correct table[Bug]
Key: FLINK-34799
URL: https://issues.apache.org/jira/browse/FLINK-34799
Project: Flink
Issue Type: Bug
Components: Flink CDC
Reporter: Flink CDC Issue Import
### Search before asking
- [X] I searched in the
[issues|https://github.com/ververica/flink-cdc-connectors/issues) and found
nothing similar.
### Flink version
1.16.0
### Flink CDC version
2.4
### Database and its version
Microsoft SQL Server 2017 (RTM) - 14.0.1000.169 (X64) Aug 22 2017 17:04:49
Copyright (C) 2017 Microsoft Corporation Developer Edition (64-bit) on Windows
10 Enterprise 10.0 <X64> (Build 19044: ) (Hypervisor)
### Minimal reproduce step
CREATE TABLE products (
id INT,
name STRING,
description STRING,
PRIMARY KEY (id) NOT ENFORCED
) WITH (
'connector' = 'sqlserver-cdc',
'hostname' = '***',
'port' = '1433',
'username' = 'sa',
'password' = '***',
'database-name' = 'inventory',
'table-name' = 'dbo.products'
];
![image|https://github.com/ververica/flink-cdc-connectors/assets/8586973/610edf4d-de11-4892-9b79-acd57178194e]
![image|https://github.com/ververica/flink-cdc-connectors/assets/8586973/1276cddb-3dbe-4148-90c9-6d3b4c0d5a2d]
![image|https://github.com/ververica/flink-cdc-connectors/assets/8586973/4042bbfb-73ac-433b-b107-00e5ca7eca1e]
### What did you expect to see?
OK
### What did you see instead?
If a database instance has multiple databases and multiple databases have the
same table, an error reading table will occur
### Anything else?
_No response_
### Are you willing to submit a PR?
- [ ] I'm willing to submit a PR!
---------------- Imported from GitHub ----------------
Url: https://github.com/apache/flink-cdc/issues/2289
Created by: [ysq5202121|https://github.com/ysq5202121]
Labels: bug,
Created at: Tue Jul 11 12:47:07 CST 2023
State: open
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
