KFAA30802-E
An overflow occurred for the "bb....bb" data type during processing of the function "aa....aa". (M+J+O)
An overflow occurred while a set function or a window function was executing. <SQLSTATE: 22003>
-
COUNT
The number of target data items exceeded the maximum value that can be handled with the INTEGER type.
-
SUM
An overflow occurred when the data being handled was added.
-
AVG
One of the following errors occurred:
• An overflow occurred when the target data was added.
• The number of target data items exceeded the maximum value for the INTEGER type.
-
STDDEV_POP, STDDEV_SAMP, VAR_POP, or VAR_SAMP
One of the following errors occurred:
• An overflow occurred when the target data or the square of the target data was added.
• The number of target data items exceeded the maximum value for the INTEGER type.
• An overflow occurred when the target data was multiplied.
• An overflow occurred when the result of a function was obtained from the sum of the target data, the sum of the squares of the target data, and the number of target data items.
-
PERCENTILE_CONT or MEDIAN
One of the following errors occurred:
• The number of target data items exceeded the maximum value for the INTEGER type.
• An overflow occurred when the result of a function was obtained from The number of target data items and the function's argument values.
-
PERCENTILE_DISC
The number of target data items exceeded the maximum value for the INTEGER type.
-
RANK, DENSE_RANK, CUME_DIST, or ROW_NUMBER
The number of target data items exceeded the maximum value for the INTEGER type.
- aa....aa:
-
Name of the function resulting in an error
- bb....bb: Data type that generated the overflow
-
-
INTEGER
-
SMALLINT
-
DECIMAL
-
DOUBLE PRECISION
-
- S:
-
Ignores this SQL statement. Alternatively, the system invalidates this transaction.
- Action:
-
Eliminate the cause of the overflow by taking an action such as reducing the number of data items handled by the operation. For details about the maximum and minimum values for each data type, see List of data types in the manual HADB SQL Reference.