KFAA30802-E


      
         An overflow occurred while a set function or a window function was executing.

         
            
               If aa....aa is LISTAGG <SQLSTATE:22001>

               The data length of the aggregated data exceeded the maximum length of the LISTAGG result character string.

            

            
               If aa....aa is COUNT <SQLSTATE:22003>

               The number of target data items exceeded the maximum value for the BIGINT type.

            

            
               If aa....aa is SUM <SQLSTATE:22003>

               An overflow occurred when the data being handled was added.

            

            
               If aa....aa is AVG <SQLSTATE:22003>

               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 BIGINT type.

            

            
               If aa....aa is STDDEV_POP, STDDEV_SAMP, VAR_POP, or VAR_SAMP <SQLSTATE:22003>

               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 BIGINT 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.

            

            
               If aa....aa is PERCENTILE_CONT or MEDIAN <SQLSTATE:22003>

               One of the following errors occurred:

               • The number of target data items exceeded the maximum value for the BIGINT 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.

            

            
               If aa....aa is PERCENTILE_DISC <SQLSTATE:22003>

               The number of target data items exceeded the maximum value for the BIGINT type.

            

            
               If aa....aa is RANK, DENSE_RANK, CUME_DIST, or ROW_NUMBER <SQLSTATE:22003>

               The number of target data items exceeded the maximum value for the BIGINT type.

            

            
               If aa....aa is ARRAY_AGG <SQLSTATE:2202F>

               The number of target data items exceeded the maximum number of elements for an array-type column, which is 30,000.

            

         

         
            
               aa....aa:

               
                  Name of the function resulting in an error

               

            
            
               bb....bb: Data type that generated the overflow

               
                  
                     
                        BIGINT: BIGINT type

                     

                     
                        INTEGER: INTEGER type

                     

                     
                        SMALLINT: SMALLINT type

                     

                     
                        DECIMAL: DECIMAL type or NUMERIC type

                     

                     
                        DOUBLE PRECISION: DOUBLE PRECISION type or FLOAT type

                     

                     
                        REAL: REAL type

                     

                     
                        VARCHAR: VARCHAR type

                     

                     
                        STRING: STRING type

                     

                     
                        ARRAY: Array type

                     

                  

               

            
            
               S:

               
                  Ignores this SQL statement. Alternatively, the system invalidates this transaction.

               

            
            
               Action:

               
                  
                     
                        If aa....aa is LISTAGG

                        Re-execute the SQL statement by specifying TRUNCATE for the LISTAGG set function overflow behavior. For details about overflow behavior, see LISTAGG in the manual HADB SQL Reference.

                     

                     
                        If aa....aa is other than LISTAGG

                        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.