snapshot.select.statement.overrides doesn't work with OracleConnector [DBZ-5683]
- Dominant language
- HTML
- Stars
- 6
- Forks
- 8
- Avg merge
- 2d 19h
- Merged PRs (30d)
- 1
Description
Migrated from [DBZ-5683](https://issues.redhat.com/browse/DBZ-5683)
h2. What Debezium connector do you use and what version?
io.debezium.connector.oracle.OracleConnector 1.9.5
h2. What is the connector configuration?
connector.class=io.debezium.connector.oracle.OracleConnector
tasks.max=1
name=my-database
database.dbname=MY_DB
database.user=debezium
database.password=xxxxxxxx
database.hostname=alias.my.domain
database.port=5500
database.server.name=MY_DB
database.history.kafka.bootstrap.servers=kafka-broker:9092
database.history.kafka.topic=schema-changes.oracle
decimal.handling.mode=string
table.include.list=myschema.my_table
snapshot.select.statement.overrides=myschema.my_table
snapshot.select.statement.overrides.myschema.my_table=SELECT my_table.* FROM myschema.my_table where product_id = 36061906
h2. What is the captured database version and mode of depoyment?
On-premises Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.15.0.0.0
h2. What behaviour do you expect?
Filtered initial snapshot with rows only for product_id = 36061906
h2. What behaviour do you see?
Full initial shapshot with all the product_id and not just product_id = 36061906
h2. Do you see the same behaviour using the latest relesead Debezium version?
Haven't tried but I guess it is also an issue as i don't see any changes around that in the release notes.
h2. Do you have the connector logs, ideally from start till finish?
Yes
Contributor guide
Assessment
This issue has not been assessed yet.