alibaba / alibaba/DataX

mssql原始库如果为decimal类型时,值为0的时候,读取为0E-8,此时目标库字段同为类型会报错

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

Dear,
在同步时测试发现,原库和目标库为同一类型数据库,且字段名和类型都相同。如果为decimal类型时,值为0的时候,读取为0E-8,此时目标库字段同为类型会报错:
![image](https://user-images.githubusercontent.com/5625433/128963961-313a3e09-cd37-4430-98b2-8e19378e3276.png)

Contributor guide

No contributing guide indexed for this repository

Research direction

The report names no files, tests, or entry points. Reproduce a sync from MSSQL with a decimal value of zero, then trace the Java decimal conversion and target write path; done means the same-type target database accepts the value without the reported error.

Written by the indexing model from the issue text.

Assessment

Tech stack
java, sql
Domain
databases
Issue type
Bug
Difficulty
3/5
Estimated time
1-2 days
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
25/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.