* | 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. |