KFAA30802-E

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.