• Jan Lindström's avatar
    MDEV-8392: Couldn't alter field with default value for make it not nullable. · 1a8cf15d
    Jan Lindström authored
    Analysis; Problem is that InnoDB does not have support for generating
    CURRENT_TIMESTAMP or constant default.
    
    Fix: Add additional check if column has changed from NULL -> NOT NULL
    and column default has changed. If this is is first column definition
    whose SQL type is TIMESTAMP and it is defined as NOT NULL and
    it has either constant default or function default we must use
    "Copy" method for alter table.
    1a8cf15d
innodb-alter-timestamp.test 648 Bytes