Default on null - Oracle 12c feature

Liquibase Development
1

Hi,
I am using:
Liquibase version: 3.5.1
Oracle version: 12c

I am trying to create table with liquibase script (XML):

CREATE SEQUENCE QUOTE_SEQUENCE;
CREATE TABLE QUOTATION(
q_id NUMBER
GENERATED ALWAYS AS IDENTITY
PRIMARY KEY,
quote_id NUMBER DEFAULT ON NULL QUOTE_SEQUENCE.NEXTVAL
);

Not sure how to represent ‘DEFAULT ON NULL’ clause introduced in Oracle 12c.

I have tried using defaultValueSequenceNext, but it just renders ‘DEFAULT’. But what I am looking for is ‘DEFAULT ON NULL’
Workaround I used is (after table creation):

ALTER TABLE QUOTATION MODIFY QUOTE_ID NUMBER DEFAULT ON NULL QUOTE_SEQUENCE.NEXTVAL;

Any help is appreciated.

2

Hi @ravivarmakola,

If DEFAULT ON NULL is not working with xml, you could as a workaround use plain sql. Would that work?

Also, if this is a new feature, it may not be implemented in liquibase yet, I defer to @NathanVoxland / @mariochampion on answering if that should work in liquibase.

-Ronak

3

Any updates? My team will soon be updating generating primary keys using the DEFAULT ON NULL "SEQ"."NEXTVAL" syntax, which will also let us drop a bunch of triggers.

While it’s not a problem to use sql, it would be nice to know if Liquibase already supports the above or if support is planned.