Method new

src/sql/src/plan/statement/show.rs:948–962

Constructs a new [`ShowSelect`] from a query that provides the base data and an optional user-supplied filter, order column, and projection on that data. Note that the query must return a column named `name`, as the filter may implicitly reference this column. Any `ORDER BY` in the query is ignored. `ShowSelects`s are always ordered in ascending order by all columns from left to right unless an o

(
        scx: &'a StatementContext,
        query: String,
        filter: Option<ShowStatementFilter<Aug>>,
        order: Option<&str>,
        projection: Option<&[&str]>,
    )

    /// ignored. `ShowSelects`s are always ordered in ascending order by all
    /// columns from left to right unless an order field is supplied.
    fn new(
        scx: &'a StatementContext,
        query: String,
        filter: Option<ShowStatementFilter<Aug>>,
        order: Option<&str>,
        projection: Option<&[&str]>,
    ) -> Result<ShowSelect<'a>, PlanError> {
        let (show_select, new_resolved_ids) =
            Self::new_with_resolved_ids(scx, query, filter, order, projection)?;
        scx.sql_impl_resolved_ids
            .lock()
            .expect("planning is single-threaded")
            .extend_from(&new_resolved_ids);
        Ok(show_select)
    }

    fn new_with_resolved_ids(
        scx: &'a StatementContext,