UNSUPPORTED_SUBQUERY_EXPRESSION_CATEGORY error class
Unsupported subquery expression:
ACCESSING_OUTER_QUERY_COLUMN_IS_NOT_ALLOWED
Accessing outer query column is not allowed in this location:
<treeNode>
AGGREGATE_FUNCTION_MIXED_OUTER_LOCAL_REFERENCES
Found an aggregate function in a correlated predicate that has both outer and local references, which is not supported: <function>
.
CORRELATED_COLUMN_IS_NOT_ALLOWED_IN_NON_EQUALITY_PREDICATE
Correlated column is not allowed in a non-equality predicate:
<treeNode>
CORRELATED_COLUMN_IS_NOT_ALLOWED_IN_PREDICATE
Correlated column is not allowed in predicate:
<treeNode>
CORRELATED_COLUMN_NOT_FOUND
A correlated outer name reference within a subquery expression body was not found in the enclosing query: <value>
.
CORRELATED_REFERENCE
Expressions referencing the outer query are not supported outside of WHERE/HAVING clauses: <sqlExprs>
.
HIGHER_ORDER_FUNCTION
Subquery expressions are not supported within higher-order functions. Please remove all subquery expressions from higher-order functions and then try the query again.
LATERAL_JOIN_CONDITION_NON_DETERMINISTIC
Lateral join condition cannot be non-deterministic: <condition>
.
MUST_AGGREGATE_CORRELATED_SCALAR_SUBQUERY
Correlated scalar subqueries must be aggregated to return at most one row.
NON_CORRELATED_COLUMNS_IN_GROUP_BY
A GROUP BY clause in a scalar correlated subquery cannot contain non-correlated columns: <value>
.
NON_DETERMINISTIC_LATERAL_SUBQUERIES
Non-deterministic lateral subqueries are not supported when joining with outer relations that produce more than one row:
<treeNode>
UNSUPPORTED_CORRELATED_REFERENCE_DATA_TYPE
Correlated column reference ‘<expr>
’ cannot be <dataType>
type.
UNSUPPORTED_CORRELATED_SCALAR_SUBQUERY
Correlated scalar subqueries can only be used in filters, aggregations, projections, and UPDATE/MERGE/DELETE commands:
<treeNode>
UNSUPPORTED_CORRELATED_SCALAR_SUBQUERY_IN_WINDOW
Correlated scalar subqueries cannot be used in the same clause as window operators:
<treeNode>
UNSUPPORTED_IN_EXISTS_SUBQUERY
IN/EXISTS predicate subqueries can only be used in filters, joins, aggregations, window functions, projections, and UPDATE/MERGE/DELETE commands:
<treeNode>
UNSUPPORTED_TABLE_ARGUMENT
Table arguments are used in a function where they are not supported:
<treeNode>
Σχόλια
https://aka.ms/ContentUserFeedback.
Σύντομα διαθέσιμα: Καθ' όλη τη διάρκεια του 2024 θα καταργήσουμε σταδιακά τα ζητήματα GitHub ως μηχανισμό ανάδρασης για το περιεχόμενο και θα το αντικαταστήσουμε με ένα νέο σύστημα ανάδρασης. Για περισσότερες πληροφορίες, ανατρέξτε στο θέμα:Υποβολή και προβολή σχολίων για