New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

bug: numeric functions combine result is not right #14189

Closed

BohuTANG opened this issue Dec 30, 2023 · 1 comment · Fixed by #14195

Labels

C-bug found-by-GPT4

Member

BohuTANG commented Dec 30, 2023 •

edited

Loading

Summary

SELECT 
    (POW(FLOOR(ABS(9876.54321) * 10000), 2) % 18446744073709551615) + 
    (FLOOR(EXP(SQRT(1234.56789)) * 10000) % 18446744073709551615) - 
    (FLOOR(PI() * 10000) % 18446744073709551615) AS uint64_like_result;

Databend:1.8188020807335311e19
MySQL: 1.8188025698028737e19
Snowflake: 1.81880256980287e+19
DuckDB: 18188025698028737000

The text was updated successfully, but these errors were encountered:

BohuTANG added C-bug found-by-GPT4 labels

Member

sundy-li commented Jan 2, 2024

Snowflake will drop precisions for unknown reasons. I think duckdb & MySQL handle it better.

sundy-li mentioned this issue

feat: support abs for decimal types #14195

Merged

11 tasks

BohuTANG closed this as completed in #14195

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment