One solution would be to change the query to cast the decimal type to either a smaller datatype or convert to string or binary.

一种解决方案是更改查询，将十进制类型强制转换为较小的数据类型，或者转换为字符串或二进制。

youdao

You can also use a fixed-precision decimal type, or cast floating-point Numbers to a fixed-precision decimal type before you work with them.

您也可以使用固定精度的十进制类型，或者在使用浮点数之前将它们强制转换为固定精度的十进制类型。

youdao

By default, the scale for a DECIMAL type is 0, which means the DECIMAL data type mimics an integer type.

默认情况下，decimal类型的刻度为0，这意味着DECIMAL数据类型模拟了整数类型。

youdao

So unlike an int, this is the type of number that can have numbers after a decimal place.

所以，不同于int，这个类型的数字,可以有小数位。

哈佛公开课 - 计算机科学课程节选