Hitachi

Hitachi Advanced Database Messages


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.