Aiven-Open / Aiven-Open/jdbc-connector-for-apache-kafka
Sink Connector - Postgresql - Incorrect Handling of Default Value for Boolean Type
Open
- 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
Assessment
This issue has not been assessed yet.