Enum SqlMode 

pub enum SqlMode {
    MySQL {
        flags: MySqlModeFlags,
    },
    SQLite,
}

SQL compatibility mode

VibeSQL supports different SQL dialect modes to match the behavior of different database systems. This is necessary because SQL standards allow implementation-defined behavior in certain areas.

Differences by Mode

See SQL_COMPATIBILITY_MODE.md in the repository root for a comprehensive list of behavioral differences between modes.

Division Operator (/)

• MySQL: INTEGER / INTEGER → DECIMAL (floating-point division)
  • Example: 83 / 6 = 13.8333
• SQLite: INTEGER / INTEGER → INTEGER (truncated division)
  • Example: 83 / 6 = 13

Default Mode

MySQL mode is the default to maximize compatibility with the dolthub/sqllogictest test suite, which was generated from MySQL 8.

Variants

MySQL

MySQL 8.0+ compatibility mode (default)

• Division returns DECIMAL (floating-point)
• Other MySQL-specific behaviors controlled by flags

Fields

flags: MySqlModeFlags

SQLite

SQLite 3 compatibility mode

• Division returns INTEGER (truncated)
• Other SQLite-specific behaviors

Note: Currently not fully implemented. Many features will error with “TODO: SQLite mode not yet supported” messages.

Implementations

impl SqlMode

pub fn mysql_flags(&self) -> Option<&MySqlModeFlags>

Get the MySQL mode flags, if in MySQL mode

Trait Implementations

impl Clone for SqlMode

fn clone(&self) -> SqlMode

Returns a duplicate of the value.

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

Performs copy-assignment from source.

impl Debug for SqlMode

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

Formats the value using the given formatter.

impl Default for SqlMode

fn default() -> Self

Returns the “default value” for a type.

impl Display for SqlMode

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

Formats the value using the given formatter.

impl FromStr for SqlMode

type Err = String

The associated error which can be returned from parsing.

fn from_str(s: &str) -> Result<Self, Self::Err>

Parses a string s to return a value of this type.

impl Hash for SqlMode

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 OperatorBehavior for SqlMode

fn integer_division_behavior(&self) -> DivisionBehavior

Division behavior for integer/integer operands

fn supports_xor(&self) -> bool

Whether this mode supports the XOR operator

fn supports_integer_div_operator(&self) -> bool

Whether this mode supports the DIV operator (integer division)

fn string_concat_operator(&self) -> ConcatOperator

String concatenation operator preference

impl PartialEq for SqlMode

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

fn has_decimal_type(&self) -> bool

Whether this mode has a distinct DECIMAL/NUMERIC type

fn uses_dynamic_typing(&self) -> bool

Whether this mode uses dynamic typing (type affinity)

fn division_result_type(&self, left: &SqlValue, right: &SqlValue) -> ValueType

Get the result type for division operation

fn permissive_type_coercion(&self) -> bool

Whether implicit type coercion is permissive

impl Eq for SqlMode

impl StructuralPartialEq for SqlMode