10.8.5 requires configuration that breaks workers that use `query`

[whit0694]

When deploying a JDBC Source worker after upgrading to 10.8.5 I got this error:

At least one table filtering configuration is required. Provide one of: table.whitelist, table.blacklist, table.include.list, or table.exclude.list.

I believe this was added in #1543

But if an option like table.include.list is provided, then source workers that use the query param throw this error

org.apache.kafka.connect.errors.ConnectException: query may not be combined with whole-table copying settings

That error is coming from

kafka-connect-jdbc/src/main/java/io/confluent/connect/jdbc/JdbcSourceConnector.java

Line 128 in 5c46c3a

throw new ConnectException(JdbcSourceConnectorConfig.QUERY_CONFIG + " may not be combined"

So it seems that with 10.8.5 I can only deploy a query source worker with configuration that breaks my query source worker.

[IaC-in-Russian]

Hi, I solved the problem this way

Added incrementing.column.name: "id" and mode: "bulk" worked without errors.

connector example:
config:
name: "kafka-connect-test"
poll.interval.ms: "600000"
connector.class: "io.confluent.connect.jdbc.JdbcSourceConnector"
connection.password: "{{ password }}"
connection.user: "kafka_user"
connection.url: "jdbc:postgresql://server:port/db"
tasks.max: "1"
query: "SELECT * FROM public.table WHERE id = '1'"
batch.max.rows: "1000"
incrementing.column.name: "id"
mode: "bulk"
transforms.ExtractKey.type: "org.apache.kafka.connect.transforms.ValueToKey"
transforms: "ExtractKey"
transforms.ExtractKey.fields: "id"
topic.prefix: "test.topic"
value.converter: "org.apache.kafka.connect.json.JsonConverter"
key.converter: "org.apache.kafka.connect.json.JsonConverter"

version: debezium 3.2.0.Final plugin confluentinc-kafka-connect-jdbc-10.8.5