alibaba / alibaba/DataX

read mysql bit convert to opengauss bool to write but got error :Truncated incorrect DOUBLE value: true

Open
#2,330 0 comments 0 reactions 0 assignees View on GitHub
Dominant language
Java
Stars
17.4k
Forks
5.7k
PR merge metrics
No merged PRs in 30d

Description

what i'm supposed to do is merge data from mysql to opengauss,but get error :Truncated incorrect DOUBLE value: true
that field in mysql is bit(1), bool in opengauss。

Contributor guide

No contributing guide indexed for this repository

Research direction

The report concerns merging a MySQL bit(1) field into an openGauss bool field, but it does not identify a DataX reader, writer, file, or test. Start by locating the MySQL reader and openGauss writer paths used for this transfer and how they convert boolean values; reproduce the reported truncated-value error. Done means the bit(1) value transfers to the bool column without that error.

Written by the indexing model from the issue text.

Assessment

Tech stack
java, mysql, postgresql
Domain
data-engineering, databases
Issue type
Bug
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
35/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.