New in liquibase. Error on GTT on oracle 19c

Liquibase Development
1

Hi, I’m new on liquibase and decide to try the community version work.

I was testing it over Oracle 19c but the changelog generated an error. When I reviewed the log I found there is an error on the sentence for GLOBAL TEMPORARY TABLE.
I also found out there was an issue similar, but not the same, back in 2020 (it created a common table instead of temporary table).
In my case, it tries to create a temporary table, but uses:
CREATE TEMPORARY GLOBAL TABLE …
Instead of
CREATE GLOBAL TEMPORARY TABLE …
And also, the ON COMMIT part is missing.

Is it a new issue? Is it a known issue?
Is it a problem only in the community version?

Thanks

2

Please provide your entire changeset so we can see what you are trying to do, and the version of Liquibase you are using.

Thanks.

3

I am able to replicate this issue. Thanks for reporting it. We are looking into it.

Wesley

1 Like
4

Sorry don’t have it. I have deinstalled everything last time.