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
I have field numeric (10,0) and database allows to insert into this field values larger than specified.
Fo example:
Field numeric(10,0) allow to insert value : 1234567890123456789
max value which I can insert in this field numeric(19).
The text was updated successfully, but these errors were encountered:
This is not really a bug, more like a design pitfall. In Firebird, both numerics and decimals implement what the SQL specification declares for decimals, i.e. they may have a precision equal or bigger than what's specified in the declaration.
Firebird and InterBase before it have had this behavior from the beginning,
so it's hardly a major bug. It is non-standard behavior, so it qualifies as a
bug. On the other hand, the workaround is trivial: add a check constraint
that explicitly limits the range of the value.
Will be good if that check will be added automatically by the engine in the future version of Firebird
or something like RESTRICT should be implemented like
Submitted by: Paweł (chosenone)
Is duplicated by CORE5894
Votes: 2
I have field numeric (10,0) and database allows to insert into this field values larger than specified.
Fo example:
Field numeric(10,0) allow to insert value : 1234567890123456789
max value which I can insert in this field numeric(19).
The text was updated successfully, but these errors were encountered: