As I was investing playing around with blocksize, I noticed that some test cases under "make check" vary depending on compilation parameters, as they:

 - do not order the result of queries, thus are not deterministic
   [join, with]

 - output query plans which differ depending on some parameters
   [updatable_views, union, select_views]

Thus "make check" fails.

  sh> ./configure --blocksize=4
  sh> make
  sh> make check
   5 of 144 tests failed.

Adding some "ORDER BY" should solve the first issue, but ISTM that testing the output of query plans is a lost case for determinism, so maybe these test cases should be ignored/skipped when parameters are different.


Sent via pgsql-hackers mailing list (
To make changes to your subscription:

Reply via email to