Why does the validate command not validate SQL syntax?

Applies to: 

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

Conditions:

• All versions of Liquibase Secure (Pro) or Community

Question:

Why is the validate command not validating my SQL syntax?

Answer:

This is expected behavior.

The validate command only looks for possible errors in the changelog. It does not check for possible errors that might result from applying the changes to a specific database or validate SQL within changesets.

Use the validate command to ensure:

• The XML, YAML, JSON, or formatted SQL is structured correctly
• Referenced files can be found
• There are no duplicated id, author, and file combinations
• There are no checksum errors

Related Article(s):

Validate Command Documentation