Help Center> Data Warehouse Service (DWS)> 8.2.1 or later versions> Parser> Grammatical Analysis
Updated on 2023-12-22 GMT+08:00
View PDF

Grammatical Analysis

GS_212100030

errmsg:unrecognized row security option %s.

errhint: Only PERMISSIVE or RESTRICTIVE policies are supported currently.

level:ERROR

GS_212100035

errmsg:RECHECK is no longer required.

errhint: Update your data type.

level:NOTICE

GS_212100039

errmsg:missing argument.

errhint: Use NONE to denote the missing argument of a unary operator.

level:ERROR

GS_212100063

errmsg:JOIN expression is not allowed.

errhint: USING clause can only be a table or a subquery.

level:ERROR

GS_212100069

errmsg:VALUES in FROM must have an alias.

errhint: For example, FROM (VALUES ...) [AS] foo.

level:ERROR

GS_212100171

errmsg:INCLUDING PARTITION option cannot be specified when creating table with \PARTITION BY\ clause.

errhint: Use either INCLUDING PARTITION option or PARTITION BY clause.

level:ERROR

GS_212100172

errmsg:INCLUDING RELOPTIONS option cannot be specified when creating table with.

errhint: Use either INCLUDING RELOPTIONS option or \WITH\ clause.

level:ERROR

GS_212100173

errmsg:\INCLUDING DISTRIBUTION\ option cannot be specified when creating table with \DISTRIBUTE BY\ clause.

errhint: Use either \INCLUDING DISTRIBUTION\ option or \DISTRIBUTE BY\ clause.

level:ERROR

GS_212100206

errmsg:The view %s is invalid!

errhint: Please turn on GUC parameter \view_independent\.

level:ERROR

GS_212100812

errmsg:%s can't outer join with more than one relation.

errhint: %s outer join with one relation.

level:ERROR

GS_212100832

errmsg:VALUES must not contain OLD or NEW references.

errhint: Use SELECT ... UNION ALL ... instead.

level:ERROR

GS_212100867

errmsg:Invalid column reference in the INSERT VALUES Clause.

errhint: You may have referenced target table's column.

level:ERROR

GS_212100945

errmsg:SET %s = rolename not yet supported.

errhint: Use SET %s rolename clauses.

level:ERROR

GS_212100958

errmsg:SET %s TO rolename not yet supported.

errhint: Use SET %s rolename clauses.

level:ERROR

GS_212100960

errhint: "%s", "%s"...are specified Operator "(+)" in one condition.

errmsg:Operator "(+)" can't be specified on more than one relation in one join condition.

level:ERROR

GS_212100963

errmsg:subquery in FROM cannot refer to other relations of same query level.

errhint: maybe alias conflicts with column of other relation.

level:ERROR

GS_212100973

errhint: Use an explicit ordering operator or modify the query.

errmsg:could not identify an ordering operator for type %s.

level:ERROR

GS_212100977

errmsg:recursive query %s column %d has collation %s in non-recursive term but collation %s overall.

errhint: Use the COLLATE clause to set the collation of the non-recursive term.

level:ERROR

GS_212100984

errmsg:recursive query %s column %d has type %s in non-recursive term but type %s overall.

errhint: Cast the output of the non-recursive term to the correct type.

level:ERROR

GS_212100991

errmsg:collation mismatch between implicit collations %s and %s.

errhint: You can choose the collation by applying the COLLATE clause to one or both expressions.

level:ERROR

GS_212101101

errmsg:INSERT has more target columns than expressions.

errhint: The insertion source is a row expression containing the same number of columns expected by the INSERT. Did you accidentally use extra parentheses?

level:ERROR

GS_212101106

errmsg:Unsupport view independent feature.

errhint: Please turn on GUC parameter \view_independent\.

level:ERROR

GS_212110010

errmsg:operator %s is not a valid ordering operator.

errhint: Ordering operators must be \<\ or \>\ members of btree operator families.

level:ERROR

GS_212120795

errmsg:array assignment requires type %s but expression is of type %s.

errhint: You will need to rewrite or cast the expression.

level:ERROR

GS_212120801

errmsg:operator is not unique: %s.

errhint: Could not choose a best candidate operator. You might need to add explicit type casts.

level:ERROR

Parent topic: Parser