Issue with Sybase 15.0.3(Adaptive server Enterprise) and Liquibase RC-2

General Discussion
1

Hi,
Found following issues with Sybase 15.0.3(Adaptive server Enterprise) and Liquibase RC-2(build 143)

A. generateChangelog:
     1. For identity columns with numeric datatype, create table syntax is wrong
         Ex:
             

    create table test(Id numeric Identity Identity(19,0)…

B. Update:
     1. Create Unique Index statement is wrong
         Ex:
             
    CREATE UNIQUE INDEX “dbo”.“TEST_NAME” ON “dbo”.“TEST”(“Name”)

Here, index name is appended with “dbo”. which is causing the problem.
     2. Foreign key generated statement is wrong.
         Ex:

    ALTER TABLE "dbo"."TESTREF" ADD CONSTRAINT "FK_TESTREF_TEST" FOREIGN KEY ("TESTID") REFERENCES "TEST"("Id") ON UPDATE RESTRICT ON DELETE RESTRICT
Here, "ON UPDATE RESTRICT ON DELETE RESTRICT"  causing problem

C. dropAll
      1. generated SQL for dropping the table is wrong.
         Ex:
             

    DROP TABLE “TEST” CASCADE

Here, “CASCADE” is causing the problem

2

Thanks for the report.  I created an issue to track it (http://liquibase.jira.com/browse/CORE-559)

Nathan