not null 转换后变为not null default null 报错 Invalid default value

iverycd / OracleSync2MySQL

Oracle to MySQL, PolarDB, Percona Server MySQL, MariaDB, OceanBase, TiDB, GaussDB for MySQL

MIT License

43 stars 16 forks source link

not null 转换后变为not null default null 报错 Invalid default value #25

Open donglinqing opened 1 month ago

donglinqing commented 1 month ago

转换前：ORDER NUMBER(10) not null, 转换后：`ORDER` int not null default null, 报错 -- ErrorInfo {"Number":1067,"SQLState":[52,50,48,48,48],"Message":"Invalid default value for 'ORDER_'"}

donglinqing commented 1 month ago

oracle 实际表结构"ORDER_" NUMBER(10,0) DEFAULT NULL NOT NULL ENABLE,

donglinqing commented 1 month ago

oracle 实际表结构"ORDER_" NUMBER(10,0) DEFAULT NULL NOT NULL ENABLE,