Hello, hackers! I got a permanent failure of master (commit
ca454b9bd34c75995eda4d07c9858f7c22890c2b) make check on Solaris 10.
Regression output and diffs are attached.
I used the following commands:
./configure CC="ccache gcc" CFLAGS="-m64 -I/opt/csw/include"
LDFLAGS="-L/opt/csw/lib/sparcv9 -L/usr/local/lib/64" --enable-cassert
--enable-debug --enable-nls --with-perl --with-tcl --with-python
--with-gssapi --with-openssl --with-ldap --with-libxml --with-libxslt
gmake > make_results.txt
gmake check
About the system: SunOS, Release 5.10, KernelID Generic_141444-09.
--
Marina Polyakova
Postgres Professional: http://www.postgrespro.com
The Russian Postgres Company
*** /home/buildfarm/mpolyakova/postgresql_master/src/test/regress/expected/random.out Thu Jan 11 19:37:51 2018
--- /home/buildfarm/mpolyakova/postgresql_master/src/test/regress/results/random.out Thu Jan 11 20:10:29 2018
***************
*** 46,52 ****
SELECT AVG(random) FROM RANDOM_TBL
HAVING AVG(random) NOT BETWEEN 80 AND 120;
! avg
! -----
! (0 rows)
--- 46,53 ----
SELECT AVG(random) FROM RANDOM_TBL
HAVING AVG(random) NOT BETWEEN 80 AND 120;
! avg
! ----------------------
! 13835058055282163712
! (1 row)
======================================================================
*** /home/buildfarm/mpolyakova/postgresql_master/src/test/regress/expected/groupingsets.out Thu Jan 11 19:37:50 2018
--- /home/buildfarm/mpolyakova/postgresql_master/src/test/regress/results/groupingsets.out Thu Jan 11 20:11:18 2018
***************
*** 143,156 ****
-- nesting with window functions
select a, b, sum(c), sum(sum(c)) over (order by a,b) as rsum
from gstest2 group by rollup (a,b) order by rsum, a, b;
! a | b | sum | rsum
! ---+---+-----+------
! 1 | 1 | 8 | 8
! 1 | 2 | 2 | 10
! 1 | | 10 | 20
! 2 | 2 | 2 | 22
! 2 | | 2 | 24
! | | 12 | 36
(6 rows)
-- nesting with grouping sets
--- 143,156 ----
-- nesting with window functions
select a, b, sum(c), sum(sum(c)) over (order by a,b) as rsum
from gstest2 group by rollup (a,b) order by rsum, a, b;
! a | b | sum | rsum
! ---+---+-----+--------------------------------
! 1 | 1 | 8 | 0
! 1 | 2 | 2 | 79506866991776385725089447936
! 1 | | 10 | 159013733983552771450178895872
! 2 | 2 | 2 | 238520600975329157175268343808
! 2 | | 2 | 318027467967105542900357791744
! | | 12 | 397534334958881928625447239680
(6 rows)
-- nesting with grouping sets
***************
*** 544,559 ****
select a, b, sum(c), sum(sum(c)) over (order by a,b) as rsum
from gstest2 group by cube (a,b) order by rsum, a, b;
! a | b | sum | rsum
! ---+---+-----+------
! 1 | 1 | 8 | 8
! 1 | 2 | 2 | 10
! 1 | | 10 | 20
! 2 | 2 | 2 | 22
! 2 | | 2 | 24
! | 1 | 8 | 32
! | 2 | 4 | 36
! | | 12 | 48
(8 rows)
select a, b, sum(c) from (values (1,1,10),(1,1,11),(1,2,12),(1,2,13),(1,3,14),(2,3,15),(3,3,16),(3,4,17),(4,1,18),(4,1,19)) v(a,b,c) group by rollup (a,b);
--- 544,559 ----
select a, b, sum(c), sum(sum(c)) over (order by a,b) as rsum
from gstest2 group by cube (a,b) order by rsum, a, b;
! a | b | sum | rsum
! ---+---+-----+--------------------------------
! 1 | 1 | 8 | 0
! 1 | 2 | 2 | 79523549341672933105512480768
! 1 | | 10 | 159047098683345866211024961536
! 2 | 2 | 2 | 238570648025018799316537442304
! 2 | | 2 | 318094197366691732422049923072
! | 1 | 8 | 397617746708364665527562403840
! | 2 | 4 | 477141296050037598633074884608
! | | 12 | 556664845391710531738587365376
(8 rows)
select a, b, sum(c) from (values (1,1,10),(1,1,11),(1,2,12),(1,2,13),(1,3,14),(2,3,15),(3,3,16),(3,4,17),(4,1,18),(4,1,19)) v(a,b,c) group by rollup (a,b);
***************
*** 1219,1234 ****
select a, b, sum(c), sum(sum(c)) over (order by a,b) as rsum
from gstest2 group by cube (a,b) order by rsum, a, b;
! a | b | sum | rsum
! ---+---+-----+------
! 1 | 1 | 8 | 8
! 1 | 2 | 2 | 10
! 1 | | 10 | 20
! 2 | 2 | 2 | 22
! 2 | | 2 | 24
! | 1 | 8 | 32
! | 2 | 4 | 36
! | | 12 | 48
(8 rows)
explain (costs off)
--- 1219,1234 ----
select a, b, sum(c), sum(sum(c)) over (order by a,b) as rsum
from gstest2 group by cube (a,b) order by rsum, a, b;
! a | b | sum | rsum
! ---+---+-----+--------------------------------
! 1 | 1 | 8 | 0
! 1 | 2 | 2 | 79525973686566076309624061952
! 1 | | 10 | 159051947373132152619248123904
! 2 | 2 | 2 | 238577921059698228928872185856
! 2 | | 2 | 318103894746264305238496247808
! | 1 | 8 | 397629868432830381548120309760
! | 2 | 4 | 477155842119396457857744371712
! | | 12 | 556681815805962534167368433664
(8 rows)
explain (costs off)
======================================================================
*** /home/buildfarm/mpolyakova/postgresql_master/src/test/regress/expected/tsrf.out Thu Jan 11 19:37:51 2018
--- /home/buildfarm/mpolyakova/postgresql_master/src/test/regress/results/tsrf.out Thu Jan 11 20:11:37 2018
***************
*** 251,259 ****
SELECT SUM(count(*)) OVER(PARTITION BY generate_series(1,3) ORDER BY generate_series(1,3)), generate_series(1,3) g FROM few GROUP BY g;
sum | g
-----+---
! 3 | 1
! 3 | 2
! 3 | 3
(3 rows)
-- sorting + grouping
--- 251,259 ----
SELECT SUM(count(*)) OVER(PARTITION BY generate_series(1,3) ORDER BY generate_series(1,3)), generate_series(1,3) g FROM few GROUP BY g;
sum | g
-----+---
! 0 | 1
! 0 | 2
! 0 | 3
(3 rows)
-- sorting + grouping
======================================================================
*** /home/buildfarm/mpolyakova/postgresql_master/src/test/regress/expected/select_parallel.out Thu Jan 11 19:37:51 2018
--- /home/buildfarm/mpolyakova/postgresql_master/src/test/regress/results/select_parallel.out Thu Jan 11 20:12:08 2018
***************
*** 722,730 ****
(5 rows)
select avg(unique1::int8) from tenk1;
! avg
! -----------------------
! 4999.5000000000000000
(1 row)
-- gather merge test with a LIMIT
--- 722,730 ----
(5 rows)
select avg(unique1::int8) from tenk1;
! avg
! -------------------------------
! 79303822316963263408196849290
(1 row)
-- gather merge test with a LIMIT
======================================================================
*** /home/buildfarm/mpolyakova/postgresql_master/src/test/regress/expected/window.out Thu Jan 11 19:37:51 2018
--- /home/buildfarm/mpolyakova/postgresql_master/src/test/regress/results/window.out Thu Jan 11 20:12:21 2018
***************
*** 51,78 ****
-- with GROUP BY
SELECT four, ten, SUM(SUM(four)) OVER (PARTITION BY four), AVG(ten) FROM tenk1
GROUP BY four, ten ORDER BY four, ten;
! four | ten | sum | avg
! ------+-----+------+------------------------
! 0 | 0 | 0 | 0.00000000000000000000
! 0 | 2 | 0 | 2.0000000000000000
! 0 | 4 | 0 | 4.0000000000000000
! 0 | 6 | 0 | 6.0000000000000000
! 0 | 8 | 0 | 8.0000000000000000
! 1 | 1 | 2500 | 1.00000000000000000000
! 1 | 3 | 2500 | 3.0000000000000000
! 1 | 5 | 2500 | 5.0000000000000000
! 1 | 7 | 2500 | 7.0000000000000000
! 1 | 9 | 2500 | 9.0000000000000000
! 2 | 0 | 5000 | 0.00000000000000000000
! 2 | 2 | 5000 | 2.0000000000000000
! 2 | 4 | 5000 | 4.0000000000000000
! 2 | 6 | 5000 | 6.0000000000000000
! 2 | 8 | 5000 | 8.0000000000000000
! 3 | 1 | 7500 | 1.00000000000000000000
! 3 | 3 | 7500 | 3.0000000000000000
! 3 | 5 | 7500 | 5.0000000000000000
! 3 | 7 | 7500 | 7.0000000000000000
! 3 | 9 | 7500 | 9.0000000000000000
(20 rows)
SELECT depname, empno, salary, sum(salary) OVER w FROM empsalary WINDOW w AS (PARTITION BY depname);
--- 51,78 ----
-- with GROUP BY
SELECT four, ten, SUM(SUM(four)) OVER (PARTITION BY four), AVG(ten) FROM tenk1
GROUP BY four, ten ORDER BY four, ten;
! four | ten | sum | avg
! ------+-----+--------------------------------+------------------------
! 0 | 0 | 318029156213123168798521688064 | 0.00000000000000000000
! 0 | 2 | 318029156213123168798521688064 | 2.0000000000000000
! 0 | 4 | 318029156213123168798521688064 | 4.0000000000000000
! 0 | 6 | 318029156213123168798521688064 | 6.0000000000000000
! 0 | 8 | 318029156213123168798521688064 | 8.0000000000000000
! 1 | 1 | 318029156213123168798521688064 | 1.00000000000000000000
! 1 | 3 | 318029156213123168798521688064 | 3.0000000000000000
! 1 | 5 | 318029156213123168798521688064 | 5.0000000000000000
! 1 | 7 | 318029156213123168798521688064 | 7.0000000000000000
! 1 | 9 | 318029156213123168798521688064 | 9.0000000000000000
! 2 | 0 | 318029156213123168798521688064 | 0.00000000000000000000
! 2 | 2 | 318029156213123168798521688064 | 2.0000000000000000
! 2 | 4 | 318029156213123168798521688064 | 4.0000000000000000
! 2 | 6 | 318029156213123168798521688064 | 6.0000000000000000
! 2 | 8 | 318029156213123168798521688064 | 8.0000000000000000
! 3 | 1 | 318029156213123168798521688064 | 1.00000000000000000000
! 3 | 3 | 318029156213123168798521688064 | 3.0000000000000000
! 3 | 5 | 318029156213123168798521688064 | 5.0000000000000000
! 3 | 7 | 318029156213123168798521688064 | 7.0000000000000000
! 3 | 9 | 318029156213123168798521688064 | 9.0000000000000000
(20 rows)
SELECT depname, empno, salary, sum(salary) OVER w FROM empsalary WINDOW w AS (PARTITION BY depname);
***************
*** 411,428 ****
SELECT ten, two, sum(hundred) AS gsum, sum(sum(hundred)) OVER (PARTITION BY two ORDER BY ten) AS wsum
FROM tenk1 GROUP BY ten, two;
! ten | two | gsum | wsum
! -----+-----+-------+--------
! 0 | 0 | 45000 | 45000
! 2 | 0 | 47000 | 92000
! 4 | 0 | 49000 | 141000
! 6 | 0 | 51000 | 192000
! 8 | 0 | 53000 | 245000
! 1 | 1 | 46000 | 46000
! 3 | 1 | 48000 | 94000
! 5 | 1 | 50000 | 144000
! 7 | 1 | 52000 | 196000
! 9 | 1 | 54000 | 250000
(10 rows)
SELECT count(*) OVER (PARTITION BY four), four FROM (SELECT * FROM tenk1 WHERE two = 1)s WHERE unique2 < 10;
--- 411,428 ----
SELECT ten, two, sum(hundred) AS gsum, sum(sum(hundred)) OVER (PARTITION BY two ORDER BY ten) AS wsum
FROM tenk1 GROUP BY ten, two;
! ten | two | gsum | wsum
! -----+-----+-------+--------------------------------
! 0 | 0 | 45000 | 0
! 2 | 0 | 47000 | 79507275771625059128753258496
! 4 | 0 | 49000 | 159014551543250118257506516992
! 6 | 0 | 51000 | 238521827314875177386259775488
! 8 | 0 | 53000 | 318029103086500236515013033984
! 1 | 1 | 46000 | 0
! 3 | 1 | 48000 | 79507275771625059128753258496
! 5 | 1 | 50000 | 159014551543250118257506516992
! 7 | 1 | 52000 | 238521827314875177386259775488
! 9 | 1 | 54000 | 318029103086500236515013033984
(10 rows)
SELECT count(*) OVER (PARTITION BY four), four FROM (SELECT * FROM tenk1 WHERE two = 1)s WHERE unique2 < 10;
***************
*** 483,500 ****
SELECT ten, two, sum(hundred) AS gsum, sum(sum(hundred)) OVER win AS wsum
FROM tenk1 GROUP BY ten, two WINDOW win AS (PARTITION BY two ORDER BY ten);
! ten | two | gsum | wsum
! -----+-----+-------+--------
! 0 | 0 | 45000 | 45000
! 2 | 0 | 47000 | 92000
! 4 | 0 | 49000 | 141000
! 6 | 0 | 51000 | 192000
! 8 | 0 | 53000 | 245000
! 1 | 1 | 46000 | 46000
! 3 | 1 | 48000 | 94000
! 5 | 1 | 50000 | 144000
! 7 | 1 | 52000 | 196000
! 9 | 1 | 54000 | 250000
(10 rows)
-- more than one window with GROUP BY
--- 483,500 ----
SELECT ten, two, sum(hundred) AS gsum, sum(sum(hundred)) OVER win AS wsum
FROM tenk1 GROUP BY ten, two WINDOW win AS (PARTITION BY two ORDER BY ten);
! ten | two | gsum | wsum
! -----+-----+-------+--------------------------------
! 0 | 0 | 45000 | 0
! 2 | 0 | 47000 | 79507275771625059128753258496
! 4 | 0 | 49000 | 159014551543250118257506516992
! 6 | 0 | 51000 | 238521827314875177386259775488
! 8 | 0 | 53000 | 318029103086500236515013033984
! 1 | 1 | 46000 | 0
! 3 | 1 | 48000 | 79507275771625059128753258496
! 5 | 1 | 50000 | 159014551543250118257506516992
! 7 | 1 | 52000 | 238521827314875177386259775488
! 9 | 1 | 54000 | 318029103086500236515013033984
(10 rows)
-- more than one window with GROUP BY
***************
*** 502,512 ****
row_number() OVER (ORDER BY depname),
sum(sum(salary)) OVER (ORDER BY depname DESC)
FROM empsalary GROUP BY depname;
! sum | row_number | sum
! -------+------------+-------
! 14600 | 3 | 14600
! 7400 | 2 | 22000
! 25100 | 1 | 47100
(3 rows)
-- identical windows with different names
--- 502,512 ----
row_number() OVER (ORDER BY depname),
sum(sum(salary)) OVER (ORDER BY depname DESC)
FROM empsalary GROUP BY depname;
! sum | row_number | sum
! -------+------------+--------------------------------
! 14600 | 3 | 0
! 7400 | 2 | 79507275771625059128753258496
! 25100 | 1 | 159014551543250118257506516992
(3 rows)
-- identical windows with different names
***************
*** 1027,1037 ****
) FILTER (WHERE depname <> 'sales') OVER (ORDER BY depname DESC) AS "filtered_sum",
depname
FROM empsalary GROUP BY depname;
! sum | row_number | filtered_sum | depname
! -------+------------+--------------+-----------
! 14600 | 3 | | sales
! 7400 | 2 | 3500 | personnel
! 25100 | 1 | 22600 | develop
(3 rows)
-- Test pushdown of quals into a subquery containing window functions
--- 1027,1037 ----
) FILTER (WHERE depname <> 'sales') OVER (ORDER BY depname DESC) AS "filtered_sum",
depname
FROM empsalary GROUP BY depname;
! sum | row_number | filtered_sum | depname
! -------+------------+-------------------------------+-----------
! 14600 | 3 | | sales
! 7400 | 2 | 0 | personnel
! 25100 | 1 | 79507275771625059128753258496 | develop
(3 rows)
-- Test pushdown of quals into a subquery containing window functions
***************
*** 1341,1352 ****
-- test inverse transition functions handle NULLs properly
SELECT i,AVG(v::bigint) OVER (ORDER BY i ROWS BETWEEN CURRENT ROW AND UNBOUNDED FOLLOWING)
FROM (VALUES(1,1),(2,2),(3,NULL),(4,NULL)) t(i,v);
! i | avg
! ---+--------------------
! 1 | 1.5000000000000000
! 2 | 2.0000000000000000
! 3 |
! 4 |
(4 rows)
SELECT i,AVG(v::int) OVER (ORDER BY i ROWS BETWEEN CURRENT ROW AND UNBOUNDED FOLLOWING)
--- 1341,1352 ----
-- test inverse transition functions handle NULLs properly
SELECT i,AVG(v::bigint) OVER (ORDER BY i ROWS BETWEEN CURRENT ROW AND UNBOUNDED FOLLOWING)
FROM (VALUES(1,1),(2,2),(3,NULL),(4,NULL)) t(i,v);
! i | avg
! ---+-------------------------------
! 1 | 39753637885812529564376629248
! 2 | 0.00000000000000000000
! 3 |
! 4 |
(4 rows)
SELECT i,AVG(v::int) OVER (ORDER BY i ROWS BETWEEN CURRENT ROW AND UNBOUNDED FOLLOWING)
***************
*** 1411,1422 ****
SELECT i,SUM(v::bigint) OVER (ORDER BY i ROWS BETWEEN CURRENT ROW AND UNBOUNDED FOLLOWING)
FROM (VALUES(1,1),(2,2),(3,NULL),(4,NULL)) t(i,v);
! i | sum
! ---+-----
! 1 | 3
! 2 | 2
! 3 |
! 4 |
(4 rows)
SELECT i,SUM(v::money) OVER (ORDER BY i ROWS BETWEEN CURRENT ROW AND UNBOUNDED FOLLOWING)
--- 1411,1422 ----
SELECT i,SUM(v::bigint) OVER (ORDER BY i ROWS BETWEEN CURRENT ROW AND UNBOUNDED FOLLOWING)
FROM (VALUES(1,1),(2,2),(3,NULL),(4,NULL)) t(i,v);
! i | sum
! ---+-------------------------------
! 1 | 79507275771625059128753258496
! 2 | 0
! 3 |
! 4 |
(4 rows)
SELECT i,SUM(v::money) OVER (ORDER BY i ROWS BETWEEN CURRENT ROW AND UNBOUNDED FOLLOWING)
***************
*** 1491,1514 ****
SELECT VAR_POP(n::int) OVER (ORDER BY i ROWS BETWEEN CURRENT ROW AND UNBOUNDED FOLLOWING)
FROM (VALUES(1,600),(2,470),(3,170),(4,430),(5,300)) r(i,n);
! var_pop
! -----------------------
! 21704.000000000000
! 13868.750000000000
! 11266.666666666667
! 4225.0000000000000000
! 0
(5 rows)
SELECT VAR_POP(n::smallint) OVER (ORDER BY i ROWS BETWEEN CURRENT ROW AND UNBOUNDED FOLLOWING)
FROM (VALUES(1,600),(2,470),(3,170),(4,430),(5,300)) r(i,n);
! var_pop
! -----------------------
! 21704.000000000000
! 13868.750000000000
! 11266.666666666667
! 4225.0000000000000000
! 0
(5 rows)
SELECT VAR_POP(n::numeric) OVER (ORDER BY i ROWS BETWEEN CURRENT ROW AND UNBOUNDED FOLLOWING)
--- 1491,1514 ----
SELECT VAR_POP(n::int) OVER (ORDER BY i ROWS BETWEEN CURRENT ROW AND UNBOUNDED FOLLOWING)
FROM (VALUES(1,600),(2,470),(3,170),(4,430),(5,300)) r(i,n);
! var_pop
! ---------
! 0
! 0
! 0
! 0
! 0
(5 rows)
SELECT VAR_POP(n::smallint) OVER (ORDER BY i ROWS BETWEEN CURRENT ROW AND UNBOUNDED FOLLOWING)
FROM (VALUES(1,600),(2,470),(3,170),(4,430),(5,300)) r(i,n);
! var_pop
! ---------
! 0
! 0
! 0
! 0
! 0
(5 rows)
SELECT VAR_POP(n::numeric) OVER (ORDER BY i ROWS BETWEEN CURRENT ROW AND UNBOUNDED FOLLOWING)
***************
*** 1535,1558 ****
SELECT VAR_SAMP(n::int) OVER (ORDER BY i ROWS BETWEEN CURRENT ROW AND UNBOUNDED FOLLOWING)
FROM (VALUES(1,600),(2,470),(3,170),(4,430),(5,300)) r(i,n);
! var_samp
! -----------------------
! 27130.000000000000
! 18491.666666666667
! 16900.000000000000
! 8450.0000000000000000
!
(5 rows)
SELECT VAR_SAMP(n::smallint) OVER (ORDER BY i ROWS BETWEEN CURRENT ROW AND UNBOUNDED FOLLOWING)
FROM (VALUES(1,600),(2,470),(3,170),(4,430),(5,300)) r(i,n);
! var_samp
! -----------------------
! 27130.000000000000
! 18491.666666666667
! 16900.000000000000
! 8450.0000000000000000
!
(5 rows)
SELECT VAR_SAMP(n::numeric) OVER (ORDER BY i ROWS BETWEEN CURRENT ROW AND UNBOUNDED FOLLOWING)
--- 1535,1558 ----
SELECT VAR_SAMP(n::int) OVER (ORDER BY i ROWS BETWEEN CURRENT ROW AND UNBOUNDED FOLLOWING)
FROM (VALUES(1,600),(2,470),(3,170),(4,430),(5,300)) r(i,n);
! var_samp
! ----------
! 0
! 0
! 0
! 0
!
(5 rows)
SELECT VAR_SAMP(n::smallint) OVER (ORDER BY i ROWS BETWEEN CURRENT ROW AND UNBOUNDED FOLLOWING)
FROM (VALUES(1,600),(2,470),(3,170),(4,430),(5,300)) r(i,n);
! var_samp
! ----------
! 0
! 0
! 0
! 0
!
(5 rows)
SELECT VAR_SAMP(n::numeric) OVER (ORDER BY i ROWS BETWEEN CURRENT ROW AND UNBOUNDED FOLLOWING)
***************
*** 1579,1602 ****
SELECT VARIANCE(n::int) OVER (ORDER BY i ROWS BETWEEN CURRENT ROW AND UNBOUNDED FOLLOWING)
FROM (VALUES(1,600),(2,470),(3,170),(4,430),(5,300)) r(i,n);
! variance
! -----------------------
! 27130.000000000000
! 18491.666666666667
! 16900.000000000000
! 8450.0000000000000000
!
(5 rows)
SELECT VARIANCE(n::smallint) OVER (ORDER BY i ROWS BETWEEN CURRENT ROW AND UNBOUNDED FOLLOWING)
FROM (VALUES(1,600),(2,470),(3,170),(4,430),(5,300)) r(i,n);
! variance
! -----------------------
! 27130.000000000000
! 18491.666666666667
! 16900.000000000000
! 8450.0000000000000000
!
(5 rows)
SELECT VARIANCE(n::numeric) OVER (ORDER BY i ROWS BETWEEN CURRENT ROW AND UNBOUNDED FOLLOWING)
--- 1579,1602 ----
SELECT VARIANCE(n::int) OVER (ORDER BY i ROWS BETWEEN CURRENT ROW AND UNBOUNDED FOLLOWING)
FROM (VALUES(1,600),(2,470),(3,170),(4,430),(5,300)) r(i,n);
! variance
! ----------
! 0
! 0
! 0
! 0
!
(5 rows)
SELECT VARIANCE(n::smallint) OVER (ORDER BY i ROWS BETWEEN CURRENT ROW AND UNBOUNDED FOLLOWING)
FROM (VALUES(1,600),(2,470),(3,170),(4,430),(5,300)) r(i,n);
! variance
! ----------
! 0
! 0
! 0
! 0
!
(5 rows)
SELECT VARIANCE(n::numeric) OVER (ORDER BY i ROWS BETWEEN CURRENT ROW AND UNBOUNDED FOLLOWING)
***************
*** 1624,1649 ****
SELECT STDDEV_POP(n::int) OVER (ORDER BY i ROWS BETWEEN CURRENT ROW AND UNBOUNDED FOLLOWING)
FROM (VALUES(1,NULL),(2,600),(3,470),(4,170),(5,430),(6,300)) r(i,n);
! stddev_pop
! ---------------------
! 147.322774885623
! 147.322774885623
! 117.765657133139
! 106.144555520604
! 65.0000000000000000
! 0
(6 rows)
SELECT STDDEV_POP(n::smallint) OVER (ORDER BY i ROWS BETWEEN CURRENT ROW AND UNBOUNDED FOLLOWING)
FROM (VALUES(1,NULL),(2,600),(3,470),(4,170),(5,430),(6,300)) r(i,n);
! stddev_pop
! ---------------------
! 147.322774885623
! 147.322774885623
! 117.765657133139
! 106.144555520604
! 65.0000000000000000
! 0
(6 rows)
SELECT STDDEV_POP(n::numeric) OVER (ORDER BY i ROWS BETWEEN CURRENT ROW AND UNBOUNDED FOLLOWING)
--- 1624,1649 ----
SELECT STDDEV_POP(n::int) OVER (ORDER BY i ROWS BETWEEN CURRENT ROW AND UNBOUNDED FOLLOWING)
FROM (VALUES(1,NULL),(2,600),(3,470),(4,170),(5,430),(6,300)) r(i,n);
! stddev_pop
! ------------
! 0
! 0
! 0
! 0
! 0
! 0
(6 rows)
SELECT STDDEV_POP(n::smallint) OVER (ORDER BY i ROWS BETWEEN CURRENT ROW AND UNBOUNDED FOLLOWING)
FROM (VALUES(1,NULL),(2,600),(3,470),(4,170),(5,430),(6,300)) r(i,n);
! stddev_pop
! ------------
! 0
! 0
! 0
! 0
! 0
! 0
(6 rows)
SELECT STDDEV_POP(n::numeric) OVER (ORDER BY i ROWS BETWEEN CURRENT ROW AND UNBOUNDED FOLLOWING)
***************
*** 1672,1697 ****
SELECT STDDEV_SAMP(n::int) OVER (ORDER BY i ROWS BETWEEN CURRENT ROW AND UNBOUNDED FOLLOWING)
FROM (VALUES(1,NULL),(2,600),(3,470),(4,170),(5,430),(6,300)) r(i,n);
! stddev_samp
! ---------------------
! 164.711869639076
! 164.711869639076
! 135.984067694222
! 130.000000000000
! 91.9238815542511782
!
(6 rows)
SELECT STDDEV_SAMP(n::smallint) OVER (ORDER BY i ROWS BETWEEN CURRENT ROW AND UNBOUNDED FOLLOWING)
FROM (VALUES(1,NULL),(2,600),(3,470),(4,170),(5,430),(6,300)) r(i,n);
! stddev_samp
! ---------------------
! 164.711869639076
! 164.711869639076
! 135.984067694222
! 130.000000000000
! 91.9238815542511782
!
(6 rows)
SELECT STDDEV_SAMP(n::numeric) OVER (ORDER BY i ROWS BETWEEN CURRENT ROW AND UNBOUNDED FOLLOWING)
--- 1672,1697 ----
SELECT STDDEV_SAMP(n::int) OVER (ORDER BY i ROWS BETWEEN CURRENT ROW AND UNBOUNDED FOLLOWING)
FROM (VALUES(1,NULL),(2,600),(3,470),(4,170),(5,430),(6,300)) r(i,n);
! stddev_samp
! -------------
! 0
! 0
! 0
! 0
! 0
!
(6 rows)
SELECT STDDEV_SAMP(n::smallint) OVER (ORDER BY i ROWS BETWEEN CURRENT ROW AND UNBOUNDED FOLLOWING)
FROM (VALUES(1,NULL),(2,600),(3,470),(4,170),(5,430),(6,300)) r(i,n);
! stddev_samp
! -------------
! 0
! 0
! 0
! 0
! 0
!
(6 rows)
SELECT STDDEV_SAMP(n::numeric) OVER (ORDER BY i ROWS BETWEEN CURRENT ROW AND UNBOUNDED FOLLOWING)
***************
*** 1720,1745 ****
SELECT STDDEV(n::int) OVER (ORDER BY i ROWS BETWEEN CURRENT ROW AND UNBOUNDED FOLLOWING)
FROM (VALUES(0,NULL),(1,600),(2,470),(3,170),(4,430),(5,300)) r(i,n);
! stddev
! ---------------------
! 164.711869639076
! 164.711869639076
! 135.984067694222
! 130.000000000000
! 91.9238815542511782
!
(6 rows)
SELECT STDDEV(n::smallint) OVER (ORDER BY i ROWS BETWEEN CURRENT ROW AND UNBOUNDED FOLLOWING)
FROM (VALUES(0,NULL),(1,600),(2,470),(3,170),(4,430),(5,300)) r(i,n);
! stddev
! ---------------------
! 164.711869639076
! 164.711869639076
! 135.984067694222
! 130.000000000000
! 91.9238815542511782
!
(6 rows)
SELECT STDDEV(n::numeric) OVER (ORDER BY i ROWS BETWEEN CURRENT ROW AND UNBOUNDED FOLLOWING)
--- 1720,1745 ----
SELECT STDDEV(n::int) OVER (ORDER BY i ROWS BETWEEN CURRENT ROW AND UNBOUNDED FOLLOWING)
FROM (VALUES(0,NULL),(1,600),(2,470),(3,170),(4,430),(5,300)) r(i,n);
! stddev
! --------
! 0
! 0
! 0
! 0
! 0
!
(6 rows)
SELECT STDDEV(n::smallint) OVER (ORDER BY i ROWS BETWEEN CURRENT ROW AND UNBOUNDED FOLLOWING)
FROM (VALUES(0,NULL),(1,600),(2,470),(3,170),(4,430),(5,300)) r(i,n);
! stddev
! --------
! 0
! 0
! 0
! 0
! 0
!
(6 rows)
SELECT STDDEV(n::numeric) OVER (ORDER BY i ROWS BETWEEN CURRENT ROW AND UNBOUNDED FOLLOWING)
======================================================================
*** /home/buildfarm/mpolyakova/postgresql_master/src/test/regress/expected/with.out Thu Jan 11 19:37:51 2018
--- /home/buildfarm/mpolyakova/postgresql_master/src/test/regress/results/with.out Thu Jan 11 20:12:39 2018
***************
*** 285,291 ****
SELECT count(*) FROM q1 WHERE y > (SELECT sum(y)/100 FROM q1 qsub);
count
-------
! 50
(1 row)
-- via a VIEW
--- 285,291 ----
SELECT count(*) FROM q1 WHERE y > (SELECT sum(y)/100 FROM q1 qsub);
count
-------
! 0
(1 row)
-- via a VIEW
======================================================================
*** /home/buildfarm/mpolyakova/postgresql_master/src/test/regress/expected/stats.out Thu Jan 11 19:37:51 2018
--- /home/buildfarm/mpolyakova/postgresql_master/src/test/regress/results/stats.out Thu Jan 11 20:13:07 2018
***************
*** 25,30 ****
--- 25,31 ----
FROM pg_catalog.pg_stat_user_tables AS t,
pg_catalog.pg_statio_user_tables AS b
WHERE t.relname='tenk2' AND b.relname='tenk2';
+ ERROR: bigint out of range
-- function to wait for counters to advance
create function wait_for_stats() returns void as $$
declare
***************
*** 154,164 ****
\c -
-- wait for stats collector to update
SELECT wait_for_stats();
! wait_for_stats
! ----------------
!
! (1 row)
!
-- check effects
SELECT relname, n_tup_ins, n_tup_upd, n_tup_del, n_live_tup, n_dead_tup
FROM pg_stat_user_tables
--- 155,166 ----
\c -
-- wait for stats collector to update
SELECT wait_for_stats();
! ERROR: relation "prevstats" does not exist
! LINE 1: ... FROM pg_stat_user_tables AS st, pg_class AS cl, prevstats ...
! ^
! QUERY: SELECT (st.seq_scan >= pr.seq_scan + 1) FROM pg_stat_user_tables AS st, pg_class AS cl, prevstats AS pr
! WHERE st.relname='tenk2' AND cl.relname='tenk2'
! CONTEXT: PL/pgSQL function wait_for_stats() line 18 at SQL statement
-- check effects
SELECT relname, n_tup_ins, n_tup_upd, n_tup_del, n_live_tup, n_dead_tup
FROM pg_stat_user_tables
***************
*** 165,175 ****
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,
--- 167,177 ----
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,
***************
*** 178,204 ****
st.idx_tup_fetch >= pr.idx_tup_fetch + 1
FROM pg_stat_user_tables AS st, pg_class AS cl, prevstats AS pr
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,
st.idx_blks_read + st.idx_blks_hit >= pr.idx_blks + 1
FROM pg_statio_user_tables AS st, pg_class AS cl, prevstats AS pr
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;
DROP TABLE prevstats;
-- End of Stats Test
--- 180,201 ----
st.idx_tup_fetch >= pr.idx_tup_fetch + 1
FROM pg_stat_user_tables AS st, pg_class AS cl, prevstats AS pr
WHERE st.relname='tenk2' AND cl.relname='tenk2';
! ERROR: relation "prevstats" does not exist
! LINE 5: FROM pg_stat_user_tables AS st, pg_class AS cl, prevstats ...
! ^
SELECT st.heap_blks_read + st.heap_blks_hit >= pr.heap_blks + cl.relpages,
st.idx_blks_read + st.idx_blks_hit >= pr.idx_blks + 1
FROM pg_statio_user_tables AS st, pg_class AS cl, prevstats AS pr
WHERE st.relname='tenk2' AND cl.relname='tenk2';
! ERROR: relation "prevstats" does not exist
! LINE 3: ...FROM pg_statio_user_tables AS st, pg_class AS cl, prevstats ...
! ^
SELECT pr.snap_ts < pg_stat_get_snapshot_timestamp() as snapshot_newer
FROM prevstats AS pr;
! ERROR: relation "prevstats" does not exist
! LINE 2: FROM prevstats AS pr;
! ^
DROP TABLE trunc_stats_test, trunc_stats_test1, trunc_stats_test2, trunc_stats_test3, trunc_stats_test4;
DROP TABLE prevstats;
+ ERROR: table "prevstats" does not exist
-- End of Stats Test
======================================================================
test tablespace ... ok
parallel group (20 tests): oid float4 float8 varchar text int2 name char
boolean bit txid int4 int8 money uuid regproc pg_lsn enum numeric rangetypes
boolean ... ok
char ... ok
name ... ok
varchar ... ok
text ... ok
int2 ... ok
int4 ... ok
int8 ... ok
oid ... ok
float4 ... ok
float8 ... ok
bit ... ok
numeric ... ok
txid ... ok
uuid ... ok
enum ... ok
money ... ok
rangetypes ... ok
pg_lsn ... ok
regproc ... ok
test strings ... ok
test numerology ... ok
parallel group (20 tests): date time circle path line point lseg timetz
abstime macaddr reltime tinterval macaddr8 inet interval timestamp tstypes
timestamptz box polygon
point ... ok
lseg ... ok
line ... ok
box ... ok
path ... ok
polygon ... ok
circle ... ok
date ... ok
time ... ok
timetz ... ok
timestamp ... ok
timestamptz ... ok
interval ... ok
abstime ... ok
reltime ... ok
tinterval ... ok
inet ... ok
macaddr ... ok
macaddr8 ... ok
tstypes ... ok
parallel group (9 tests): geometry expressions comments misc_sanity horology
type_sanity oidjoins opr_sanity regex
geometry ... ok
horology ... ok
regex ... ok
oidjoins ... ok
type_sanity ... ok
opr_sanity ... ok
misc_sanity ... ok
comments ... ok
expressions ... ok
test insert ... ok
test insert_conflict ... ok
test create_function_1 ... ok
test create_type ... ok
test create_table ... ok
test create_function_2 ... ok
parallel group (3 tests): copyselect copydml copy
copy ... ok
copyselect ... ok
copydml ... ok
parallel group (3 tests): create_operator create_procedure create_misc
create_misc ... ok
create_operator ... ok
create_procedure ... ok
parallel group (2 tests): create_view create_index
create_index ... ok
create_view ... ok
parallel group (15 tests): create_function_3 create_cast create_aggregate
roleattributes hash_func drop_if_exists typed_table create_am constraints
rolenames vacuum create_table_like inherit updatable_views triggers
create_aggregate ... ok
create_function_3 ... ok
create_cast ... ok
constraints ... ok
triggers ... ok
inherit ... ok
create_table_like ... ok
typed_table ... ok
vacuum ... ok
drop_if_exists ... ok
updatable_views ... ok
rolenames ... ok
roleattributes ... ok
create_am ... ok
hash_func ... ok
test sanity_check ... ok
test errors ... ok
test select ... ok
parallel group (20 tests): random select_into case select_having
select_distinct select_implicit select_distinct_on delete namespace btree_index
prepared_xacts transactions portals union subselect update arrays aggregates
hash_index join
select_into ... ok
select_distinct ... ok
select_distinct_on ... ok
select_implicit ... ok
select_having ... ok
subselect ... ok
union ... ok
case ... ok
join ... ok
aggregates ... ok
transactions ... ok
random ... failed (ignored)
portals ... ok
arrays ... ok
btree_index ... ok
hash_index ... ok
update ... ok
namespace ... ok
prepared_xacts ... ok
delete ... ok
parallel group (17 tests): init_privs security_label lock drop_operator
password tablesample replica_identity object_address groupingsets collate
privileges matview brin spgist gin rowsecurity gist
brin ... ok
gin ... ok
gist ... ok
spgist ... ok
privileges ... ok
init_privs ... ok
security_label ... ok
collate ... ok
matview ... ok
lock ... ok
replica_identity ... ok
rowsecurity ... ok
object_address ... ok
tablesample ... ok
groupingsets ... FAILED
drop_operator ... ok
password ... ok
parallel group (11 tests): psql dbsize misc_functions async alter_operator
tidscan alter_generic tsrf sysviews misc stats_ext
alter_generic ... ok
alter_operator ... ok
misc ... ok
psql ... ok
async ... ok
dbsize ... ok
misc_functions ... ok
sysviews ... ok
tsrf ... FAILED
tidscan ... ok
stats_ext ... ok
parallel group (3 tests): amutils psql_crosstab rules
rules ... ok
psql_crosstab ... ok
amutils ... ok
test select_parallel ... FAILED
test write_parallel ... ok
parallel group (2 tests): subscription publication
publication ... ok
subscription ... ok
parallel group (20 tests): select_views xmlmap advisory_lock guc dependency
tsdicts combocid portals_p2 json_encoding functional_deps equivclass tsearch
json window cluster jsonb bitmapops indirect_toast foreign_key foreign_data
select_views ... ok
portals_p2 ... ok
foreign_key ... ok
cluster ... ok
dependency ... ok
guc ... ok
bitmapops ... ok
combocid ... ok
tsearch ... ok
tsdicts ... ok
foreign_data ... ok
window ... FAILED
xmlmap ... ok
functional_deps ... ok
advisory_lock ... ok
json ... ok
jsonb ... ok
json_encoding ... ok
indirect_toast ... ok
equivclass ... ok
parallel group (19 tests): temp prepare plancache conversion limit without_oid
returning copy2 truncate rangefuncs polymorphism with rowtypes sequence domain
largeobject xml alter_table plpgsql
plancache ... ok
limit ... ok
plpgsql ... ok
copy2 ... ok
temp ... ok
domain ... ok
rangefuncs ... ok
prepare ... ok
without_oid ... ok
conversion ... ok
truncate ... ok
alter_table ... ok
sequence ... ok
polymorphism ... ok
rowtypes ... ok
returning ... ok
largeobject ... ok
with ... FAILED
xml ... ok
parallel group (5 tests): hash_part reloptions identity partition_prune
partition_join
identity ... ok
partition_join ... ok
partition_prune ... ok
reloptions ... ok
hash_part ... ok
test event_trigger ... ok
test stats ... FAILED
