ROUND function bug

select ROUND(100 * 0.1 / 100, 2) UNION select ROUND(100 * 0.01 / 100, 2) UNION select ROUND(100 * 212 / 391, 2) in dune v2 result is 54 0.01 0.1 in spark v2 result is 54.22 0.1 0.01 in dune v2 lost .22

Please authenticate to join the conversation.

Upvoters
Status

Open

Board

Bugs

Date

About 3 years ago

Author

alex

Subscribe to post

Get notified by email when there are changes.