Help Center/ GaussDB(DWS)/ 8.2.0 and earlier versions/ Data Warehouse Service Error Codes/ GAUSS-00101 -- GAUSS-00200/ GAUSS-00151 -- GAUSS-00160
Updated on 2023-12-22 GMT+08:00
View PDF
Share

GAUSS-00151 -- GAUSS-00160

GAUSS-00151: "UNIQUE predicate is not yet implemented"

SQLSTATE: 0A000

Description: The UNIQUE clause is not implemented.

Solution: Use a clause that has been implemented.

GAUSS-00152: "RANGE PRECEDING is only supported with UNBOUNDED"

SQLSTATE: 0A000

Description: UNBOUNDED is not specified when RANGE PRECEDING is used.

Solution: Specify UNBOUNDED when using RANGE PRECEDING.

GAUSS-00153: "RANGE FOLLOWING is only supported with UNBOUNDED"

SQLSTATE: 0A000

Description: UNBOUNDED is not specified when RANGE FOLLOWING is used.

Solution: Specify UNBOUNDED when using RANGE FOLLOWING.

GAUSS-00154: "frame start cannot be UNBOUNDED FOLLOWING"

SQLSTATE: 42P20

Description: UNBOUNDED FOLLOWING is specified for the frame start clause, which is incorrect.

Solution: Do not specify UNBOUNDED FOLLOWING for the frame start statement.

GAUSS-00155: "frame starting from following row cannot end with current row"

SQLSTATE: 42P20

Description: frame starts from the next row and ends in the current row.

Solution: Ensure that frame does not end in the current row if it starts from the next row.

GAUSS-00156: "frame end cannot be UNBOUNDED PRECEDING"

SQLSTATE: 42P20

Description: frame end is set to UNBOUNDED PRECEDING, which is incorrect.

Solution: Do not set frame end to UNBOUNDED PRECEDING.

GAUSS-00157: "frame starting from current row cannot have preceding rows"

SQLSTATE: 42P20

Description: frame starts from the current row and ends in the previous row.

Solution: Ensure that frame does not end in the previous row if it starts from the current row.

GAUSS-00158: "frame starting from following row cannot have preceding rows"

SQLSTATE: 42P20

Description: frame starts from the next row and ends in the previous row.

Solution: Ensure that frame does not end in the previous row if it starts from the next row.

GAUSS-00159: "type modifier cannot have parameter name"

SQLSTATE: 42601

Description: The parameter schema for the number of rows contains a parameter name.

Solution: Ensure that the parameter schema for the number of rows does not contain a parameter.

GAUSS-00160: "wrong number of parameters on left side of OVERLAPS expression"

SQLSTATE: 42601

Description: The number of left parameters for the overlaps function is greater than 2.

Solution: Use no more than two left parameters for the overlaps function.