includeAll fails with filter="sql"

General Discussion
1

<includeAll path="release5" filter="sql"/>
fails with error

Starting Liquibase at 01:29:58 (version 4.4.0 #11 built at 2021-06-09 16:36+0000)
Liquibase Version: 4.4.0
Liquibase Community 4.4.0 by Datical
Unexpected error running Liquibase: sql

2

Could you please share the exact command you ran and exact ERROR you see on running that command?

Thanks!
Rakhi Agrawal

3 
<?xml version="1.0" encoding="UTF-8"?>  
<databaseChangeLog  
  xmlns="http://www.liquibase.org/xml/ns/dbchangelog"  
  xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"  
  xmlns:pro="http://www.liquibase.org/xml/ns/pro"  
  xsi:schemaLocation="http://www.liquibase.org/xml/ns/dbchangelog http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-4.2.xsd http://www.liquibase.org/xml/ns/pro http://www.liquibase.org/xml/ns/pro/liquibase-pro-4.2.xsd">  

  <includeAll path="release5" filter="sql"/>  

</databaseChangeLog>
4

Could you please share the exact error you get?

Also please read here, the exact use of filter attribute with includeAll tag. Please make sure, you are using it right.

Thanks!
Rakhi Agrawal

5

FYI
I got this example from Nathan Voxland’s blog Liquibase | Liquibase Without Changelogs

6

It looks like the “filter” attribute shouldn’t be there in the blog. I’ll get that fixed.

The filter attribute takes the name of a class, which allows more complex filtering. By default, it is going to includeAll anything that it sees in the directory which liquibase can parse, which would include sql files. It would pick up any xml/yaml/json files you have in that directory too, but assuming you’re pointing to a directory that is just used for changelogs, you’re good.

Nathan