SQL Anywhere: Wrong DDL syntax CREATE SEQUENCE ... AS ...

[mkarg]

Search first

• I searched and no similar issues were found

Description

Using latest SQL Anywhere 17.0.11-7254 as a standalone engine (without using testcontainers) I am trying to execute integration tests, and this is the result:

[ERROR] liquibase.dbtest.asany.SybaseASAIntegrationTest.testRerunDiffChangeLog  Time elapsed: 24.851 s  <<< ERROR!
liquibase.exception.CommandExecutionException:
liquibase.exception.LiquibaseException: liquibase.exception.MigrationFailedException: Migration failed for changeset changelogs/common/common.tests.changelog.xml::seq-test-datatype::flautert:
     Reason: liquibase.exception.DatabaseException: [SAP][JDBC Driver][SQL Anywhere]Syntaxfehler bei 'AS' in Zeile 1  [Failed SQL: (-131) CREATE SEQUENCE lbuser.seqtestdatatypeonall AS int]

Apparently Liquibase expects that SQL Anywhere supports the syntax CREATE SEQUENCE ... AS ..., but according to the latest product manual SQL Anywhere is (and I assume, it ever was) unable to deal with the AS ... clause:

CREATE [ OR REPLACE ] SEQUENCE [ owner .] sequence-name
[ INCREMENT BY signed-integer ]
[ START WITH signed-integer ]
[ MINVALUE signed-integer | NO MINVALUE ]
[ MAXVALUE signed-integer | NO MAXVALUE ]
[ CACHE integer | NO CACHE ]
[ CYCLE | NO CYCLE ]

Steps To Reproduce

dbinit -dba lbuser,LiquibasePass1 liquibase

liquibase:
  sdk:
    testSystem:
      test: asany

      asany:
        url: jdbc:sqlanywhere:DBF=liquibase.db

mvn verify -Dtest=SybaseASAIntegrationTest -Dsurefire.failIfNoSpecifiedTests=false

Expected/Desired Behavior

The IT passes successfully.

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

Standalone engine / Without Testcontainers

Are you willing to submit a PR?

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