Datax从MySQL到OceanBases,bit类型导入失败
- 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