GAUSS-00241 -- GAUSS-00250
GAUSS-00241: “aggregates not allowed in JOIN conditions”
SQLSTATE: 42803
Description: The JOIN condition contains an aggregate function.
Solution: Do not use an aggregate function in the JOIN condition.
GAUSS-00242: “aggregates not allowed in GROUP BY clause”
SQLSTATE: 42803
Description: The GROUP BY clause contains an aggregate function.
Solution: Do not use an aggregate function in the GROUP BY clause.
GAUSS-00243: “aggregate functions not allowed in a recursive query's recursive term”
SQLSTATE: 42P19
Description: The recursive query uses an aggregate function.
Solution: Do not use an aggregate function in the recursive query.
GAUSS-00244: “window functions not allowed in WHERE clause”
SQLSTATE: 42P20
Description: The WHERE clause contains a window function.
Solution: Do not use a window function in the WHERE clause.
GAUSS-00245: “window functions not allowed in JOIN conditions”
SQLSTATE: 42P20
Description: The JOIN condition contains a window function.
Solution: Do not use a window function in the JOIN condition.
GAUSS-00246: “window functions not allowed in HAVING clause”
SQLSTATE: 42P20
Description: Syntax not supported.
Solution: Modify the SQL statement.
GAUSS-00247: “window functions not allowed in GROUP BY clause”
SQLSTATE: 42P20
Description: The GROUP BY clause contains a window function.
Solution: Do not use a window function in the GROUP BY clause.
GAUSS-00248: “window functions not allowed in window definition”
SQLSTATE: 42P20
Description: The PARTITION or ORDER BY clause contains a window function.
Solution: Do not use a window function in the PARTITION or ORDER BY clause.
GAUSS-00249: “column '%s.%s' must appear in the GROUP BY clause or be used in an aggregate function”
SQLSTATE: 42803
Description: The GROUP BY clause contains an aggregate function or lacks variables existing in the target list.
Solution: Do not use an aggregate function in the GROUP BY clause or include variables existing in the target list.
GAUSS-00250: “subquery uses ungrouped column '%s.%s' from outer query”
SQLSTATE: 42803
Description: The subquery uses an external ungrouped column.
Solution: Ensure that the subquery uses an external grouped column.