SQL Anywhere: generateChangeLog fails when column's default value is an expression (e. g. Unexpected error running Liquibase: Unknown boolean value: if "mycol" is null then 0 else 1 endif)

[mkarg]

Search first

• I searched and no similar issues were found

Description

In SQL Anywhere, columns can have default values which are no literals but expressions, for example if "mycol" is null then 0 else 1 endif. Apparently Liquibase cannot support expressions but only literals, as the error message says:

Unexpected error running Liquibase: Unknown boolean value: if "mycol" is null then 0 else 1 endif

This is a showstopper for generating change log from existing SQL Anywhere database.

Steps To Reproduce

CREATE TABLE A (
  c1 int,
  c2 bit NULL COMPUTE (if "c1" is null then 0 else 1 endif)
)

liquibase --changeLogFile=mydatabase_changelog.xml generateChangeLog

Expected/Desired Behavior

Liquibase successfully creates change log including the column default value expression if "mycol" is null then 0 else 1 endif".

Liquibase Version

master

Database Vendor & Version

SAP SQL Anywhere 17.0.11

Liquibase Integration

N/A

Liquibase Extensions

N/A

OS and/or Infrastructure Type/Provider

Windows 10 Pro (German)

Additional Context

N/A

Are you willing to submit a PR?

• I'm willing to submit a PR (Thank you!)

[mkarg]

I started to work on a fix for this issue.