Struct MySqlModeFlags 

pub struct MySqlModeFlags {
    pub pipes_as_concat: bool,
    pub ansi_quotes: bool,
    pub strict_mode: bool,
    pub sqlite_division_semantics: bool,
}

MySQL-specific mode flags (similar to MySQL’s sql_mode variable)

These flags control various MySQL-specific behaviors that differ from standard SQL or other database implementations.

References

• MySQL 8.0 sql_mode Documentation

Fields

pipes_as_concat: bool

Whether || acts as string concat (vs OR operator)

Corresponds to MySQL PIPES_AS_CONCAT mode.

• true: 'a' || 'b' returns 'ab' (string concatenation)
• false (default): 'a' || 'b' returns 1 or 0 (logical OR)

ansi_quotes: bool

Whether “ acts as identifier quote (vs string literal)

Corresponds to MySQL ANSI_QUOTES mode.

• true: "col" is an identifier (like backticks)
• false (default): "col" is a string literal (like single quotes)

strict_mode: bool

Strict mode for type coercion and errors

Corresponds to MySQL STRICT_TRANS_TABLES.

• true: Strict type checking, errors on invalid data
• false (default): Permissive mode with warnings

sqlite_division_semantics: bool

Use SQLite division semantics (INTEGER / INTEGER → INTEGER)

This flag is used when MySQL syntax is needed (e.g., CAST...AS SIGNED) but SQLite division semantics are required for compatibility with test suites that were generated using SQLite.

• true: 5 / 2 = 2 (truncated integer division, SQLite behavior)
• false (default): 5 / 2 = 2.5 (exact decimal division, MySQL behavior)

This is particularly useful for SQLLogicTest compatibility where tests are tagged onlyif mysql for syntax reasons but expect SQLite division results.

Implementations

impl MySqlModeFlags

pub fn new() -> Self

Create MySqlModeFlags with all default settings

pub fn with_pipes_as_concat() -> Self

Create MySqlModeFlags with PIPES_AS_CONCAT enabled

pub fn with_ansi_quotes() -> Self

Create MySqlModeFlags with ANSI_QUOTES enabled

pub fn with_strict_mode() -> Self

Create MySqlModeFlags with STRICT_MODE enabled

pub fn ansi() -> Self

Create MySqlModeFlags with ANSI mode (combination of ANSI_QUOTES and PIPES_AS_CONCAT)

pub fn with_sqlite_division_semantics() -> Self

Create MySqlModeFlags with SQLite division semantics enabled

This is useful for SQLLogicTest compatibility where MySQL syntax is needed but division should behave like SQLite (INTEGER / INTEGER → INTEGER).

Trait Implementations

impl Clone for MySqlModeFlags

fn clone(&self) -> MySqlModeFlags

Returns a duplicate of the value.

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

Performs copy-assignment from source.

impl Debug for MySqlModeFlags

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

Formats the value using the given formatter.

impl Default for MySqlModeFlags

fn default() -> MySqlModeFlags

Returns the “default value” for a type.

impl Hash for MySqlModeFlags

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 MySqlModeFlags

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

impl StructuralPartialEq for MySqlModeFlags