Some math functions return different results between 0.11.0 and 0.12.1

[elonazoulay]

Example: exp(2 * ln(3)) returns 8.999999999999998 in 0.11.0 and 9.000000000000002 in 0.12.1.

To repro:

select <column>, exp(2 * ln(3)) from <table>

for any table. The result is computed during parsing.

[Jackie-Jiang]

Interesting.. We use Math library to calculate these values, and there should be no change between these 2 versions. Could it be caused by different jvm?

[elonazoulay]

For testing, I'm running the same version of everything except the pinot docker image - same config and args.
Both the 0.12.1 and 0.11.0 image use java 11.0.16.

[Jackie-Jiang]

I tried Math.exp(2 * Math.log(3)) and got 9.000000000000002, so I guess this result is expected. IMO both of them are correct, and maybe we should just use fuzzy compare when validating floating point values

[61yao]

@Jackie-Jiang Should we get #10650 merged first to solve the incompatibility problem?