Modulus can produce incorrect results in some cases

[andygrove]

Describe the bug

Example of compatibility issue found by fuzz testing:

SELECT c90, c1, c90 % c1 FROM test1 ORDER BY c90, c1;

Spark: -21840,-0.0,NULL Comet: -21840,-0.0,NaN

Steps to reproduce

No response

Expected behavior

No response

Additional context

No response

[vaibhawvipul]

working on it.

[vaibhawvipul]

issue filed - https://github.com/apache/datafusion/issues/11051

[vaibhawvipul]

another one - https://github.com/apache/datafusion/issues/11108