Aiven-Open / Aiven-Open/jdbc-connector-for-apache-kafka
Sink Connector - Postgresql - Incorrect Handling of Default Value for Boolean Type
未关闭
- 主要语言
- Java
- 星标
- 113
- 派生
- 62
- 平均合并
- 4 小时 12 分钟
- 30 天内合并 PR
- 1
描述
**Problem Description**
Below is the schema of a boolean field (in Kafka Topic)
{
"default": true,
"field": "is_active",
"optional": false,
"type": "boolean"
}
Set the auto.create to true in the sink connector configurations.
The sink connector fails to auto create the table with the below error message:
`ERROR: column "is_active" is of type boolean but default expression is of type integer`
This is because the sink connector, in it's DDL, has the default value as 1 for the boolean column, instead of true.
Please let me know if there is any workaround for this issue.
贡献指南
评估
这个 Issue 还没有评估数据。