I came across this issue while I was trying to add a new column with default value with sybase as database
ALTER TABLE 1] ADD [col1] CHAR(1) NOT NULL DEFAULT ‘N’
Caused By: Error executing SQL ALTER TABLE
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.