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
Statement "CREATE DOMAIN [dm_name] as BIGINT" raises "numeric value is out of range" if its default value is -9223372036854775808 [CORE6291] #6533
Comments
Commented by: @pavel-zotov Perhaps, this problem relates not only domain definition:SQL> recreate table test(n bigint default -9223372036854775807);
|
Modified by: @AlexPeshkoffassignee: Alexander Peshkov [ alexpeshkoff ] |
Modified by: @AlexPeshkoff |
Modified by: @AlexPeshkoffstatus: Open [ 1 ] => Resolved [ 5 ] resolution: Fixed [ 1 ] Fix Version: 4.0 RC 1 [ 10930 ] |
Commented by: @pavel-zotov Some examples still fail. Checked on WI-T4.0.0.1954 Firebird 4.0 Beta 2: create domain dom06_13 as numeric(20,2) default -9999999999999999991; -- this is from CORE6294; it failed before, now it runs OK create domain dm_bigint_absolute_max as bigint default 9223372036854775807; create domain dm_bigint_near_abs_min as bigint default -9223372036854775807; create domain dm_bigint_absolute_min as bigint default -9223372036854775808; create table test1(n bigint default -9223372036854775808); |
Modified by: @pavel-zotovstatus: Resolved [ 5 ] => Resolved [ 5 ] QA Status: No test => Deferred Test Details: Problem not yet resolved. See note 05/May/20 05:49 AM (here). |
Modified by: @dyemanovFix Version: 4.0 RC 1 [ 10930 ] => |
Modified by: @pavel-zotovstatus: Reopened [ 4 ] => Reopened [ 4 ] QA Status: Deferred => Done successfully Test Details: Problem not yet resolved. See note 05/May/20 05:49 AM (here). => |
Submitted by: @pavel-zotov
Duplicates CORE6294
Run this script:
create domain dm_bigint_absolute_max as bigint default 9223372036854775807;
create domain dm_bigint_near_abs_min as bigint default -9223372036854775807;
create domain dm_bigint_absolute_min as bigint default -9223372036854775808;
Its last statement will raise:
Statement failed, SQLSTATE = 22003
unsuccessful metadata update
-CREATE DOMAIN DM_BIGINT_ABSOLUTE_MIN failed
-Dynamic SQL Error
-SQL error code = -104
-arithmetic exception, numeric overflow, or string truncation
-numeric value is out of range
Only 4.x is affected (I've checked several 64-bit snapshots, since 4.0.0.840 and up to current 4.0.0.1935; result is the same on Windows and Linux).
The text was updated successfully, but these errors were encountered: