#1138 - Invalid use of NULL value

[kentasaito]

Hi.

I'm using PHP MySQL Diff 1.2.1 (installed from composer). I give the command these two schemas.

from.schema

CREATE TABLE post ( post_date date NOT NULL COMMENT 'Created At' );

to.schema

CREATE TABLE post ( post_date date NOT NULL COMMENT 'Created' );

It returns:

ALTER TABLE post CHANGE COLUMN post_date post_date date NOT NULL COMMENT 'Created' FIRST;

but MySQL(Server version: 5.7.17) says:

#1138 - Invalid use of NULL value

Without 'FIRST', it worked.

ALTER TABLE post CHANGE COLUMN post_date post_date date NOT NULL COMMENT 'Created';