Liquibase issue when adding new column with default value with database Sybase

Hello All,

I came across this issue while I was trying to add a new column with default value with sybase as database

                                           

Error -
ALTER TABLE 1] ADD [col1] CHAR(1) NOT NULL DEFAULT ‘N’
Caused By: Error executing SQL ALTER TABLE

1] ADD [col1] CHAR(1) NOT NULL DEFAULT ‘N’:
Caused By: Incorrect syntax near the keyword ‘DEFAULT’.

When I went through the source code of Liquibase - Class AddColumnStatement.java [Method - getSqlStatement] found that Default is always added after NOT NULL/NULL text (for sybase ofcourse), reason is one of the method is not returning sybase instance and as per sybase syntax Default should come before NOT NULL/NULL

Jar with the modified code is working fine. Please find the attached files (original and modified by me) and let me know if the change is really needed.

I made the change for 2.0.  Thanks for the fix.

Nathan