You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
An insert statement with a decimal close to the minimum fails.
To Reproduce
v0.3.2-dev1136 0a65256
Enter ".help" for usage hints.
Connected to a transient in-memory database.
Use ".open FILENAME" to reopen on a persistent database.
D create table q (big decimal (38,10));
D insert into q (big ) values (-9999999999999999899999999999.9999999999);
Error: Conversion Error: Could not cast value -99999999999999997748809823456034029568.000000 to DECIMAL(38,10)
Before you start counting: Yes these are 38 numbers in the insert statement.
It appears that the number was cast to a double as the error message comes from cast_operators.cpp line 1971.
Environment (please complete the following information):
OS: Linux
DuckDB Client: CLI, Java, WASM
Before Submitting
Have you tried this on the latest master branch?
Have you tried the steps to reproduce? Do they include all relevant data and configuration? Does the issue you report still appear there?
The text was updated successfully, but these errors were encountered:
What happens?
An insert statement with a decimal close to the minimum fails.
To Reproduce
v0.3.2-dev1136 0a65256
Enter ".help" for usage hints.
Connected to a transient in-memory database.
Use ".open FILENAME" to reopen on a persistent database.
D create table q (big decimal (38,10));
D insert into q (big ) values (-9999999999999999899999999999.9999999999);
Error: Conversion Error: Could not cast value -99999999999999997748809823456034029568.000000 to DECIMAL(38,10)
Before you start counting: Yes these are 38 numbers in the insert statement.
It appears that the number was cast to a double as the error message comes from cast_operators.cpp line 1971.
Environment (please complete the following information):
Before Submitting
master
branch?The text was updated successfully, but these errors were encountered: