lbitonti / liquibase-hana

Liquibase Hana extension
Apache License 2.0
11 stars 11 forks source link

Incorect syntax near onDelete, onUpdate #8

Open Adviser-ua opened 8 years ago

Adviser-ua commented 8 years ago

Hi! When I try apply changeSet - addForeignKeyConstraint I get error

SAP DBTech JDBC: [257] (at 140): sql syntax error: incorrect syntax near "NO": line 1 col 140 (at pos 140) Its lines:

onDelete="NO ACTION"
onUpdate="NO ACTION"

I also have tryed :

onDelete='NO ACTION'
onUpdate='NO ACTION'

but its work with single word parameter like "CASCADE"

However I set nothing

onDelete=""
onUpdate=""

It returns me error

Value '' is not facet-valid with respect to enumeration '[CASCADE, SET NULL, SET DEFAULT, RESTRICT, NO ACTION]'. It must be a value from the enumeration.

So, parameter "NO ACTION" exists in options.