Syntax error with Laravel 8, MariaDB 10.6 and SRID
kakojak opened this issue · 2 comments
kakojak commented
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.
H-ishak commented
MariaDB doesnt support creating a column with an SRID i think
B2rana commented
Any fix for this issue?