Skip to content

alter statement due to quotet default numbers  #66

@glanzel

Description

@glanzel

Thanks for your good work.
Everything works fine for me.

I only want to notice that different sql databases version (an even different versions of maria db)
sometimes write the default value with quotes and sometimes not which leads to an alter statement even if everything is equal.

this happens if you compare a mariadb 10.1 and a mariadb 10.2 server for example.

you can reproduce this when you type
SHOW CREATE TABLE test;
when 'test' is created like this for example:

CREATE TABLE `test` (
  `tinyint` tinyint(1) NOT NULL DEFAULT 0,
  `int` int(11) NOT NULL DEFAULT 0
); 

greeting grischan

Metadata

Metadata

Assignees

No one assigned

    Labels

    bugfixedFixed but not yet released

    Type

    No type
    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions