Hi all,
we are using <span. - But I think this woth to be reported…
Error output:
[…]
Caused by: liquibase.exception.MigrationFailedException: Migration failed for change set /META-INF/dbchangelogs/1.0.0/base-tables.xml::BASE_TABLES_1.0.0::tgilch:
Reason: liquibase.exception.DatabaseException: Error executing SQL ALTER TABLE [dbo].[myTable] ADD CONSTRAINT [myFK] FOREIGN KEY ([fk_col]) REFERENCES [dbo].[myLookupTable] ([pk_lookup_col]) ON UPDATE RESTRICT: Incorrect syntax near the keyword ‘RESTRICT’.:
Caused By: Error executing SQL ALTER TABLE [dbo].[myTable] ADD CONSTRAINT [myFK] FOREIGN KEY ([fk_col]) REFERENCES [dbo].[myLookupTable] ([pk_lookup_col]) ON UPDATE RESTRICT: Incorrect syntax near the keyword ‘RESTRICT’.:
Caused By: Incorrect syntax near the keyword ‘RESTRICT’.
at liquibase.changelog.ChangeSet.execute(ChangeSet.java:347)
at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:27)
at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:58)
at liquibase.Liquibase.update(Liquibase.java:113)
at de.aicgroup.commons.entity.repository.liquibase.SpringLiquibaseAdapter.afterPropertiesSet(SpringLiquibaseAdapter.java:88)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1477)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1417)
… 47 more
Caused by: liquibase.exception.DatabaseException: Error executing SQL ALTER TABLE [dbo].[myTable] ADD CONSTRAINT [myFK] FOREIGN KEY ([fk_col]) REFERENCES [dbo].[myLookupTable] ([pk_lookup_col]) ON UPDATE RESTRICT: Incorrect syntax near the keyword ‘RESTRICT’.
at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:62)
at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:105)
at liquibase.database.AbstractDatabase.execute(AbstractDatabase.java:1014)
at liquibase.database.AbstractDatabase.executeStatements(AbstractDatabase.java:998)
at liquibase.changelog.ChangeSet.execute(ChangeSet.java:317)
… 53 more
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near the keyword ‘RESTRICT’.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:196)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1454)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQLServerStatement.java:786)
at com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(SQLServerStatement.java:685)
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:4026)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1416)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:185)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:160)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.execute(SQLServerStatement.java:658)
at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
at liquibase.executor.jvm.JdbcExecutor$1ExecuteStatementCallback.doInStatement(JdbcExecutor.java:92)
at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:55)
… 57 more
[…]