The following bug has been logged on the website:
Bug reference: 14847
Logged by: Bernhard Rosenkraenzer
Email address: bero@lindev.ch
PostgreSQL version: 10.0
Operating system: OpenMandriva Linux (kernel 4.13.5, glibc 2.26)
Description:
Running "make check" after building postgresql 10.0 results in
[...]
test stats ... FAILED
============== shutting down postmaster ==============
========================1 of 178 tests failed.
========================
The differences that caused some tests to fail can be viewed in the
file
"/home/bero/abf/postgresql/BUILD/postgresql-10.0/src/test/regress/regression.diffs".A copy of the test summary that you
see
above is saved in the file
"/home/bero/abf/postgresql/BUILD/postgresql-10.0/src/test/regress/regression.out".
regression.diffs:
***
/home/bero/abf/postgresql/BUILD/postgresql-10.0/src/test/regress/expected/stats.out2017-10-02
23:09:15.000000000 +0200
---
/home/bero/abf/postgresql/BUILD/postgresql-10.0/src/test/regress/results/stats.out2017-10-07
17:02:03.791369854 +0200
***************
*** 8,14 **** SHOW track_counts; -- must be on track_counts --------------
! on (1 row) -- ensure that both seqscan and indexscan plans are allowed
--- 8,14 ---- SHOW track_counts; -- must be on track_counts --------------
! off (1 row) -- ensure that both seqscan and indexscan plans are allowed
***************
*** 162,172 **** WHERE relname like 'trunc_stats_test%' order by relname; relname | n_tup_ins | n_tup_upd |
n_tup_del| n_live_tup |
n_dead_tup
-------------------+-----------+-----------+-----------+------------+------------
! trunc_stats_test | 3 | 0 | 0 | 0 | 0
! trunc_stats_test1 | 4 | 2 | 1 | 1 | 0
! trunc_stats_test2 | 1 | 0 | 0 | 1 | 0
! trunc_stats_test3 | 4 | 0 | 0 | 2 | 2
! trunc_stats_test4 | 2 | 0 | 0 | 0 | 2 (5 rows) SELECT st.seq_scan >=
pr.seq_scan+ 1,
--- 162,172 ---- WHERE relname like 'trunc_stats_test%' order by relname; relname | n_tup_ins | n_tup_upd |
n_tup_del| n_live_tup |
n_dead_tup
-------------------+-----------+-----------+-----------+------------+------------
! trunc_stats_test | 0 | 0 | 0 | 0 | 0
! trunc_stats_test1 | 0 | 0 | 0 | 0 | 0
! trunc_stats_test2 | 0 | 0 | 0 | 0 | 0
! trunc_stats_test3 | 0 | 0 | 0 | 0 | 0
! trunc_stats_test4 | 0 | 0 | 0 | 0 | 0 (5 rows) SELECT st.seq_scan >=
pr.seq_scan+ 1,
***************
*** 177,183 **** 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,
--- 177,183 ---- WHERE st.relname='tenk2' AND cl.relname='tenk2'; ?column? | ?column? | ?column? | ?column?
----------+----------+----------+----------
! f | f | f | f (1 row) SELECT st.heap_blks_read + st.heap_blks_hit >= pr.heap_blks +
cl.relpages,
***************
*** 186,199 **** WHERE st.relname='tenk2' AND cl.relname='tenk2'; ?column? | ?column? ----------+----------
! t | t (1 row) SELECT pr.snap_ts < pg_stat_get_snapshot_timestamp() as snapshot_newer FROM prevstats AS pr;
snapshot_newer ----------------
! t (1 row) DROP TABLE trunc_stats_test, trunc_stats_test1, trunc_stats_test2,
trunc_stats_test3, trunc_stats_test4;
--- 186,199 ---- WHERE st.relname='tenk2' AND cl.relname='tenk2'; ?column? | ?column? ----------+----------
! f | f (1 row) SELECT pr.snap_ts < pg_stat_get_snapshot_timestamp() as snapshot_newer FROM prevstats AS pr;
snapshot_newer ----------------
! f (1 row) DROP TABLE trunc_stats_test, trunc_stats_test1, trunc_stats_test2,
trunc_stats_test3, trunc_stats_test4;
======================================================================
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs