Updated on 2023-12-22 GMT+08:00

GAUSS-00091 -- GAUSS-00100

GAUSS-00091: "IS DISTINCT FROM requires = operator to yield boolean"

SQLSTATE: 42804

Description: In the IS DISTINCT FROM statement, the value returned for the operator used for deduplication is not of the Boolean type.

Solution: In the IS DISTINCT FROM statement, ensure that the value returned for the operator used for deduplication is of the Boolean type.

GAUSS-00092: "collation mismatch between implicit collations '%s' and '%s'"

SQLSTATE: 42P21

Description: Two character sets cannot be converted in implicit mode.

Solution: Ensure that two character sets to be converted are compatible.

Example:

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
postgres=# create table t1(a text collate "C");
NOTICE:  The 'DISTRIBUTE BY' clause is not specified. Using round-robin as the distribution mode by default.
HINT:  Please use 'DISTRIBUTE BY' clause to specify suitable data distribution column.
CREATE TABLE
postgres=# create table t2(a text collate "POSIX");
NOTICE:  The 'DISTRIBUTE BY' clause is not specified. Using round-robin as the distribution mode by default.
HINT:  Please use 'DISTRIBUTE BY' clause to specify suitable data distribution column.
CREATE TABLE
postgres=# select * from t1 union select * from t2;
ERROR:  collation mismatch between implicit collations "C" and "POSIX"
LINE 1: select * from t1 union select * from t2;

GAUSS-00093: "collation mismatch between explicit collations '%s' and '%s'"

SQLSTATE: 42P21

Description: Two character sets cannot be converted in explicit mode.

Solution: Ensure that two character sets to be converted are compatible.

Example:

1
2
3
postgres=# select * from t1 where a collate "C" > 'abc' collate "POSIX";
ERROR:  collation mismatch between explicit collations "C" and "POSIX"
LINE 1: select * from t1 where a collate "C" > 'abc' collate "POSIX"...

GAUSS-00094: "table reference '%s' is ambiguous"

SQLSTATE: 42P09

Description: Table reference is ambiguous because duplicate table names exist.

Solution: Provide a specific table name when referencing a table.

GAUSS-00095: "table reference %u is ambiguous"

SQLSTATE: 42P09

Description: Table reference is ambiguous because duplicate table names exist.

Solution: Provide a specific table name when referencing a table.

GAUSS-00096: "table name '%s' specified more than once"

SQLSTATE: 42712

Description: In the from statement, the same table is used multiple times without an alias.

Solution: In the from statement, specify an alias for the table so that the same table can be used multiple times.

GAUSS-00097: "RTE not found (internal error)"

SQLSTATE: XX000

Description: Internal system error.

Solution: Contact technical support.

GAUSS-00098: "bad levelsup for CTE '%s'"

SQLSTATE: XX000

Description: Internal system error.

Solution: Contact technical support.

GAUSS-00099: "could not find CTE '%s'"

SQLSTATE: XX000

Description: Internal system error.

Solution: Contact technical support.

GAUSS-00100: "could not find JoinExpr for whole-row reference"

SQLSTATE: XX000

Description: Internal system error.

Solution: Contact technical support.