Liquibase脚本返回ORA-01843:无效月份
技术问答
227 人阅读
|
0 人回复
|
2023-09-12
|
我在以下liquibase脚本中遇到麻烦:4 E$ A# |$ d7 p8 o' f: J/ j9 s
7 l# d0 V+ F \2 t; \% x# h MERGE INTO A config7 c% O0 x. ~) M9 z" t
USING (SELECT 100 as id, '02.01.15 12:00:00' as CHANGED, 0 as DELETED, 1 as B FROM DUAL) src ON (src.id = config.id)/ D* h: W+ ~- x
WHEN NOT MATCHED THEN
7 u/ P/ d- Y4 H, z INSERT(id,CHANGED, DELETED, B) VALUES(src.id, src.CHANGED, src.DELETED, src.B)
# N- g& L/ H- n% C/ O0 f( z WHEN MATCHED THEN' v7 U8 O! b% o
UPDATE SET config.B = src.B;6 B& U+ W) ?- q; @: P8 p. C
. I. Z+ s# Q0 F6 j6 p: @1 N
当我在sql标记之间插入原始代码并在数据库下运行(在SQL Developer中)时,结果是:合并了1行。0 B, R& Q- ?9 B9 Q- P
当我通过liquibase运行它时,出现错误 ORA-01843:不是有效月份 。
# d0 z/ {0 N5 X+ X6 ?1 h这怎么可能?5 a9 D b& q. L) e" s4 J
( ?) r$ _+ c6 c/ V% q+ J' `
解决方案: |
|
|
|
|
|