Firebird does not support RESTRICT option on Foreign Keys

Description

Executing a refactoring like the following on a Firebird database leads to an error.

<addForeignKeyConstraint constraintName="FK_TABLE1_01"
baseTableName="TABLE1" baseColumnNames="COLUMN1"
referencedTableName="TABLE2" referencedColumnNames="COLUMN1"
onUpdate="RESTRICT" onDelete="RESTRICT"/>

The error is:
Token unknown - line xy, column xyz
RESTRICT

In case of RESTRICT the ON UPDATE and ON DELETE part must be ommitted, because it is then the default behaviour of Firebird. See the Firebird-FAQ at http://www.firebirdfaq.org/faq338/

Environment

All environments execute Liquibase scripts on a Firebird database

Status

Assignee

Unassigned

Reporter

Michael Hausl

Labels

None

Components

Fix versions

Affects versions

Priority

Trivial
Configure