Wildcarding rules for Match Attributes

Table 1. Wildcarding rules for the Match Attributes

PatternDescriptionExample
*Specifying a '*' for a given attribute means that SQLUnit will match all corresponding elements represented by this attribute in the result element. It is equivalent to not specifying the attribute at all.resultset-id="1" row-id="*" col-id="*" means match all rows and all columns in resultset 1
Single number (n)Specifying a single number for a given attribute means that SQLUnit will match all corresponding elements having this attribute in the result element.resultset-id="*" row-id="*" col-id="3" will match the third column in all rows in all resultsets
Range of numbers (m-n)Specifying a range of numbers for a given attribute means that SQLUnit will match all corresponding elements whose attribute falls in the specified range.resultset-id="*" row-id="1" col-id="1-3" will match the first, second and third columns in the first row for all resultsets using this matcher.
Enumeration of numbers (m,n,p)Specifying an enumeration for a given attribute means that SQLUnit will match all corresponding elements whose attributes match one of the numbers in the enumeration.resultset-id="*" row-id="1" col-id="1,2,3" will do the same thing as the above example.
Combination of Enumeration and Range (m-n,p,q)Any combination of range patterns and simple enumeration separated by commas is also supported.resultset-id="*" row-id="1" col-id="1-3,5,6" will match the first, second, third, fifth and sixth columns in the first row for all resultsets using the matcher.