Enum Value 

#[non_exhaustive]
pub enum Value {
    Null,
    Boolean(bool),
    TinyInt(i8),
    SmallInt(i16),
    Integer(i32),
    BigInt(i64),
    HugeInt(i128),
    UTinyInt(u8),
    USmallInt(u16),
    UInteger(u32),
    UBigInt(u64),
    UHugeInt(u128),
    Float(f32),
    Double(f64),
    Decimal {
        unscaled: i128,
        width: u8,
        scale: u8,
    },
    Varchar(String),
    Blob(Vec<u8>),
    Date(i32),
    Time(i64),
    Timestamp(i64),
    Interval {
        months: i32,
        days: i32,
        micros: i64,
    },
    List {
        element: LogicalType,
        values: Vec<Value>,
    },
    Struct(Vec<(String, Value)>),
}

A single SQL value.

PartialEq here is Rust equality and not SQL equality. Two nulls compare equal and two NaNs compare equal, both of which SQL disagrees with. That is the right behaviour for a test assertion and the wrong behaviour for a WHERE clause, and the WHERE clause gets its comparison from the kernels rather than from here.

Variants (Non-exhaustive)

Non-exhaustive enums could have additional variants added in future. Therefore, when matching against variants of non-exhaustive enums, an extra wildcard arm must be added to account for any future variants.

Null

NULL, of no particular type.

Boolean(bool)

BOOLEAN.

TinyInt(i8)

TINYINT.

SmallInt(i16)

SMALLINT.

Integer(i32)

INTEGER.

BigInt(i64)

BIGINT.

HugeInt(i128)

HUGEINT.

UTinyInt(u8)

UTINYINT.

USmallInt(u16)

USMALLINT.

UInteger(u32)

UINTEGER.

UBigInt(u64)

UBIGINT.

UHugeInt(u128)

UHUGEINT.

Float(f32)

FLOAT.

Double(f64)

DOUBLE.

Decimal

DECIMAL(width, scale), carrying the unscaled integer.

Fields

unscaled: i128

The unscaled value, so 12.34 at scale 2 is 1234.

width: u8

Total digits.

scale: u8

Digits right of the point.

Varchar(String)

VARCHAR.

Blob(Vec<u8>)

BLOB.

Date(i32)

DATE, days since 1970-01-01.

Time(i64)

TIME, microseconds since midnight.

Timestamp(i64)

TIMESTAMP, microseconds since 1970-01-01 00:00:00.

Interval

INTERVAL, the months, days and microseconds triple.

Three fields rather than one duration because interval arithmetic with months is not associative with days, and DuckDB’s specific behaviour is what tests assert on. A month is not 30 days and this representation is what refuses to pretend otherwise.

Fields

months: i32

Whole months.

days: i32

Whole days.

micros: i64

Microseconds.

List

A list, carrying its element type so that an empty list still knows what it is empty of.

Fields

element: LogicalType

The element type.

values: Vec<Value>

The elements.

Struct(Vec<(String, Value)>)

A struct, in field order.

Implementations

impl Value

pub fn is_null(&self) -> bool

Whether this is NULL.

pub fn logical_type(&self) -> LogicalType

The type of this value.

pub fn as_i64(&self) -> Option<i64>

The value as an i64, for the integer types that fit in one.

Used by the planner for the places where a literal has to be a small integer, LIMIT and OFFSET being the obvious ones. Returns None rather than saturating, because a LIMIT that silently became i64::MAX is worse than an error.

pub fn as_bool(&self) -> Option<bool>

The value as a bool, for a BOOLEAN and nothing else.

pub fn as_str(&self) -> Option<&str>

The value as a string slice, for a VARCHAR and nothing else.

Trait Implementations

impl Clone for Value

fn clone(&self) -> Value

Returns a duplicate of the value.

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

Performs copy-assignment from source.

impl Debug for Value

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

Formats the value using the given formatter.

impl Display for Value

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

Formats the value using the given formatter.

impl PartialEq for Value

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

Equality operator ==.

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

Inequality operator !=.

impl StructuralPartialEq for Value