On 11-01-2018 20:39, Andres Freund wrote:
Hi,
On 2018-01-11 20:21:11 +0300, Marina Polyakova wrote:
Hello, hackers! I got a permanent failure of master (commit
ca454b9bd34c75995eda4d07c9858f7c22890c2b) make check on Solaris 10.
Did this use to work?
It always fails if you have asked about this..
If so, could you check whether it worked before
69c3936a1499b772a749ae629fc59b2d72722332?
- on the previous commit (272c2ab9fd0a604e3200030b1ea26fd464c44935) the
same failures occur (see the attached regression diffs and output);
- on commit bf54c0f05c0a58db17627724a83e1b6d4ec2712c make check-world
passes.
I'll try to find out from what commit it started.. Don't you have any
suspicions?)
--
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 Fri Jan 12 12:37:28 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
! -------------------------------
! 59630855721112644241909088256
! (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 Fri Jan 12 12:38:07 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 | 79489175236044124958001987584
! 1 | | 10 | 158978350472088249916003975168
! 2 | 2 | 2 | 238467525708132374874005962752
! 2 | | 2 | 317956700944176499832007950336
! | | 12 | 397445876180220624790009937920
(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 | 79523211102173597567174049792
! 1 | | 10 | 159046422204347195134348099584
! 2 | 2 | 2 | 238569633306520792701522149376
! 2 | | 2 | 318092844408694390268696199168
! | 1 | 8 | 397616055510867987835870248960
! | 2 | 4 | 477139266613041585403044298752
! | | 12 | 556662477715215182970218348544
(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 | 79526240205124453265225809920
! 1 | | 10 | 159052480410248906530451619840
! 2 | 2 | 2 | 238578720615373359795677429760
! 2 | | 2 | 318104960820497813060903239680
! | 1 | 8 | 397631201025622266326129049600
! | 2 | 4 | 477157441230746719591354859520
! | | 12 | 556683681435871172856580669440
(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 Fri Jan 12 12:38:28 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 Fri Jan 12 12:39:00 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
! -------------------------------
! 79499661626572135089033082149
(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 Fri Jan 12 12:39:09 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 | 318028861065217989445695832064 | 0.00000000000000000000
! 0 | 2 | 318028861065217989445695832064 | 2.0000000000000000
! 0 | 4 | 318028861065217989445695832064 | 4.0000000000000000
! 0 | 6 | 318028861065217989445695832064 | 6.0000000000000000
! 0 | 8 | 318028861065217989445695832064 | 8.0000000000000000
! 1 | 1 | 318028861065217989445695832064 | 1.00000000000000000000
! 1 | 3 | 318028861065217989445695832064 | 3.0000000000000000
! 1 | 5 | 318028861065217989445695832064 | 5.0000000000000000
! 1 | 7 | 318028861065217989445695832064 | 7.0000000000000000
! 1 | 9 | 318028861065217989445695832064 | 9.0000000000000000
! 2 | 0 | 318028861065217989445695832064 | 0.00000000000000000000
! 2 | 2 | 318028861065217989445695832064 | 2.0000000000000000
! 2 | 4 | 318028861065217989445695832064 | 4.0000000000000000
! 2 | 6 | 318028861065217989445695832064 | 6.0000000000000000
! 2 | 8 | 318028861065217989445695832064 | 8.0000000000000000
! 3 | 1 | 318028861065217989445695832064 | 1.00000000000000000000
! 3 | 3 | 318028861065217989445695832064 | 3.0000000000000000
! 3 | 5 | 318028861065217989445695832064 | 5.0000000000000000
! 3 | 7 | 318028861065217989445695832064 | 7.0000000000000000
! 3 | 9 | 318028861065217989445695832064 | 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 | 79507201984648764290546794496
! 4 | 0 | 49000 | 159014403969297528581093588992
! 6 | 0 | 51000 | 238521605953946292871640383488
! 8 | 0 | 53000 | 318028807938595057162187177984
! 1 | 1 | 46000 | 0
! 3 | 1 | 48000 | 79507201984648764290546794496
! 5 | 1 | 50000 | 159014403969297528581093588992
! 7 | 1 | 52000 | 238521605953946292871640383488
! 9 | 1 | 54000 | 318028807938595057162187177984
(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 | 79507201984648764290546794496
! 4 | 0 | 49000 | 159014403969297528581093588992
! 6 | 0 | 51000 | 238521605953946292871640383488
! 8 | 0 | 53000 | 318028807938595057162187177984
! 1 | 1 | 46000 | 0
! 3 | 1 | 48000 | 79507201984648764290546794496
! 5 | 1 | 50000 | 159014403969297528581093588992
! 7 | 1 | 52000 | 238521605953946292871640383488
! 9 | 1 | 54000 | 318028807938595057162187177984
(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 | 79507201984648764290546794496
! 25100 | 1 | 159014403969297528581093588992
(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 | 79507201984648764290546794496 | 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 | 39753600992324382145273397248
! 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 | 79507201984648764290546794496
! 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 Fri Jan 12 12:39:31 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 Fri Jan 12 12:39:58 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): int4 text boolean name varchar char float4 int8 oid
int2 pg_lsn regproc float8 txid uuid money bit 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): timestamptz tinterval interval reltime abstime
timestamp date circle timetz time point path line lseg macaddr box macaddr8
inet tstypes 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 comments expressions horology misc_sanity
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): copydml copyselect 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_aggregate create_cast
drop_if_exists roleattributes hash_func 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): btree_index select_into random case select_implicit
select_having select_distinct select_distinct_on namespace delete transactions
portals prepared_xacts subselect union 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): lock security_label init_privs drop_operator
password tablesample replica_identity groupingsets object_address collate
matview privileges 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): alter_operator async dbsize misc_functions psql
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): json_encoding advisory_lock tsdicts dependency
combocid guc portals_p2 select_views xmlmap window functional_deps equivclass
tsearch json 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): conversion plancache prepare limit temp copy2
returning without_oid rowtypes truncate polymorphism sequence with rangefuncs
largeobject domain 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): reloptions hash_part 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
