Skip to content

Sequences aren't supported as a default value for mariadb #16

@far-blue

Description

@far-blue

When a sequence is used as the default value for a column, the NEXT VALUE FOR <sequence name> or nextval(<sequence name) string is used as a literal default value.

The correct behaviour would be to exclude the field from the insert if it is empty so to trigger the default value behaviour in the db.

A less correct but still acceptable behaviour would be to use the value as a raw value without quoting so the db executes the statement and correctly inserts the next sequence value.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions