Overview

Every expectation, with a link to its page; plus the three properties the set-comparing expectations share.

This is an overview of all implemented expectations, with a link to the detailed page of each. For what an Expectation is and why a test has one or two queries, see Introduction.

Expectation	Queries	Passes when
Set is empty	1	the query returns no row
Set is not empty	1	the query returns at least one row
Set row count	1	the query returns exactly the number of rows you specify
Sets match	2	the two queries return the same rows
Contains — written as `contains`, `first contains second` or `second contains first`	2	one set holds every row of the other; the other may hold more

Which one to use for which question, with examples, is on Which expectation when — and My expectation does not exist explains why five are enough.

The names are matched by naming convention: set is not empty, Set Is Not Empty, SET_IS_NOT_EMPTY and SetIsNotEmpty are the same expectation.

Every test ends with Passed, Failed, Error or Inconclusive — see Results. The two expectations that compare sets — sets match and contains — share three things that have pages of their own:

Order and key — both sets must be sorted; ORDER BY in the query or Sort data on the test; and the optional Key that lets CAT tell a different row from a missing one.
Tolerance — how far two numbers may be apart and still count as equal.
Failure message — what a failed test reports and the properties that shape it: Maximum errors logged, Maximum sample column length, Log number of errors. Set is empty uses the same properties.