Why is Liquibase throwing this error: Could not parse a SqlCheck precondition

0
votes

I'm trying to add preconditions to a SQL formatted changeset in Liquibase 3.1.1

--preconditions onFail=HALT onError=HALT --precondition-sql-check expectedResult=0 SELECT COUNT(*) FROM USER_ERRORS WHERE TYPE = 'PROCEDURE' --changeset myteam:101 runAlways:true

Liquibase raises this error when I run a status:

Liquibase status Failed: Could not parse a SqlCheck precondition from 'expectedResult=0 SELECT COUNT(*) FROM USER_ERRORS WHERE TYPE = ' PROCEDURE''.

What's wrong with that precondition syntax?

1
liquibase

1 Answers

1
votes

There needs to be a colon instead of an equals char after "expectedResult".

So the line should be: 

--precondition-sql-check expectedResult:0 SELECT COUNT(*) FROM USER_ERRORS WHERE TYPE = 'PROCEDURE'

Then it should work.

EDIT: (Documentation was updated. See Nathans comment.)

This is also wrong on the liquibase documentation for the Formatted SQL Changelogs.