Help Center> Data Warehouse Service (DWS)> 8.2.0 and earlier versions> Data Warehouse Service Error Codes> GAUSS-00101 -- GAUSS-00200> GAUSS-00161 -- GAUSS-00170
Updated on 2023-12-22 GMT+08:00
View PDF

GAUSS-00161 -- GAUSS-00170

GAUSS-00161: "wrong number of parameters on right side of OVERLAPS expression"

SQLSTATE: 42601

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

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

GAUSS-00162: "multiple ORDER BY clauses not allowed"

SQLSTATE: 42601

Description: Multiple ORDER BY clauses are used in the INSERT INTO SELECT syntax.

Solution: Use one ORDER BY clause in the INSERT INTO SELECT syntax.

GAUSS-00163: "multiple OFFSET clauses not allowed"

SQLSTATE: 42601

Description: Multiple offset clauses are used in the INSERT INTO SELECT syntax.

Solution: Use one offset clause in the INSERT INTO SELECT syntax.

GAUSS-00164: "multiple LIMIT clauses not allowed"

SQLSTATE: 42601

Description: Multiple limit clauses are used in the INSERT INTO SELECT syntax.

Solution: Use one limit clause in the INSERT INTO SELECT syntax.

GAUSS-00165: "multiple WITH clauses not allowed"

SQLSTATE: 42601

Description: Multiple WITH clauses are used in the INSERT INTO SELECT syntax.

Solution: Use one WITH clause in the INSERT INTO SELECT syntax.

GAUSS-00166: "OUT and INOUT arguments aren't allowed in TABLE functions"

SQLSTATE: 42601

Description: The out/inout parameter type is used in the table function.

Solution: Do not use the out/inout parameter type in the table function.

GAUSS-00167: "multiple COLLATE clauses not allowed"

SQLSTATE: 42601

Description: The collate clause is specified multiple times.

Solution: Specify the collate clause only once.

GAUSS-00168: "unexpected node type %d"

SQLSTATE: XX000

Description: Internal system error.

Solution: Contact technical support.

GAUSS-00169: "%s constraints cannot be marked DEFERRABLE"

SQLSTATE: 0A000

Description: The constraint that cannot be marked with DEFERRABLE is used.

Solution: Modify the SQL statement.

GAUSS-00170: "%s constraints cannot be marked NOT VALID"

SQLSTATE: 0A000

Description: The constraint that cannot be marked with NOT VALID is used.

Solution: Modify the SQL statement.