Skip to content

Make third wkt-parametr (axis-order=long-lat) optional for MariaDB compatibility #50

Closed
@Surzhikov

Description

@Surzhikov

Unlike MySQL, the WKT-input spatial analysis functions in MariaDB (like ST_GeomFromText and ST_DISTANCE) do not take an options parameter: https://mariadb.com/kb/en/st_geomfromtext/

For this reason, we should get an SQL error, while saving the model with spatial fields:
SQLSTATE[42000]: Syntax error or access violation: 1582 Incorrect parameter count in the call to native function 'ST_GeomFromText'

A similar issue was in grimzy/laravel-mysql-spatial and it was fixed by pull request grimzy/laravel-mysql-spatial#152

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