Function mz_sqllogictest::runner::generate_view_sql

source ·
fn generate_view_sql(
    sql: &str,
    view_uuid: &Simple,
    num_attributes: Option<usize>,
    expected_column_names: Option<Vec<ColumnName>>
) -> (String, String, String, String)
Expand description

Generates view creation, view indexing, view querying, and view dropping SQL commands for a given SELECT query. If the number of attributes produced by the query is known, the view commands are specialized to avoid issues with column ambiguity. This function is a helper for --auto_index_selects and assumes that the provided input SQL has already been run through the parser, resulting in a valid SELECT statement.