-
Notifications
You must be signed in to change notification settings - Fork 173
Minimum hugeint overflows in conversion to PG numeric #593
Copy link
Copy link
Open
Labels
bugSomething isn't workingSomething isn't workingincorrect resultBugs that return incorrect dataBugs that return incorrect data
Description
Description
This query returns 0:
select * from duckdb.query($$ select '-170141183460469231731687303715884105728'::hugeint as result $$);
But one higher works fine:
select * from duckdb.query($$ select '-170141183460469231731687303715884105728'::hugeint + 1 as result $$);
The reason for this is that this line overflows, because the positive 170141183460469231731687303715884105728 cannot be represented in a signed int128.
Found by #577
Reactions are currently unavailable
Metadata
Metadata
Assignees
Labels
bugSomething isn't workingSomething isn't workingincorrect resultBugs that return incorrect dataBugs that return incorrect data