Enum JoinKind 

pub enum JoinKind {
    Inner,
    Left,
    Right,
    Full,
    Semi,
    Anti,
    Single,
    Positional,
}

Which join.

Semi and Anti are here because subquery unnesting produces them directly, per section 9.2, and a semi join expressed as a join plus a distinct is a semi join the executor cannot recognise.

Variants

Inner

Rows that match on both sides.

Left

Every left row, padded with nulls where the right does not match.

Right

Every right row, padded with nulls where the left does not match.

Full

Both of the above at once.

Semi

Left rows that have at least one match, each emitted once.

Anti

Left rows that have no match.

Single

Left rows paired with their match, or with nulls, at most one right row each. What a correlated scalar subquery unnests to.

Positional

The nth left row with the nth right row, which is DuckDB’s POSITIONAL JOIN.

Implementations

impl JoinKind

pub fn keyword(self) -> &'static str

The spelling used in the textual form.

Trait Implementations

impl Clone for JoinKind

fn clone(&self) -> JoinKind

Returns a duplicate of the value.

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

Performs copy-assignment from source.

impl Copy for JoinKind

impl Debug for JoinKind

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

Formats the value using the given formatter.

impl Eq for JoinKind

impl Hash for JoinKind

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 PartialEq for JoinKind

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

Equality operator ==.

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

Inequality operator !=.

impl StructuralPartialEq for JoinKind