MySQLdialect postCreate enhancements

Description

In postCreateTable(...) the insert SQL statement used for inserting entries in the geometry_columns tables (which maintains metadata information about spatial columns in other tables) does not include the column names. This may result in a failure of INSERT when the table geometry_columns has been create manually in the DB and contains extra columns for example a autogenerated PK.

In encodePostColumnCreateTable() method GeometryDescriptor is checked for a a Nillable constrain and if not Nillable is specified the a 'NOT NULL' is appended in the create SQL statement that is build. However the code should 1st check that indeed 'NOT NULL' is not already present.

Environment

None

Status

Assignee

Unassigned

Reporter

Nkolaos Pringouris

Triage

None

Components

Fix versions

Priority

Medium
Configure