Issue Bug Closed

#79990Database migration: spatial column POINT NOT NULL not detected correctly

Christian Weiske 02/24/17, 10:49 updated 01/22/21, 09:28

Description

I’m trying to add a non-null POINT column to a database table. ext_tables.sql contains:

coordinates point NOT NULL,

The install tool database analyzer adds this field but then shows it again:

Change fields
 ALTER TABLE tx_ybpn_branches CHANGE coordinates coordinates point NOT NULL; 
Current value: point NOT NULL default NULL

The NOT NULL DEFAULT NULL is invalid here. In at least MySQL 5.7, spatial columns cannot have a default value:

BLOB, TEXT, GEOMETRY or JSON column 'coordinates' can't have a default value

Reviews 0

No change resolves or names this issue in its commit message, and no comment links one.