-
Bug
-
Resolution: Done
-
Minor
-
2.6.2.Final
-
None
-
False
-
None
-
False
-
-
When generating change events with fields that use camel case and writing the data to a target database that automatically lowers or upper cases columns like PostgreSQL or Oracle, there are situations where the lack of setting quote.identifiers to true can lead to NullPointerExceptions, such as this specific code:
We should ideally guard against NPE and instead validate the ColumnDescriptor, throwing an exception. For example in this case:
Column 'ParamValue' was not found in table 'test_testdb_dbo_MTConfig'. Perhaps consider reviewing whether you should use 'quote.identifiers' when source and target table/column names differ in case.
See https://debezium.zulipchat.com/#narrow/stream/383534-community-jdbc/topic/.E2.9C.94.20NullPointerException.20for.20a.20sink.20record/near/445112752 discussion for more details.
- links to
-
RHEA-2024:139598 Red Hat build of Debezium 2.5.4 release