为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:8
【操作系统】:linux
【CPU】:浪潮飞腾
【问题描述】*:在使用达梦迁移工具执行迁移出来的sql脚本时,有个Double类型的字段,本来是0.7.执行后变成了0.7000000000000001.但是0.5和0.3还都是原来的.而且使用DM管理工具查看是0.7000000000000001.在使用DataGrap查看时就是0.7.但是java程序获取到的结果就是0.7000000000000001
INSERT INTO "DECLARE_APPLY_RESULT"("ID","DECLARE_APPLY_ID","REVIEW_STATUS","REVIEW_SCORE","REVIEW_WEIGHT","REPLY_STATUS","REPLY_SCORE","REPLY_WEIGHT","RESULT_SCORE","VOTE_RESULT","EXPERT_ID","RECOMMENDATIONS","COMPREHENSIVE_EVALUATION","IS_VALID") VALUES(2258,3654,'2',58.8,0.7,'2',44.0,0.3,54.36,null,115,0,'研究视野有待提升');
double的值是不精确的,建议用number(m,n)