Support Oracle 12c feature identity (autoincrement)

Liquibase Development
1

Hi,

will there be support for Oracle’s new feature in defining an autoincrement column?

int generated as identity


2

I added https://liquibase.jira.com/browse/CORE-1731 to track the feature request. It shouldn’t be difficult to add.


Nathan

3

Hi,

maybe this article could help to find out, how the Oracle-metadata has to be retrieved to identify the colums that own the IDENTITY clause:

http://www.juliandyke.com/Blog/?p=454

We intend to use liquibase in our project, but without the ability to handle IDENTITY-colums, it won’ t work at all.
What would be the right starting point to look for to start with an implementation? Maybe we’ ll find some ressources and build a first solution on our own.
We use Enterprise Architect to model our ERM and the generated output is a DDL-script. Based on that DDL-script, we could generate the necessary liquibase changesets. Doing it that way, we don’ t need to analyze a database - scheme, just generate appropriate SQL-Statements for Oracle based on the DDL.

Any kind of information would be accepted with pleasure.
Thx a lot
Stephan




 

4

If liquibase doesn’t support a feature in the built in tags like , you can always fall back to the tag to specify exactly what you want. You lose some cross-database support and since liquibase doesn’t understand what is being ran you don’t get automatic rollback or dbdoc support.


If you are looking to try to add support, it may be as simple as updating https://github.com/liquibase/liquibase/blob/master/liquibase-core/src/main/java/liquibase/database/core/OracleDatabase.java to return “true” on Nathan