Postgresql ARRAY support

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).