Re: Does PostgreSQL have complete functional test cases?

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.

I looked at the regression.diffs file, but I don't understand what it said.

For example, I have a bunch of things as follows:


*** /home/tianyin/source_code/postgresql-9.2.1/src/test/regress/expected/select.out     2012-09-19 14:47:58.000000000 -0700
--- /home/tianyin/source_code/postgresql-9.2.1/src/test/regress/results/select.out      2012-11-08 11:02:54.306666883 -0800
***************
*** 219,234 ****
  SELECT onek2.* FROM onek2 WHERE onek2.unique1 < 10;
   unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even | stringu1 | stringu2 | string4
  ---------+---------+-----+------+-----+--------+---------+----------+-------------+-----------+----------+-----+------+----------+----------+---------
!        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
  (10 rows)

......

*** 268,292 ****
     WHERE onek2.unique1 > 980;
   unique1 | stringu1
  ---------+----------
!      981 | TLAAAA
!      982 | ULAAAA
       983 | VLAAAA
-      984 | WLAAAA
-      985 | XLAAAA
-      986 | YLAAAA
-      987 | ZLAAAA
-      988 | AMAAAA
       989 | BMAAAA
       990 | CMAAAA
       991 | DMAAAA
!      992 | EMAAAA
       993 | FMAAAA
       994 | GMAAAA
!      995 | HMAAAA
!      996 | IMAAAA
!      997 | JMAAAA
!      998 | KMAAAA
!      999 | LMAAAA
  (19 rows)

And also something like that:

*** /home/tianyin/source_code/postgresql-9.2.1/src/test/regress/expected/join.out       2012-09-19 14:47:58.000000000 -0700
--- /home/tianyin/source_code/postgresql-9.2.1/src/test/regress/results/join.out        2012-11-08 11:02:56.210666929 -0800
***************
*** 2545,2561 ****
    ( SELECT COALESCE(q2, -1) AS qq FROM int8_tbl b ) AS ss2
    USING (qq)
    INNER JOIN tenk1 c ON qq = unique2;
!                                               QUERY PLAN                                              
! -------------------------------------------------------------------------------------------------------
!  Nested Loop
!    ->  Hash Full Join
!          Hash Cond: (COALESCE(a.q1, 0::bigint) = COALESCE(b.q2, (-1)::bigint))
!          ->  Seq Scan on int8_tbl a
!          ->  Hash
!                ->  Seq Scan on int8_tbl b
!    ->  Index Scan using tenk1_unique2 on tenk1 c
!          Index Cond: (unique2 = COALESCE((COALESCE(a.q1, 0::bigint)), (COALESCE(b.q2, (-1)::bigint))))
! (8 rows)

  SELECT qq, unique1
    FROM


*** /home/tianyin/source_code/postgresql-9.2.1/src/test/regress/expected/stats.out      2012-09-19 14:47:58.000000000 -0700
--- /home/tianyin/source_code/postgresql-9.2.1/src/test/regress/results/stats.out       2012-11-08 11:04:15.206668806 -0800
***************
*** 99,105 ****
   WHERE st.relname='tenk2' AND cl.relname='tenk2';
   ?column? | ?column? | ?column? | ?column?
  ----------+----------+----------+----------
!  t        | t        | t        | t
  (1 row)

  SELECT st.heap_blks_read + st.heap_blks_hit >= pr.heap_blks + cl.relpages,
--- 99,105 ----
   WHERE st.relname='tenk2' AND cl.relname='tenk2';
   ?column? | ?column? | ?column? | ?column?
  ----------+----------+----------+----------
!  t        | t        | f        | f
  (1 row)

  SELECT st.heap_blks_read + st.heap_blks_hit >= pr.heap_blks + cl.relpages,
***************
*** 108,114 ****
   WHERE st.relname='tenk2' AND cl.relname='tenk2';
   ?column? | ?column?
  ----------+----------
!  t        | t
  (1 row)

  -- End of Stats Test
--- 108,114 ----
   WHERE st.relname='tenk2' AND cl.relname='tenk2';
   ?column? | ?column?
  ----------+----------
!  t        | f
  (1 row)

  -- End of Stats Test

======================================================================