Version
All the versions of Altibase
Symptom
The following error occurs when executing INSERT/UPDATE, etc.
[ERR-21010: Value overflow]
Cause
The description of the error can be checked using the altierr utility as follows.
$ altierr 0x21010
0x21010 ( 135184) mtERR_ABORT_VALUE_OVERFLOW Value overflow
# *Cause: Value overflow
# *Action: Please change the value or data type.
In other words, it is an error that occurs when the input value exceeds the range supported by the data type.
# Example
The range of integer type values is -2,147,483,647 ~ 2,147,483,647 integer values.
Therefore, the error occurred because the value to be stored in the column is out of the range of the integer value.
Solution
Check if the input value to be saved in a specific column exceeds the maximum size of the column data type.
If it exceeds the maximum size, it is necessary to modify the input value or change the data type of the column.
Notes/Considerations
The range of values for each data type supported by Altibase can be found in the General Reference manual at http://support.altibase.com/en/manual/ or GitHub: https://github.com/ALTIBASE/Documents.