We're updating the issue view to help you get more done. 

`updateSql` command should validate the SQL query

Description

Imaging I have a changelog like this with a typo `CREATE` -> `CRATE`. Right now `update` will raise an error but `updateSQL` will not (it will generate `target/liquibase/migrate.sql` with this typo).

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 { "databaseChangeLog": [ { "changeSet": { "id": "1", "author": "cynthiaqiu", "changes": [ { "sql": { "sql": "CRETE TABLE table_2 (id serial PRIMARY KEY);" } } ] } } ] }

Should either `updateSQL` raise an error about invalid SQL query, or there should be a (real) dry run mode which can catch this error.

By doing so, people can add it to their CI (unit) test, so they don't need to know this error when they apply liquibase change in the deployment state.

Environment

postgres 11
docker maven:3.6.1-jdk-11 image

Status

Assignee

Unassigned

Reporter

Cynthia Qiu

Labels

None

Affects versions

3.6.3

Priority

Major