ERR-21010

Value overflow

Version

All versions

Explanation

Unable to execute an INSERT or UPDATE statement.

This error message is output when an INSERT or UPDATE statement is executed:

Cause

The following error description can be viewed with the AltiErr utility:

$ altierr 0x21010

0x21010 ( 135184) mtERR_ABORT_VALUE_OVERFLOW Value overflow

# *Cause: Value overflow

# *Action: Please change the value or data type.

This error occurs when the input value is not within the supported data type range.

# Example

iSQL> create table test(i1 integer);
Create success.
iSQL> insert into test values(2147483648);
[ERR-21010 : Value overflow
0001 : insert into TEST values(2147483648)
                              ^         ^
]
iSQL> insert into test values(2147483647);
1 row inserted.

The INTEGER data type stores integers in the range of  -2,147,483,647~ 2,147,483,647.

This error occurred because the value to be stored in the column is outside this range.

Action

Check whether the value to be stored in the column exceeds the maximum allowed for the column’s data type.

If so, change the input value or convert the column’s data type.

Reference

For further information about the range of values for the data types supported by Altibase, refer to the General Reference Manual.

Copyright ⓒ 2000~2016 Altibase Corporation. All Rights Reserved.

These documents are for informational purposes only. These information contained herein is not warranted to be error-free and is subject to change without notice. Decisions pertaining to Altibase’s product characteristics, features and development roadmap are at the sole discretion of Altibase. Altibase may own related patents, trademarks, copyright or other intellectual property rights of products and/or features discussed in this document.