大家如果过哪些OB兼容性问题?我这边主要是遇到日期函数转换的问题,如:
– 错误示例
– OceanBase-3.x ERROR [1292] [22001]: Incorrect value
– OceanBase-4.x ERROR 1292 (22007): Incorrect value
truncate table hksdevdb.test_c;
insert into hksdevdb.test_c(C1,C2)
select
20470417 as C1,
‘2047-04-17’ as C2
from
hksdevdb.test_a
where
date(A12) = 2047-04-17 – 出错行 A12: decima(8,0)
;
– 正确示例(${TX_DATE} → ‘${TX_DATE}’)
truncate table hksdevdb.test_c;
insert into hksdevdb.test_c(C1,C2)
select
20470417 as C1,
‘2047-04-17’ as C2
from
hksdevdb.test_a
where
date(A12) = ‘2047-04-17’
;
– 正确示例(${TX_DATE} → ${AC_DATE})
truncate table hksdevdb.test_c;
insert into hksdevdb.test_c(C1,C2)
select
20470417 as C1,
‘2047-04-17’ as C2
from
hksdevdb.test_a
where
date(A12) = 20470417
;