Compute diff-changelog for TIMESTAMP WITH TIME ZONE columns

Hello all,

I’m comparing two ORACLE schemas with the diff-changelog command. The only difference between the two schemas is that, in the base schema one column has “TIMESTAMP” type, while in the reference schema, it has “TIMESTAMP WITH TIME ZONE” type.

In the generated diff, I can see that Liquibase did detect exactly this single change, but it puts “newDataType=“timestamp(6)”” into the xml.

Interestingly, it doesn’t matter if I swap schema and reference schema - the change is detected, and the new type is timestamp(6).

Is this a bug or am I doing something wrong?

(I just downloaded 4.31 just to be sure it’s not a version issue, but problem persists.)

Marcus.

Hi Marcus (@zpneun),

Yeap, this seems to be a core bug. There is an open discussion we started here in case you want to contribute there. I added my comment there, where I also mentioned that someone form the community has recently fixed a similar issue for Hibernate extension.

Thanks,
Daniel.