Starting Liquibase at 12:54:53 (version 4.4.3 #53 built at 2021-08-05 18:32+0000)
Liquibase Version: 4.4.3
Liquibase Community 4.4.3 by Datical
BEST PRACTICE: The changelog generated by diffChangeLog/generateChangeLog should be inspected for correctness and completeness before being deployed.
Unexpected error running Liquibase: Expected single row from liquibase.statement.core.GetViewDefinitionStatement@52b56a3e but got 2
I’m thinking the problem sql is:
select STATEMENT AS view_definition, * from SYSIBM.SYSVIEWS where NAME='{VIEW_NAME}' and (PATHSCHEMAS LIKE '%{SCHEMA_NAME}%' OR CREATOR = '{SCHEMA_NAME}')
Are you able to run that locally (replacing the {VIEW_NAME} and {SCHEMA_NAME} ) and see if it’s returning back two rows for you?
Can you tell why there are two rows vs. just one for the definition we’re looking for?
Nathan