[Question] 查询结果被四舍五入

[iuwai]

描述问题
清查询结果被四舍五入

复现
重现该行为的步骤:

1. 执行查询操作
2. sql示例：select * from table1 where record_id = 111111111149234033

截图

部署方式
Manual

环境 (请填写环境信息):

• 操作系统: all
• 浏览器 [chrome]

[Issues-translate-bot]

Bot detected the issue body's language is not English, translate it automatically. 👯👭🏻🧑‍🤝‍🧑👫🧑🏿‍🤝‍🧑🏻👩🏾‍🤝‍👨🏿👬🏿

---

Title: [Question] Query results are rounded

[ddl1228]

我也遇到这个问题，请问怎么解决？

[Issues-translate-bot]

Bot detected the issue body's language is not English, translate it automatically. 👯👭🏻🧑‍🤝‍🧑👫🧑🏿‍🤝‍🧑🏻👩🏾‍🤝‍👨🏿👬🏿

---

I also encountered this problem, how to solve it?

[ddl1228]

I also encountered this problem, how to solve it?

[unslur]

如果只查询ID 很恼火的写法
SELECT concat(id,"") from qw_call_urge_payment_call_record WHERE urge_id IN(317,142,69,312,323,465)

[Piean]

V3.1.4 我也遇到这个问题，应该是和前端JS不支持bigint导致精度丢失，希望尽快修复

[Issues-translate-bot]

Bot detected the issue body's language is not English, translate it automatically. 👯👭🏻🧑‍🤝‍🧑👫🧑🏿‍🤝‍🧑🏻👩🏾‍🤝‍👨🏿👬🏿

---

V3.1.4 I also encountered this problem. It should be caused by the front-end JS not supporting bigint, resulting in loss of precision. I hope it will be fixed as soon as possible.

[cookieY]

将会在接下来的 3.1.9 版本彻底解决

[cookieY]

3.1.9 版本已修复

[Issues-translate-bot]

Bot detected the issue body's language is not English, translate it automatically. 👯👭🏻🧑‍🤝‍🧑👫🧑🏿‍🤝‍🧑🏻👩🏾‍🤝‍👨🏿👬🏿

---

Version 3.1.9 has been fixed

[ddl1228]

3.1.9还没完全修复，我们有两个数据库，其中一个库查询时精度没问题，另一个库查询时精度还是有问题

[Issues-translate-bot]

Bot detected the issue body's language is not English, translate it automatically. 👯👭🏻🧑‍🤝‍🧑👫🧑🏿‍🤝‍🧑🏻👩🏾‍🤝‍👨🏿👬🏿

---

3.1.9 has not been fully repaired. We have two databases. One database has no problem with accuracy when querying, but the other database still has accuracy problems when querying.

[cookieY]

请给一份复现的数据 包括脱敏后的建表语句以及 插入值

[Issues-translate-bot]

Bot detected the issue body's language is not English, translate it automatically. 👯👭🏻🧑‍🤝‍🧑👫🧑🏿‍🤝‍🧑🏻👩🏾‍🤝‍👨🏿👬🏿

---

Please provide a copy of the reproduced data, including the desensitized table creation statement and inserted values.

[ddl1228]

CREATE TABLE ecs_stockup_req_detail_test (
scm_order_rec_id bigint(20) unsigned NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT INTO ecs_stockup_req_detail_test(scm_order_rec_id) VALUES (1853760420422066178);

[ddl1228]

It's been fixed, thanks