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

cast(varchar as real): Velox throws while Presto returns non-NULL #11034

Open
kagamiori opened this issue Sep 19, 2024 · 0 comments
Open

cast(varchar as real): Velox throws while Presto returns non-NULL #11034

kagamiori opened this issue Sep 19, 2024 · 0 comments
Labels
bug Something isn't working fuzzer-found

Comments

@kagamiori
Copy link
Contributor

kagamiori commented Sep 19, 2024

Description

Query: select cast(c0 as real) from (values '5d') t(c0);
Presto-0.289: Returns 5
Velox: Throws an exception "Cannot cast VARCHAR '5d' to REAL."

Same mismatch with cast(c0 as double), '5D', '5f', and '5F'.

Error Reproduction

No response

Relevant logs

No response

@kagamiori kagamiori added bug Something isn't working fuzzer-found labels Sep 19, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working fuzzer-found
Projects
None yet
Development

No branches or pull requests

1 participant