-
Enhancement
-
Resolution: Done
-
Minor
-
1.5.0.Final
-
None
-
False
-
False
-
Undefined
-
When the filter specified in column.include.list applied to the list of columns of a certain table produces an empty list, the connector still tries to perform a knowingly invalid SQL query that selects no columns.
Steps to reproduce
- Configure the connector with column.include.list=.^ – there's no column name that will match this regular expression.
- Run the connector.
Expected behavior
- The connector doesn't attempt to perform a knowingly invalid query.
- There is a log message that helps identify the invalid configuration.
Actual behavior
Producer failure [io.debezium.pipeline.ErrorHandler] io.debezium.DebeziumException: org.apache.kafka.connect.errors.ConnectException: Snapshotting of table testDB.dbo.tablea failed ... Caused by: org.apache.kafka.connect.errors.ConnectException: Snapshotting of table testDB.dbo.tablea failed ... Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near the keyword 'FROM'. ...