OracleSync2MySQL
OracleSync2MySQL copied to clipboard
not null 转换后变为not null default null 报错 Invalid default value
转换前: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_'"}
oracle 实际表结构"ORDER_" NUMBER(10,0) DEFAULT NULL NOT NULL ENABLE,
oracle 实际表结构"ORDER_" NUMBER(10,0) DEFAULT NULL NOT NULL ENABLE,
create table TB_25(ORDER_ int not null default null );
看了下是MySQL不支持这种写法,后面发版会修复