Skip to content

Cannot insert/update spatial column in MariaDB #153

Open
@Persaeus

Description

@Persaeus

When trying to insert or update a spatial column when using MariaDB, the following exception is thrown:

Syntax error or access violation: 1582 Incorrect parameter count in the call to native function 'ST_GeomFromText'

This is because WKT spatial analysis functions, like ST_GeomFromText, in MariaDB do not accept the options parameter like they do in MySQL, and we hard-code the options parameter as "axis-order=long-lat"

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions