phpmyadmin/phpmyadmin

MySQL 8.0.11 spatial data type changes

オープン

#14,221 opened on 2018/04/21

 (0 件のコメント) (1 件のリアクション) (0 人の担当者)PHP (3,454 件のフォーク)batch import
help wanted

Repository metrics

Stars
 (6,886 個のスター)
PR merge metrics
 (平均マージ 2d 17h) (30d で 11 merged PRs)

説明

MySQL 8.0.11 made some changes to handling of some spatial data types.

  • The standard GeomCollection name for the geometry collection data type is supported as a synonym for the GeometryCollection data type name.
  • The GeomCollection() function is supported as a synonym for the GeometryCollection() function.
  • GeomCollection and GeomCollection() are the preferred data type and function names.

Incompatibility: As a consequence of the change in preferred data type name, some INFORMATION_SCHEMA tables, statements such as SHOW CREATE TABLE, and the ST_GeometryType() function that display data type information now display GEOMCOLLECTION rather than GEOMETRYCOLLECTION. Applications that look for GEOMETRYCOLLECTION should be adjusted to account for this change.

We should investigate whether these changes affect us at all.

コントリビューターガイド