Re: Unexpected rounding value for updating Decimal field

[Rui Quelhas]

Hi Kevin,

looks like the rounding is happening on the X Plugin. Connector/Node.js decides if it needs to send an X Protocol V_DOUBLE value in order to accommodate the precision, however, in you particular case, it ends up sending a V_FLOAT instead, given there is no possibility of precision loss.

In my honest opinion, the X Plugin should be able to account for that, however, I've tried to reproduce the same scenario using the MySQL Shell and other connectors and came to the conclusion that they all end up sending V_DOUBLE no matter the case, and the problem does not exist. So I guess we can also do the same in Connector/Node.js.

I suggest you create a bug report describing this issue in our public issue tracker (https://bugs.mysql.com/) using the "Connector for Node.js" category.

As a workaround, I think the only possibility is to use a plain SQL statement with Session.sql().

Hope it helps.


Thanks