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 extra468101214