nvarchar(max) not supported on SQL Server

General Discussion
1

Hi
I’ve been using this great tool for a while and just want to say that it has saved our team lots of times when trying to resolved schema upgrade problems.

I’m using a build of liquibase based on revision 1586 (RC3-SNAPSHOT) and I have an exception being thrown on a NVarchar column in a SQL Server 2005 defined as:

                               

the exception is

    java.lang.NumberFormatException: For input string: "MAX"         at java.lang.NumberFormatException.forInputString(NumberFormatException.java:48)         at java.lang.Integer.parseInt(Integer.java:447)         at java.lang.Integer.parseInt(Integer.java:497)         at liquibase.database.typeconversion.core.AbstractTypeConverter.addPrecisionToType(AbstractTypeConverter.java:234)         at liquibase.database.typeconversion.core.AbstractTypeConverter.getDataType(AbstractTypeConverter.java:226)         at liquibase.database.typeconversion.core.MSSQLTypeConverter.getDataType(MSSQLTypeConverter.java:56)         at liquibase.database.typeconversion.core.AbstractTypeConverter.getDataType(AbstractTypeConverter.java:162)         at liquibase.database.typeconversion.core.MSSQLTypeConverter.getDataType(MSSQLTypeConverter.java:42)         at liquibase.change.core.CreateTableChange.generateStatements(CreateTableChange.java:48)
Is there any known work-around for this column type?

Issue created: http://liquibase.jira.com/browse/CORE-674
TIA

2

It should be fixed in trunk now.  THanks for creating the issue in jira.

Nathan

3

Thanks a lot for the quick fix.