I’m having a problem with the head of trunk when calling the dropAllDatabaseObject ant task on a SQLServer db (this worked previously, the only change was to update liquibase from revision 1719 to 1776). I now get the following error when running dropAllDatabaseObject (full stacktrace attached):
liquibase.exception.DatabaseException: Error getting jdbc:jtds:sqlserver://myserver/mydatabase view with liquibase.statement.core.GetViewDefinitionStatement@13f210f
Looking back through the recent commits on liquibase, commit 1764 (http://liquibase.jira.com/source/changelog/CORE/?cs=1764) seemed to be the most relevant so I backed-off to revision 1763 and the exception no longer occurs. The error is caused by liquibase trying to run the following sql:
select object_definition(object_id) from sys.objects where type=‘v’ and upper(name)=‘CASEENTITIES’ and schema_id=‘dbo’
Clearly, “dbo” is not a valid value for the schema_id.