#79990Database migration: spatial column POINT NOT NULL not detected correctly
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.