Enum JoinOperator 

pub enum JoinOperator {
    Join(JoinConstraint),
    Inner(JoinConstraint),
    Left(JoinConstraint),
    LeftOuter(JoinConstraint),
    Right(JoinConstraint),
    RightOuter(JoinConstraint),
    FullOuter(JoinConstraint),
    CrossJoin(JoinConstraint),
    Semi(JoinConstraint),
    LeftSemi(JoinConstraint),
    RightSemi(JoinConstraint),
    Anti(JoinConstraint),
    LeftAnti(JoinConstraint),
    RightAnti(JoinConstraint),
    CrossApply,
    OuterApply,
    AsOf {
        match_condition: Expr,
        constraint: JoinConstraint,
    },
    StraightJoin(JoinConstraint),
    ArrayJoin,
    LeftArrayJoin,
    InnerArrayJoin,
}

The operator used for joining two tables, e.g. INNER, LEFT, CROSS, ASOF, etc.

Variants

Join(JoinConstraint)

Generic JOIN with an optional constraint.

Inner(JoinConstraint)

INNER JOIN with an optional constraint.

Left(JoinConstraint)

LEFT JOIN with an optional constraint.

LeftOuter(JoinConstraint)

LEFT OUTER JOIN with an optional constraint.

Right(JoinConstraint)

RIGHT JOIN with an optional constraint.

RightOuter(JoinConstraint)

RIGHT OUTER JOIN with an optional constraint.

FullOuter(JoinConstraint)

FULL OUTER JOIN with an optional constraint.

CrossJoin(JoinConstraint)

CROSS JOIN (constraint usage is non-standard).

Semi(JoinConstraint)

SEMI JOIN (non-standard)

LeftSemi(JoinConstraint)

LEFT SEMI JOIN (non-standard)

RightSemi(JoinConstraint)

RIGHT SEMI JOIN (non-standard)

Anti(JoinConstraint)

ANTI JOIN (non-standard)

LeftAnti(JoinConstraint)

LEFT ANTI JOIN (non-standard)

RightAnti(JoinConstraint)

RIGHT ANTI JOIN (non-standard)

CrossApply

CROSS APPLY (non-standard)

OuterApply

OUTER APPLY (non-standard)

AsOf

ASOF joins are used for joining time-series tables whose timestamp columns do not match exactly.

See https://docs.snowflake.com/en/sql-reference/constructs/asof-join.

Fields

match_condition: Expr

Condition used to match records in the ASOF join.

constraint: JoinConstraint

Additional constraint applied to the ASOF join.

StraightJoin(JoinConstraint)

STRAIGHT_JOIN (MySQL non-standard behavior)

See https://dev.mysql.com/doc/refman/8.4/en/join.html.

ArrayJoin

ClickHouse: ARRAY JOIN for unnesting arrays inline.

See https://clickhouse.com/docs/en/sql-reference/statements/select/array-join.

LeftArrayJoin

ClickHouse: LEFT ARRAY JOIN for unnesting arrays inline (preserves rows with empty arrays).

InnerArrayJoin

ClickHouse: INNER ARRAY JOIN for unnesting arrays inline (filters rows with empty arrays).

Trait Implementations

impl Clone for JoinOperator

fn clone(&self) -> JoinOperator

Returns a duplicate of the value.

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

Performs copy-assignment from source.

impl Debug for JoinOperator

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

Formats the value using the given formatter.

impl Eq for JoinOperator

impl Hash for JoinOperator

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

where __H: Hasher,

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 JoinOperator

fn cmp(&self, other: &JoinOperator) -> 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 JoinOperator

fn eq(&self, other: &JoinOperator) -> 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 JoinOperator

fn partial_cmp(&self, other: &JoinOperator) -> 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 Spanned for JoinOperator

partial span

Missing spans:

• JoinOperator::CrossJoin
• JoinOperator::CrossApply
• JoinOperator::OuterApply

fn span(&self) -> Span

Return the Span (the minimum and maximum Location) for this AST node, by recursively combining the spans of its children.

impl StructuralPartialEq for JoinOperator

impl Visit for JoinOperator

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

where V: Visitor,

Visit this node with the provided Visitor.

impl VisitMut for JoinOperator

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

where V: VisitorMut,

Mutably visit this node with the provided VisitorMut.