-
Feature Request
-
Resolution: Done
-
Major
-
0.9.0.Beta2
Zebezium does not support many array types even in case of one-dimensional array.
Array types completely disappeared from event message
Debezium has no converter for the following array types even in case of one-dimensional array. That is, Avro schema has no fieild for these column types. Result message has no field for these column types.
BYTEA[], TIMESTAMP[], TIMESTAMPTZ[], TIME[], TIMETZ[], INTERVAL[], POINT[], VARBIT[], UUID[], XML[], JSON[], JSONB[]
Example Warning message
[l.TableSchemaBuilder] No converter found for column common_0.tbl_2.c_arr_uuid of type _uuid. The column will not be part of change events for that table.
Array types converted to null
Debezium can not parse the following array type values and set *null*s as results even in case of one-dimensional array and "include.unknown.datatypes=true".
BIT[], ENUM[], LINE[], LSEG[], BOX[], PATH[], POLYGON[], CIRCLE[], CIDR[], INET[], MACADDR[], MACADDR8[], INT4RANGE[], INT8RANGE[], NUMRANGE[], TSRANGE[], TSTZRANGE[], DATERANGE[]
Example Warning message
[stgresValueConverter] Unexpected JDBC BINARY value for field c_arr_bit_1 with schema Schema{BOOLEAN}: class=class java.util.Arrays$ArrayList, value=[true]
Request
If "include.unknown.datatypes" is enabled, raw binary representation of a column should be set as the result when Debezium can not parse it.
In conclusion, Debezium should support these array types (at least, array of currently supported types).
- is related to
-
DBZ-1071 Support Postgresql arbitrary-dimensional array
- Closed