Add support for AddNullConstraint and DropNullConstraint to Firebird

Description

Please add support for FirebirdDatabase:

  • AddNullConstraint

  • DropNullConstraint

Liquibase can do this using a simple update DML.

  • Dropping null constraint

    update RDB$RELATION_FIELDS set RDB$NULL_FLAG = NULL where (RDB$FIELD_NAME = 'COLUMN_NAME') and (RDB$RELATION_NAME = 'TABLE_NAME')
  • Adding null constraint

    update RDB$RELATION_FIELDS set RDB$NULL_FLAG = 1 where (RDB$FIELD_NAME = 'COLUMN_NAME') and (RDB$RELATION_NAME = 'TABLE_NAME')

Environment

Windows 10 PRO x64, JDK 1.8.121, liquibase 3.5.1

Activity

Show:

Details

Reporter

Affects versions

Priority

Created February 3, 2017 at 6:36 PM
Updated February 3, 2017 at 6:36 PM

Flag notifications