RecordChecker Tests
This document tests the use of RecordCheckers by testing their ability to compare data that is out of order, with different column orders, and so on.
Here is the first table, which contains all of the original items, albeit out of order:
Interesting Numbers |
||||||
first |
second |
third |
fourth |
fifth |
sixth |
seventh |
1 |
2 |
3 |
4 |
5 |
6 |
7 |
1 |
2 |
4 |
8 |
16 |
32 |
64 |
1 |
1 |
2 |
3 |
5 |
8 |
13 |
2 |
3 |
5 |
7 |
11 |
13 |
17 |
1 |
4 |
9 |
16 |
25 |
36 |
49 |
2 |
4 |
6 |
8 |
10 |
12 |
14 |
And this is the second table, a highly-obfuscated version of the above, with missing and out-of-order columns, although it still contains all the rows:
Interesting Numbers |
|||
first |
seventh |
fifth |
third |
2 |
14 |
10 |
6 |
1 |
7 |
5 |
3 |
2 |
17 |
11 |
5 |
1 |
13 |
5 |
2 |
1 |
49 |
25 |
9 |
1 |
64 |
16 |
4 |
Finally, this third table contains deliberate errors, to test error reporting. First, the Fibonacci sequence shouldn't end in 11, the prime numbers are in fact just odd numbers, and multiples of 2 have been replaced with multiples of three, thus guaranteeing that there will be both missing and extra rows.
Interesting Numbers |
||||||
first |
second |
third |
fourth |
fifth |
sixth |
seventh |
1 |
2 |
3 |
4 |
5 |
6 |
7 |
1 |
2 |
4 |
8 |
16 |
32 |
64 |
1 |
1 |
2 |
3 |
5 |
8 |
11 expected 13 actual |
2 |
3 |
5 |
7 |
9 expected 11 actual |
11 expected 13 actual |
13 expected 17 actual |
1 |
4 |
9 |
16 |
25 |
36 |
49 |
3 missing |
6 |
9 |
12 |
15 |
18 |
21 |
2 extra | 4 | 6 | 8 | 10 | 12 | 14 |