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

cannot insert into a UInt64 column #2302

Open
universalmind303 opened this issue Dec 24, 2023 · 1 comment
Open

cannot insert into a UInt64 column #2302

universalmind303 opened this issue Dec 24, 2023 · 1 comment
Assignees
Labels
bug Something isn't working
Milestone

Comments

@universalmind303
Copy link
Contributor

Description

I noticed this while reviewing #2298

> create table test (value bigint unsigned);
Table created
> insert into test values (9223372036854775807); -- (i64::max)
Inserted 1 row
> insert into test values (9223372036854775808); -- (i64::max + 1)
Error: External error: External error: Generic DeltaTable error: External error: Arrow error: Cast error: Can't cast value 9223372036854775808 to type Int64

we can see that the dtype was properly set on the table

> describe test;
┌─────────────┬───────────┬─────────────┐
│ column_name │ data_type │ is_nullable │
│ ──          │ ──        │ ──          │
│ Utf8        │ Utf8      │ Boolean     │
╞═════════════╪═══════════╪═════════════╡
│ value       │ UInt64    │ true        │
└─────────────┴───────────┴─────────────┘

it seems like something is failing when writing to the delta tables.

@universalmind303 universalmind303 added the bug Something isn't working label Dec 24, 2023
@universalmind303 universalmind303 added this to the next milestone Jan 10, 2024
@vrongmeal
Copy link
Contributor

I think this is because we don’t support creating unsigned integer fields (since PG doesn’t have unsigned ints). We should definitely change it though. This is technically a feature rather than a bug.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working
Projects
None yet
Development

No branches or pull requests

2 participants