grimzy/laravel-mysql-spatial

Syntax error with Laravel 8, MariaDB 10.6 and SRID

kakojak opened this issue · 2 comments

I wanna switch from MySQL 8.0 to MariaDB 10.6 but its not possible with version 4 of laravel-mysql-spatial.

Migration:
$table->point('coordinates',4326)->nullable();
$table->multiPolygon('boundaries',4326)->nullable();

Not possible with MariaDB -> error:
SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '4326, boundaries MULTIPOLYGON null srid 4326' at line 1

With MySQL 8.0 it works fine.

MariaDB doesnt support creating a column with an SRID i think

Any fix for this issue?