OracleSync2MySQL icon indicating copy to clipboard operation
OracleSync2MySQL copied to clipboard

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

Open donglinqing opened this issue 1 year ago • 2 comments

转换前: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 avatar Jul 18 '24 08:07 donglinqing

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

donglinqing avatar Jul 18 '24 08:07 donglinqing

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

donglinqing avatar Jul 18 '24 08:07 donglinqing

create table TB_25(ORDER_ int not null default null ); 看了下是MySQL不支持这种写法,后面发版会修复

iverycd avatar Apr 08 '25 03:04 iverycd