Re: Does PostgreSQL have complete functional test cases?

On 11/09/2012 03:28 AM, Tianyin Xu wrote:
> Thanks a lot, Pavel, Jeff, Andres!
>
> I just changed the configuration file, postgresql.conf.
>
> Using the default one, all the regress tests are passed (so it should
> not be the block size?). But when I changed something, quite a number
> of tests are failed.

Changed "something". What did you change?

> ! 0 | 998 | 0 | 0 | 0 | 0 | 0 | 0
> | 0 | 0 | 0 | 0 | 1 | AAAAAA |
> KMBAAA | OOOOxx
> 1 | 214 | 1 | 1 | 1 | 1 | 1 | 1
> | 1 | 1 | 1 | 2 | 3 | BAAAAA |
> GIAAAA | OOOOxx
> 2 | 326 | 0 | 2 | 2 | 2 | 2 | 2
> | 2 | 2 | 2 | 4 | 5 | CAAAAA |
> OMAAAA | OOOOxx
> 3 | 431 | 1 | 3 | 3 | 3 | 3 | 3
> | 3 | 3 | 3 | 6 | 7 | DAAAAA |
> PQAAAA | VVVVxx
> - 4 | 833 | 0 | 0 | 4 | 4 | 4 | 4
> | 4 | 4 | 4 | 8 | 9 | EAAAAA |
> BGBAAA | HHHHxx
> 5 | 541 | 1 | 1 | 5 | 5 | 5 | 5
> | 5 | 5 | 5 | 10 | 11 | FAAAAA |
> VUAAAA | HHHHxx
> - 6 | 978 | 0 | 2 | 6 | 6 | 6 | 6
> | 6 | 6 | 6 | 12 | 13 | GAAAAA |
> QLBAAA | OOOOxx
> 7 | 647 | 1 | 3 | 7 | 7 | 7 | 7
> | 7 | 7 | 7 | 14 | 15 | HAAAAA |
> XYAAAA | VVVVxx
> 8 | 653 | 0 | 0 | 8 | 8 | 8 | 8
> | 8 | 8 | 8 | 16 | 17 | IAAAAA |
> DZAAAA | HHHHxx
> ! 9 | 49 | 1 | 1 | 9 | 9 | 9 | 9
> | 9 | 9 | 9 | 18 | 19 | JAAAAA |
> XBAAAA | HHHHxx
>

This is a context diff. http://en.wikipedia.org/wiki/Diff#Context_format .

Lines beginning with + mean the line is added. Lines with - mean the
line is removed. Lines with ! mean the line is changed.

Here, you can see that two rows are not output that should be, and two
others are output with different-than-expected values; they could've
been swapped with each other, or just have totally unexpected values.
See the expected/ files for the output that should be produced.

--
Craig Ringer