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

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

Open
#173 2 comments 1 reaction 0 assignees View on GitHub
Dominant language
Java
Stars
113
Forks
62
Avg merge
4h 12m
Merged PRs (30d)
1

Description

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

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.