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.

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

[CH] Diff when cast INT to Decimal #8343

Open
KevinyhZou opened this issue Dec 25, 2024 · 0 comments · May be fixed by #8351
Open

[CH] Diff when cast INT to Decimal #8343

KevinyhZou opened this issue Dec 25, 2024 · 0 comments · May be fixed by #8351
Labels
bug Something isn't working triage

Comments

@KevinyhZou
Copy link
Contributor

KevinyhZou commented Dec 25, 2024 •
edited
Loading

Backend

CH (ClickHouse)

Bug description

The first:

select cast(id as decimal(1,0)) from test_tbl3 where id = 55

valina result: NULL
gluten result:55

The second:

select id, cast(id as decimal(9, 1)) from test_tbl3 where id = 137438953483;

valian result:NULL
gluten result: throw decimal overflow exception

Spark version

Spark-3.3.x

Spark configurations

No response

System information

No response

Relevant logs

No response
@KevinyhZou KevinyhZou added bug Something isn't working triage labels Dec 25, 2024
@KevinyhZou KevinyhZou changed the title [CH] Diff when cast BIGINT to Decimal [CH] Diff when cast INT to Decimal Dec 25, 2024
@KevinyhZou KevinyhZou linked a pull request Dec 26, 2024 that will close this issue
Open
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
bug Something isn't working triage
Projects
None yet
Milestone
No milestone
Development

Successfully merging a pull request may close this issue.

[GLUTEN-8343][CH]Fix cast number to decimal KevinyhZou/gluten
1 participant
@KevinyhZou