-
Bug
-
Resolution: Done
-
Major
-
0.10.0.Beta3
-
None
If a new type is introduced as an alias to a built-in type like CREATE DOMAIN money2 AS NUMERIC(12,2); then it is not correctly handled in io.debezium.connector.postgresql.PostgresValueConverter.convertBinary(Column, Field, Object).
The issue is visble in snapshot as the value arrives as the logical Java class and is not thus possible to be converted as a binary value.
See https://issues.jboss.org/browse/DBZ-1009?focusedCommentId=13757501&page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#comment-13757501 for reference.
Key problems
- streaming mode delivers byte representation but snapshot mode delivers Java class
- how to handle default values?