Command execute-sql doesn't show sql output

Applies to

• Liquibase Secure (Pro)
• Liquibase Community (Open Source)

Conditions

• Liquibase version 4.31 or older

Issue Summary

When executing a SQL script with the execute-sql command and the script is multiple lines, Liquibase will display only that the script was executed successfully, but will not display the output, if any, from the database with the results of the script.

This does not occur when the SQL script is only a single line.

Error Message

There is no error message, but console logs will only display that Liquibase executed the script successfully.

Root Cause

This is due to a bug in parsing the multi-line SQL scripts when using the execute-sql command.

Resolution

Update Liquibase to version 4.32.0+.

The latest releases can be found on Liquibase.com and GitHub.

Related Article(s)

• Can I show the SQL output in the logs?
• Why does the validate command not validate SQL syntax?
• Why is my comment being removed from the SQL script after deployment?