Skip to content

#1138 - Invalid use of NULL value #27

Open
@kentasaito

Description

@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';

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions