The liquibase.exception occurs during generateChangeLog

General Discussion
1

Hello

I created the TestDb on Microsoft SQL Server 2014, then I created the table

 CREATE TABLE [dbo].[TestTable](
    [Id] [uniqueidentifier] NOT NULL,
    [Name] nchar NULL,
    [Number] [int] NULL,
 CONSTRAINT [PK_TestTable] PRIMARY KEY CLUSTERED
(
    [Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

ALTER TABLE [dbo].[TestTable] ADD  CONSTRAINT [DF_ConstraintName]  DEFAULT (‘No name’) FOR [Name]
GO

After that I create
CREATE DEFAULT [dbo].[DefaultZeroValue]
AS
0
GO

and did
EXEC sp_bindefault ‘DefaultZeroValue’, ‘TestTable.Number’;

After all this, I did
liquibase --defaultsFile=“test.prop” generateChangeLog

and I got newchangelog.mssql.sql with content

–liquibase formatted sql

–changeset TestDb:1510256718974-1
CREATE TABLE [TestTable] ([Id] [uniqueidentifier] NOT NULL, [Name] nchar CONSTRAINT [DF_TestTable_Name] DEFAULT ‘No name’, [Number] [int] CONSTRAINT [DF_TestTable_Number] DEFAULT create default DefaultZeroValue
    as 0);

–changeset TestDb:1510256718974-2
ALTER TABLE [TestTable] ADD CONSTRAINT [PK_TestTable] PRIMARY KEY ([Id]);

But if I change the type of column Number from int to bit and do again sp_bindefault, then after executing
liquibase --defaultsFile=“test.prop” generateChangeLog
I get the exception:

DEBUG 09.11.17 23:38: liquibase: Executing QUERY database command: SELECT CAST([ep].[value] AS nvarchar) AS [REMARKS] FROM [sys].[extended_properties] AS [ep] WHERE [ep].[class] = 1 AND [ep].[major_id] = OBJECT_ID(N’[dbo].[DATABASECHANGELOGLOCK]’) AND [ep].[minor_id] = COLUMNPROPERTY([ep].[major_id], N’LOCKEDBY’, ‘ColumnId’) AND [ep].[name] = ‘MS_Description’
DEBUG 09.11.17 23:38: liquibase: Executing QUERY database command: SELECT CAST(value as varchar(max)) as REMARKS FROM sys.extended_properties WHERE name=‘MS_Description’ AND major_id = OBJECT_ID(’[dbo].[TestTable]’) AND minor_id = 0
Unexpected error running Liquibase: liquibase.exception.DatabaseException: java.lang.NumberFormatException: For input string: “create default DefaultZeroValue  as 0”

SEVERE 09.11.17 23:38: liquibase: liquibase.exception.DatabaseException: java.lang.NumberFormatException: For input string: “create default DefaultZeroValue  as 0”
liquibase.exception.LiquibaseException: liquibase.command.CommandExecutionException: liquibase.exception.DatabaseException: java.lang.NumberFormatException: For input string: “create default DefaultZeroValue  as 0”
        at liquibase.integration.commandline.CommandLineUtils.doGenerateChangeLog(CommandLineUtils.java:265)
        at liquibase.integration.commandline.Main.doMigration(Main.java:1011)
        at liquibase.integration.commandline.Main.run(Main.java:188)
        at liquibase.integration.commandline.Main.main(Main.java:103)
Caused by: liquibase.command.CommandExecutionException: liquibase.exception.DatabaseException: java.lang.NumberFormatException: For input string: “create default DefaultZeroValue  as 0”
        at liquibase.command.AbstractCommand.execute(AbstractCommand.java:13)
        at liquibase.integration.commandline.CommandLineUtils.doGenerateChangeLog(CommandLineUtils.java:263)
        … 3 more
Caused by: liquibase.exception.DatabaseException: java.lang.NumberFormatException: For input string: “create default DefaultZeroValue  as 0”
        at liquibase.snapshot.jvm.ColumnSnapshotGenerator.addTo(ColumnSnapshotGenerator.java:129)
        at liquibase.snapshot.jvm.JdbcSnapshotGenerator.snapshot(JdbcSnapshotGenerator.java:73)
        at liquibase.snapshot.SnapshotGeneratorChain.snapshot(SnapshotGeneratorChain.java:50)
        at liquibase.snapshot.DatabaseSnapshot.include(DatabaseSnapshot.java:246)
        at liquibase.snapshot.DatabaseSnapshot.replaceObject(DatabaseSnapshot.java:363)
        at liquibase.snapshot.DatabaseSnapshot.replaceObject(DatabaseSnapshot.java:385)
        at liquibase.snapshot.DatabaseSnapshot.includeNestedObjects(DatabaseSnapshot.java:293)
        at liquibase.snapshot.DatabaseSnapshot.include(DatabaseSnapshot.java:267)
        at liquibase.snapshot.DatabaseSnapshot.init(DatabaseSnapshot.java:80)
        at liquibase.snapshot.DatabaseSnapshot.(DatabaseSnapshot.java:53)
        at liquibase.snapshot.JdbcDatabaseSnapshot.(JdbcDatabaseSnapshot.java:28)
        at liquibase.snapshot.SnapshotGeneratorFactory.createSnapshot(SnapshotGeneratorFactory.java:150)
        at liquibase.snapshot.SnapshotGeneratorFactory.createSnapshot(SnapshotGeneratorFactory.java:139)
        at liquibase.command.DiffCommand.createReferenceSnapshot(DiffCommand.java:219)
        at liquibase.command.DiffCommand.createDiffResult(DiffCommand.java:141)
        at liquibase.command.GenerateChangeLogCommand.run(GenerateChangeLogCommand.java:45)
        at liquibase.command.AbstractCommand.execute(AbstractCommand.java:8)
        … 4 more
Caused by: java.lang.NumberFormatException: For input string: “create default DefaultZeroValue  as 0”
        at java.lang.NumberFormatException.forInputString(Unknown Source)
        at java.lang.Integer.parseInt(Unknown Source)
        at java.lang.Integer.valueOf(Unknown Source)
        at liquibase.util.SqlUtil.parseValue(SqlUtil.java:142)
        at liquibase.snapshot.jvm.ColumnSnapshotGenerator.readDefaultValue(ColumnSnapshotGenerator.java:491)
        at liquibase.snapshot.jvm.ColumnSnapshotGenerator.readColumn(ColumnSnapshotGenerator.java:273)
        at liquibase.snapshot.jvm.ColumnSnapshotGenerator.addTo(ColumnSnapshotGenerator.java:123)
        … 20 more

For more information, use the --logLevel flag

Please, help