Enum ConnectByKind 

pub enum ConnectByKind {
    ConnectBy {
        connect_token: AttachedToken,
        nocycle: bool,
        relationships: Vec<Expr>,
    },
    StartWith {
        start_token: AttachedToken,
        condition: Box<Expr>,
    },
}

Joins a table to itself to process hierarchical data in the table.

See https://docs.snowflake.com/en/sql-reference/constructs/connect-by. See https://docs.oracle.com/en/database/oracle/oracle-database/21/sqlrf/Hierarchical-Queries.html

Variants

ConnectBy

CONNECT BY

Fields

connect_token: AttachedToken

the CONNECT token

nocycle: bool

[CONNECT BY] NOCYCLE

Optional on Oracle

relationships: Vec<Expr>

join conditions denoting the hierarchical relationship

StartWith

START WITH

Optional on Oracle when comming after the CONNECT BY.

Fields

start_token: AttachedToken

the START token

condition: Box<Expr>

condition selecting the root rows of the hierarchy

Trait Implementations

impl Clone for ConnectByKind

fn clone(&self) -> ConnectByKind

Returns a duplicate of the value.

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

Performs copy-assignment from source.

impl Debug for ConnectByKind

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

Formats the value using the given formatter.

impl Display for ConnectByKind

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

Formats the value using the given formatter.

impl Hash for ConnectByKind

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 ConnectByKind

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

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

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

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 Visit for ConnectByKind

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

Visit this node with the provided Visitor.

impl VisitMut for ConnectByKind

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

Mutably visit this node with the provided VisitorMut.

impl Eq for ConnectByKind

impl StructuralPartialEq for ConnectByKind