SelectModifiers in sqlparser::ast

SelectModifiers in sqlparser::ast - Rust

Struct SelectModifiers

pub struct SelectModifiers {
    pub high_priority: bool,
    pub straight_join: bool,
    pub sql_small_result: bool,
    pub sql_big_result: bool,
    pub sql_buffer_result: bool,
    pub sql_no_cache: bool,
    pub sql_calc_found_rows: bool,
}

Expand description

MySQL-specific SELECT modifiers that appear after the SELECT keyword.

These modifiers affect query execution and optimization. They can appear in any order after SELECT and before the column list, can be repeated, and can be interleaved with DISTINCT/DISTINCTROW/ALL:

SELECT
    [ALL | DISTINCT | DISTINCTROW]
    [HIGH_PRIORITY]
    [STRAIGHT_JOIN]
    [SQL_SMALL_RESULT] [SQL_BIG_RESULT] [SQL_BUFFER_RESULT]
    [SQL_NO_CACHE] [SQL_CALC_FOUND_ROWS]
    select_expr [, select_expr] ...

See MySQL SELECT.