注册

nodejs下,如果小数位超过列的定义,会报错。

雅彦 2025/08/25 167 0
query: UPDATE "KANBAN"."sales_kanban_list" SET "oil_quantity1" = :1, "oil_quantity2" = :2, "not_oil_money" = :3 WHERE ("kanbanStationId" = :4 AND "kanbanYear" = :5 AND "month" = :6 AND "oil_quantity1" = :7) -- PARAMETERS: [585.97,29.58,63.05107879638672,"33153307",2025,1,0]
query failed: UPDATE "KANBAN"."sales_kanban_list" SET "oil_quantity1" = :1, "oil_quantity2" = :2, "not_oil_money" = :3 WHERE ("kanbanStationId" = :4 AND "kanbanYear" = :5 AND "month" = :6 AND "oil_quantity1" = :7) -- PARAMETERS: [585.97,29.58,63.05107879638672,"33153307",2025,1,0]
error: u [Error]: [-6102] 数字溢出
    at new u (E:\Programe\sinopec\kanban-board-server\node_modules\dmdb\src\driver\error.js:28:19)
    at u.EC_DATA_OVERFLOW (E:\Programe\sinopec\kanban-board-server\node_modules\dmdb\src\driver\error.js:157:16)
    at c.checkPrec (E:\Programe\sinopec\kanban-board-server\node_modules\dmdb\src\driver\numeric.js:82:92)
    at c.encode (E:\Programe\sinopec\kanban-board-server\node_modules\dmdb\src\driver\numeric.js:46:14)
    at o.fromNumber (E:\Programe\sinopec\kanban-board-server\node_modules\dmdb\src\convert\j2db.js:163:69)
    at t.<anonymous> (E:\Programe\sinopec\kanban-board-server\node_modules\dmdb\src\driver\statement.js:538:40)
    at E:\Programe\sinopec\kanban-board-server\node_modules\dmdb\src\driver\statement.js:108:27
    at Object.next (E:\Programe\sinopec\kanban-board-server\node_modules\dmdb\src\driver\statement.js:119:14)
    at E:\Programe\sinopec\kanban-board-server\node_modules\dmdb\src\driver\statement.js:42:37
    at new Promise (<anonymous>)

回答 0
暂无回答
扫一扫
联系客服