Details
-
Task
-
Status: Open (View Workflow)
-
Minor
-
Resolution: Unresolved
-
None
-
None
Description
I'm trying to create a partitioned table for GPS device data. Like this example.
CREATE TABLE data (
|
deviceId BIGINT UNSIGNED NOT NULL,
|
createdAt DATETIME NOT NULL,
|
location POINT NOT NULL,
|
PRIMARY KEY (deviceId, createdAt),
|
SPATIAL KEY (location)
|
)Engine=InnoDB PARTITION BY HASH ( deviceId ) PARTITIONS 1024; |
But MariaDB server returning an error message
[42000][1178] (conn=30) The storage engine for the table doesn't support GEOMETRY
|
I googled and found this (https://bugs.mysql.com/bug.php?id=60298). This issue is filed more than 10 years ago. Still has no resolution. I think MariaDB has the same problem because it is forked from MySQL. Maybe this can be fixed on the MariaDB side?