alibaba / alibaba/DataX

Datax从MySQL到OceanBases,bit类型导入失败

Open
#1,215 1 comment 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

{"byteSize":1,"rawData":true,"type":"BOOL"}],"size":14}
2021-11-11 11:18:14.284 [taskGroup-0] INFO TaskGroupContainer - taskGroup[0] taskId[1] is successed, used[503]ms
2021-11-11 11:18:15.282 [1-insertTask-34] INFO InsertTask - do one insert
2021-11-11 11:18:15.313 [1-insertTask-34] ERROR StdoutPluginCollector -
com.alipay.oceanbase.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'processed' at row 1

手动插入是可以的
insert into test(id,datachange_lasttime,processed)values(1,now(),true);
Query OK, 1 row affected (0.024 sec)

OS:Centos7
MySQL:5.7
OceanBase:v3.1.1_CE_BP1
DataX:DATAX-OPENSOURCE-3.0

Contributor guide

No contributing guide indexed for this repository

Research direction

No source file or test is identified. Reproduce the MySQL-to-OceanBase transfer using the reported bit/BOOL column, the provided environment details, and the failing log, then compare it with the successful manual insert. Done means the bit value imports without the reported data-truncation error.

Written by the indexing model from the issue text.

Assessment

Tech stack
mysql
Domain
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.