Java – liquibase: how to use it?

I'm looking for an example of how to use < where params > < / where params >, which belongs to < update > < / update >, but I can't find anything (even in the official documents)

Any help would be appreciated thank you.

Solution

An example usage is

<update tableName="updateTest">
        <column name="varcharColumn" value="new column 1 value"/>
        <column name="dateCol" valueDate="2008-01-01"/>
        <column name="intCol" valueNumeric="11"/>
        <where>id=:value</where>
        <whereParams>
            <param valueNumeric="134" />
        </whereParams>
</update>

The: value statement block in < where > is replaced with the value in the 'param' block If there are multiple: value statements, replace them sequentially in the where clause

However, looking at the code, it seems that the use of whereparams is not well used or integrated Maybe I missed where it was picked up, but it may not even work outside of blob / CLOB updates

Give it a try and see if it suits you, otherwise I will stick to the standard block until the support is improved