List:General Discussion« Previous MessageNext Message »
From:Laurynas Biveinis Date:April 24 2013 9:18pm
Subject:Re: Spatial changes in InnoDB - Details?
View as plain text  
> The "What's new in MySQL 5.7" manual page [1] says:
>
>   *  InnoDB now supports spatial data types.
>
> What is the difference to previous releases in this respect?

The 5.7.1 Release Notes are a bit more specific:
https://dev.mysql.com/doc/relnotes/mysql/5.7/en/news-5-7-1.html

InnoDB: Added support for spatial data types currently supported by
MySQL including POINT, LINE_STRING, POLYGON, MULTI_POINT,
MULTI_POLYGON, MULTI_LINE_STRING, GEOMETRY_COLLECTION, and GEOMETRY.

Prior to this release, InnoDB would store spatial data as binary BLOB
data. BLOB remains the underlying data type but spatial data types are
now mapped to a new InnoDB internal data type, DATA_GEOMETRY. With
BLOB as the underlying data type, a prefix index can still be used on
the GEOMETRY data column.
Thread
Spatial changes in InnoDB - Details?Hartmut Holzgraefe24 Apr
  • Re: Spatial changes in InnoDB - Details?Laurynas Biveinis24 Apr