Struct QueryClassification

Source

pub struct QueryClassification {Show 25 fields
    pub has_aggregation: bool,
    pub has_window_functions: bool,
    pub has_group_by: bool,
    pub has_order_by: bool,
    pub has_limit: bool,
    pub has_offset: bool,
    pub has_distinct: bool,
    pub has_distinct_on: bool,
    pub has_set_operations: bool,
    pub has_having: bool,
    pub is_select_star: bool,
    pub select_has_scalar_subqueries: bool,
    pub join_projection_dependencies: Option<Arc<Vec<Expression>>>,
    pub has_joins: bool,
    pub join_count: usize,
    pub has_outer_joins: bool,
    pub has_derived_tables: bool,
    pub reorderable_join_count: usize,
    pub has_where: bool,
    pub where_has_parameters: bool,
    pub where_has_subqueries: bool,
    pub where_has_correlated_subqueries: bool,
    pub has_nondeterministic_functions: bool,
    pub select_has_correlated_subqueries: bool,
    pub order_by_has_correlated_subqueries: bool,
    /* private fields */
}

Expand description

Pre-computed characteristics of a SELECT statement.

Fields§

§has_aggregation: bool

Whether the query has aggregate functions (COUNT, SUM, etc.)

§has_window_functions: bool

Whether the query has window functions (ROW_NUMBER, etc.)

§has_group_by: bool

Whether the query has GROUP BY clause

§has_order_by: bool

Whether the query has ORDER BY clause

§has_limit: bool

Whether the query has LIMIT clause

§has_offset: bool

Whether the query has OFFSET clause

§has_distinct: bool

Whether the query has DISTINCT

§has_distinct_on: bool

Whether the query has DISTINCT ON (expr, …)

§has_set_operations: bool

Whether the query has set operations (UNION, etc.)

§has_having: bool

Whether the query has HAVING clause

§is_select_star: bool

Whether the SELECT is * (all columns)

§select_has_scalar_subqueries: bool

Whether SELECT has scalar subqueries

§join_projection_dependencies: Option<Arc<Vec<Expression>>>

Current-scope column references required after the JOIN tree. None means that a star or nested query makes dependency projection unsafe.

§has_joins: bool

Whether the query has any joins

§join_count: usize

Number of JOIN edges in the complete table-expression tree.

§has_outer_joins: bool

Whether at least one JOIN edge is an outer-join reorder barrier.

§has_derived_tables: bool

Whether the table expression contains a derived/subquery boundary.

§reorderable_join_count: usize

INNER equality edges that may participate in a reorder component.

§has_where: bool

Whether query has a WHERE clause

§where_has_parameters: bool

Whether WHERE clause has parameters ($1, $2, etc.)

§where_has_subqueries: bool

Whether WHERE clause has any subqueries

§where_has_correlated_subqueries: bool

Whether WHERE has correlated subqueries (references outer columns)

§has_nondeterministic_functions: bool

Whether WHERE or SELECT has non-deterministic functions (NOW, RANDOM, UUID, etc.) that return different values per execution and must not be semantically cached

§select_has_correlated_subqueries: bool

Whether any SELECT column has correlated subqueries

§order_by_has_correlated_subqueries: bool

Whether ORDER BY has correlated subqueries