Skip to content
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.

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

Error precision and scale for decimal coercion in logic comparison #2232

Closed
liukun4515 opened this issue Apr 14, 2022 · 3 comments · Fixed by #2241
Closed

Error precision and scale for decimal coercion in logic comparison #2232

liukun4515 opened this issue Apr 14, 2022 · 3 comments · Fixed by #2241

Comments

@liukun4515
Copy link
Contributor

Is it worth checking somewhere what happens with different decimal scales?

Something like

select * from decimal_simple where c1 >= CAST(0.00002 as Decimal(10,8))

I am not sure if the coercion to an appropriate decimal type is covered elsewhere

Originally posted by @alamb in #2200 (comment)

@liukun4515
Copy link
Contributor Author

This is caused bycomparison_binary_numeric_coercion in the binary_rule.rs

@liukun4515
Copy link
Contributor Author

It will fixed in the next pr

@liukun4515
Copy link
Contributor Author

liukun4515 commented Apr 15, 2022

For the comparison rule
#1483

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

Successfully merging a pull request may close this issue.

1 participant