Enum Set 

pub enum Set {
    SingleAssignment {
        scope: Option<ContextModifier>,
        hivevar: bool,
        variable: ObjectName,
        values: Vec<Expr>,
    },
    ParenthesizedAssignments {
        variables: Vec<ObjectName>,
        values: Vec<Expr>,
    },
    MultipleAssignments {
        assignments: Vec<SetAssignment>,
    },
    SetSessionAuthorization(SetSessionAuthorizationParam),
    SetSessionParam(SetSessionParamKind),
    SetRole {
        context_modifier: Option<ContextModifier>,
        role_name: Option<Ident>,
    },
    SetTimeZone {
        local: bool,
        value: Expr,
    },
    SetNames {
        charset_name: Ident,
        collation_name: Option<String>,
    },
    SetNamesDefault {},
    SetTransaction {
        modes: Vec<TransactionMode>,
        snapshot: Option<Value>,
        session: bool,
    },
}

Variants for the SET family of statements.

Variants

SingleAssignment

SQL Standard-style SET a = 1; SET var = value (standard SQL-style assignment).

Fields

scope: Option<ContextModifier>

Optional scope modifier (SESSION / LOCAL).

hivevar: bool

Whether this is a Hive-style HIVEVAR: assignment.

variable: ObjectName

Variable name to assign.

values: Vec<Expr>

Values assigned to the variable.

ParenthesizedAssignments

Snowflake-style SET (a, b, ..) = (1, 2, ..); SET (a, b) = (1, 2) (tuple assignment syntax).

Fields

variables: Vec<ObjectName>

Variables being assigned in tuple form.

values: Vec<Expr>

Corresponding values for the variables.

MultipleAssignments

MySQL-style SET a = 1, b = 2, ..; SET a = 1, b = 2 (MySQL-style comma-separated assignments).

Fields

assignments: Vec<SetAssignment>

List of SET assignments (MySQL-style comma-separated).

SetSessionAuthorization(SetSessionAuthorizationParam)

Session authorization for Postgres/Redshift

SET SESSION AUTHORIZATION { user_name | DEFAULT }

See https://www.postgresql.org/docs/current/sql-set-session-authorization.html See https://docs.aws.amazon.com/redshift/latest/dg/r_SET_SESSION_AUTHORIZATION.html

SetSessionParam(SetSessionParamKind)

MS-SQL session

See https://learn.microsoft.com/en-us/sql/t-sql/statements/set-statements-transact-sql

SetRole

SET [ SESSION | LOCAL ] ROLE role_name

Sets session state. Examples: ANSI, Postgresql, MySQL, and Oracle

Fields

context_modifier: Option<ContextModifier>

Non-ANSI optional identifier to inform if the role is defined inside the current session (SESSION) or transaction (LOCAL).

role_name: Option<Ident>

Role name. If NONE is specified, then the current role name is removed.

SetTimeZone

SET TIME ZONE <value>

Note: this is a PostgreSQL-specific statements SET TIME ZONE <value> is an alias for SET timezone TO <value> in PostgreSQL However, we allow it for all dialects. SET TIME ZONE statement. local indicates the LOCAL keyword. SET TIME ZONE <value> statement.

Fields

local: bool

Whether the LOCAL keyword was specified.

value: Expr

Time zone expression value.

SetNames

SET NAMES 'charset_name' [COLLATE 'collation_name']

Fields

charset_name: Ident

Character set name to set.

collation_name: Option<String>

Optional collation name.

SetNamesDefault

SET NAMES DEFAULT

Note: this is a MySQL-specific statement.

SetTransaction

SET TRANSACTION ...

Fields

modes: Vec<TransactionMode>

Transaction modes (e.g., ISOLATION LEVEL, READ ONLY).

snapshot: Option<Value>

Optional snapshot value for transaction snapshot control.

session: bool

true when the SESSION keyword was used.

Trait Implementations

impl Clone for Set

fn clone(&self) -> Set

Returns a duplicate of the value.

fn clone_from(&mut self, source: &Self)

Performs copy-assignment from source.

impl Debug for Set

fn fmt(&self, f: &mut Formatter<'_>) -> Result

Formats the value using the given formatter.

impl Display for Set

fn fmt(&self, f: &mut Formatter<'_>) -> Result

Formats the value using the given formatter.

impl From<Set> for Statement

fn from(s: Set) -> Self

Converts to this type from the input type.

impl Hash for Set

fn hash<__H: Hasher>(&self, state: &mut __H)

Feeds this value into the given Hasher.

fn hash_slice<H>(data: &[Self], state: &mut H)

where H: Hasher, Self: Sized,

Feeds a slice of this type into the given Hasher.

impl Ord for Set

fn cmp(&self, other: &Set) -> Ordering

This method returns an Ordering between self and other.

fn max(self, other: Self) -> Self

where Self: Sized,

Compares and returns the maximum of two values.

fn min(self, other: Self) -> Self

where Self: Sized,

Compares and returns the minimum of two values.

fn clamp(self, min: Self, max: Self) -> Self

where Self: Sized,

Restrict a value to a certain interval.

impl PartialEq for Set

fn eq(&self, other: &Set) -> bool

Tests for self and other values to be equal, and is used by ==.

fn ne(&self, other: &Rhs) -> bool

Tests for !=. The default implementation is almost always sufficient, and should not be overridden without very good reason.

impl PartialOrd for Set

fn partial_cmp(&self, other: &Set) -> Option<Ordering>

This method returns an ordering between self and other values if one exists.

fn lt(&self, other: &Rhs) -> bool

Tests less than (for self and other) and is used by the < operator.

fn le(&self, other: &Rhs) -> bool

Tests less than or equal to (for self and other) and is used by the <= operator.

fn gt(&self, other: &Rhs) -> bool

Tests greater than (for self and other) and is used by the > operator.

fn ge(&self, other: &Rhs) -> bool

Tests greater than or equal to (for self and other) and is used by the >= operator.

impl Visit for Set

fn visit<V: Visitor>(&self, visitor: &mut V) -> ControlFlow<V::Break>

Visit this node with the provided Visitor.

impl VisitMut for Set

fn visit<V: VisitorMut>(&mut self, visitor: &mut V) -> ControlFlow<V::Break>

Mutably visit this node with the provided VisitorMut.

impl Eq for Set

impl StructuralPartialEq for Set