Aiven-Open / Aiven-Open/jdbc-connector-for-apache-kafka

Sink Connector - Postgresql - Incorrect Handling of Default Value for Boolean Type

未关闭
#173 2 条评论 1 个 reaction 已指派 0 人 在 GitHub 查看
主要语言
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 还没有评估数据。

把新 issue 发到你的邮箱

精选适合新手参与的 GitHub issue 摘要。