Project

General

Profile

Actions
Copy link

Bug #79990

closed

Database migration: spatial column POINT NOT NULL not detected correctly

Added by Christian Weiske over 7 years ago. Updated almost 4 years ago.

Status:
Closed
Priority:
Should have
Assignee:
-
Category:
Database API (Doctrine DBAL)
Target version:
-
Start date:
2017-02-24
Due date:
% Done:

0%

Estimated time:
TYPO3 Version:
7
PHP Version:
Tags:
Complexity:
Is Regression:
No
Sprint Focus:

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
Actions
Copy link

Also available in: Atom PDF