in holo-client/src/main/java/com/alibaba/hologres/client/impl/UnnestUpsertStatementBuilder.java [269:308]
private boolean isTypeSupportForUnnest(int type, String typeName) {
switch (type) {
case Types.BOOLEAN:
case Types.INTEGER:
case Types.SMALLINT:
case Types.TINYINT:
case Types.REAL:
case Types.FLOAT:
case Types.DOUBLE:
case Types.CHAR:
case Types.VARCHAR:
case Types.LONGVARCHAR:
case Types.BINARY:
case Types.VARBINARY:
case Types.LONGVARBINARY:
case Types.TIMESTAMP:
case Types.TIMESTAMP_WITH_TIMEZONE:
case Types.DATE:
case Types.TIME_WITH_TIMEZONE:
case Types.NUMERIC:
return true;
case Types.BIT:
if ("bool".equals(typeName)) {
return true;
}
return false;
case Types.BIGINT:
if ("oid".equals(typeName)) {
return false;
}
return true;
case Types.OTHER:
if ("json".equals(typeName) || "jsonb".equals(typeName)) {
return true;
}
return false;
default:
return false;
}
}