master make check fails on Solaris 10

*** /home/buildfarm/mpolyakova/postgresql_master_other_config/src/test/regress/expected/random.out	Fri Jan 12 10:59:09 2018
--- /home/buildfarm/mpolyakova/postgresql_master_other_config/src/test/regress/results/random.out	Fri Jan 12 11:23:56 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_other_config/src/test/regress/expected/groupingsets.out	Fri Jan 12 10:59:08 2018
--- /home/buildfarm/mpolyakova/postgresql_master_other_config/src/test/regress/results/groupingsets.out	Fri Jan 12 11:24:35 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 |  79507068872943528402422333440
!  1 |   |  10 | 159014137745887056804844666880
!  2 | 2 |   2 | 238521206618830585207267000320
!  2 |   |   2 | 318028275491774113609689333760
!    |   |  12 | 397535344364717642012111667200
  (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 |  79523145874486552930199535616
!  1 |   |  10 | 159046291748973105860399071232
!  2 | 2 |   2 | 238569437623459658790598606848
!  2 |   |   2 | 318092583497946211720798142464
!    | 1 |   8 | 397615729372432764650997678080
!    | 2 |   4 | 477138875246919317581197213696
!    |   |  12 | 556662021121405870511396749312
  (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 |  79525570219379696134311116800
!  1 |   |  10 | 159051140438759392268622233600
!  2 | 2 |   2 | 238576710658139088402933350400
!  2 |   |   2 | 318102280877518784537244467200
!    | 1 |   8 | 397627851096898480671555584000
!    | 2 |   4 | 477153421316278176805866700800
!    |   |  12 | 556678991535657872940177817600
  (8 rows)
  
  explain (costs off)

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

*** /home/buildfarm/mpolyakova/postgresql_master_other_config/src/test/regress/expected/tsrf.out	Fri Jan 12 10:59:10 2018
--- /home/buildfarm/mpolyakova/postgresql_master_other_config/src/test/regress/results/tsrf.out	Fri Jan 12 11:24:55 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_other_config/src/test/regress/expected/select_parallel.out	Fri Jan 12 10:59:09 2018
--- /home/buildfarm/mpolyakova/postgresql_master_other_config/src/test/regress/results/select_parallel.out	Fri Jan 12 11:25:27 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              
! -------------------------------
!  79295891141614032158731083029
  (1 row)
  
  -- gather merge test with a LIMIT

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

*** /home/buildfarm/mpolyakova/postgresql_master_other_config/src/test/regress/expected/window.out	Fri Jan 12 10:59:10 2018
--- /home/buildfarm/mpolyakova/postgresql_master_other_config/src/test/regress/results/window.out	Fri Jan 12 11:25:38 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 | 318029204617379618212385128448 | 0.00000000000000000000
!     0 |   2 | 318029204617379618212385128448 |     2.0000000000000000
!     0 |   4 | 318029204617379618212385128448 |     4.0000000000000000
!     0 |   6 | 318029204617379618212385128448 |     6.0000000000000000
!     0 |   8 | 318029204617379618212385128448 |     8.0000000000000000
!     1 |   1 | 318029204617379618212385128448 | 1.00000000000000000000
!     1 |   3 | 318029204617379618212385128448 |     3.0000000000000000
!     1 |   5 | 318029204617379618212385128448 |     5.0000000000000000
!     1 |   7 | 318029204617379618212385128448 |     7.0000000000000000
!     1 |   9 | 318029204617379618212385128448 |     9.0000000000000000
!     2 |   0 | 318029204617379618212385128448 | 0.00000000000000000000
!     2 |   2 | 318029204617379618212385128448 |     2.0000000000000000
!     2 |   4 | 318029204617379618212385128448 |     4.0000000000000000
!     2 |   6 | 318029204617379618212385128448 |     6.0000000000000000
!     2 |   8 | 318029204617379618212385128448 |     8.0000000000000000
!     3 |   1 | 318029204617379618212385128448 | 1.00000000000000000000
!     3 |   3 | 318029204617379618212385128448 |     3.0000000000000000
!     3 |   5 | 318029204617379618212385128448 |     5.0000000000000000
!     3 |   7 | 318029204617379618212385128448 |     7.0000000000000000
!     3 |   9 | 318029204617379618212385128448 |     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 |  79507287872689171482219118592
!    4 |   0 | 49000 | 159014575745378342964438237184
!    6 |   0 | 51000 | 238521863618067514446657355776
!    8 |   0 | 53000 | 318029151490756685928876474368
!    1 |   1 | 46000 |                              0
!    3 |   1 | 48000 |  79507287872689171482219118592
!    5 |   1 | 50000 | 159014575745378342964438237184
!    7 |   1 | 52000 | 238521863618067514446657355776
!    9 |   1 | 54000 | 318029151490756685928876474368
  (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 |  79507287872689171482219118592
!    4 |   0 | 49000 | 159014575745378342964438237184
!    6 |   0 | 51000 | 238521863618067514446657355776
!    8 |   0 | 53000 | 318029151490756685928876474368
!    1 |   1 | 46000 |                              0
!    3 |   1 | 48000 |  79507287872689171482219118592
!    5 |   1 | 50000 | 159014575745378342964438237184
!    7 |   1 | 52000 | 238521863618067514446657355776
!    9 |   1 | 54000 | 318029151490756685928876474368
  (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 |  79507287872689171482219118592
!  25100 |          1 | 159014575745378342964438237184
  (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 | 79507287872689171482219118592 | 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 | 39753643936344585741109559296
!  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 | 79507287872689171482219118592
!  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_other_config/src/test/regress/expected/with.out	Fri Jan 12 10:59:10 2018
--- /home/buildfarm/mpolyakova/postgresql_master_other_config/src/test/regress/results/with.out	Fri Jan 12 11:25:57 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_other_config/src/test/regress/expected/stats.out	Fri Jan 12 10:59:10 2018
--- /home/buildfarm/mpolyakova/postgresql_master_other_config/src/test/regress/results/stats.out	Fri Jan 12 11:26:24 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

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

*** /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

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

diff --git a/src/backend/utils/adt/numeric.c b/src/backend/utils/adt/numeric.c
index 5b34bad..64d131f 100644
--- a/src/backend/utils/adt/numeric.c
+++ b/src/backend/utils/adt/numeric.c
@@ -3953,6 +3953,8 @@ makeInt128AggState(FunctionCallInfo fcinfo, bool calcSumX2)
 	MemoryContext agg_context;
 	MemoryContext old_context;
 
+	fprintf(stderr, "makeInt128AggState\n");
+
 	if (!AggCheckCallContext(fcinfo, &agg_context))
 		elog(ERROR, "aggregate function called in non-aggregate context");
 
@@ -3987,6 +3989,18 @@ makeInt128AggStateCurrentContext(bool calcSumX2)
 static void
 do_int128_accum(Int128AggState *state, int128 newval)
 {
+	fprintf(stderr, "do_int128_accum int128 newval as 2 x int64: %ld %ld\n",
+			(int64) (newval >> 64), (int64) newval);
+
+	fprintf(stderr, "do_int128_accum int128 newval bytes: ");
+	unsigned char* byte_array = (void *) &newval;
+	for (int index = 0; index < 16; ++index)
+		fprintf(stderr, "%02X", (unsigned)byte_array[index]);
+	fprintf(stderr, "\n");
+
+	fprintf(stderr, "do_int128_accum state %p\n", state);
+	fprintf(stderr, "do_int128_accum %p\n", &do_int128_accum);
+
 	if (state->calcSumX2)
 		state->sumX2 += newval * newval;
 
@@ -4307,10 +4321,27 @@ int8_avg_accum(PG_FUNCTION_ARGS)
 	if (state == NULL)
 		state = makePolyNumAggState(fcinfo, false);
 
+	int64 val = PG_GETARG_INT64(1);
+	fprintf(stderr, "int8_avg_accum val %ld\n", val);
+
+	int128 val_int128 = (int128) val;
+
+	fprintf(stderr, "int8_avg_accum val_int128 as 2 x int64: %ld %ld\n",
+			(int64) (val_int128 >> 64), (int64) val_int128);
+
+	fprintf(stderr, "int8_avg_accum val_int128 bytes: ");
+	unsigned char* byte_array = (void *) &val_int128;
+	for (int index = 0; index < 16; ++index)
+		fprintf(stderr, "%02X", (unsigned)byte_array[index]);
+	fprintf(stderr, "\n");
+
+	fprintf(stderr, "int8_avg_accum state %p\n", state);
+	fprintf(stderr, "int8_avg_accum %p\n", &int8_avg_accum);
+
 	if (!PG_ARGISNULL(1))
 	{
 #ifdef HAVE_INT128
-		do_int128_accum(state, (int128) PG_GETARG_INT64(1));
+		do_int128_accum(state, val_int128);
 #else
 		Numeric		newval;
 
@@ -4640,6 +4671,7 @@ numeric_poly_sum(PG_FUNCTION_ARGS)
 Datum
 numeric_poly_avg(PG_FUNCTION_ARGS)
 {
+	fprintf(stderr, "numeric_poly_avg\n");
 #ifdef HAVE_INT128
 	PolyNumAggState *state;
 	NumericVar	result;
@@ -6365,6 +6397,17 @@ int128_to_numericvar(int128 val, NumericVar *var)
 	NumericDigit *ptr;
 	int			ndigits;
 
+	fprintf(stderr, "int128_to_numericvar\n");
+
+	fprintf(stderr, "int128_to_numericvar int128 val as 2 x int64: %ld %ld\n",
+			(int64) (val >> 64), (int64) val);
+
+	fprintf(stderr, "int128_to_numericvar int128 val bytes: ");
+	unsigned char* byte_array = (void *) &val;
+	for (int index = 0; index < 16; ++index)
+		fprintf(stderr, "%02X", (unsigned)byte_array[index]);
+	fprintf(stderr, "\n");
+
 	/* int128 can require at most 39 decimal digits; add one for safety */
 	alloc_var(var, 40 / DEC_DIGITS);
 	if (val < 0)

diff --git a/config/c-compiler.m4 b/config/c-compiler.m4
index 076656c..cbfccf6 100644
*** a/config/c-compiler.m4
--- b/config/c-compiler.m4
*************** AC_DEFUN([PGAC_TYPE_128BIT_INT],
*** 108,136 ****
  [AC_CACHE_CHECK([for __int128], [pgac_cv__128bit_int],
  [AC_LINK_IFELSE([AC_LANG_PROGRAM([
  /*
   * These are globals to discourage the compiler from folding all the
   * arithmetic tests down to compile-time constants.  We do not have
!  * convenient support for 64bit literals at this point...
   */
  __int128 a = 48828125;
! __int128 b = 97656255;
  ],[
  __int128 c,d;
  a = (a << 12) + 1; /* 200000000001 */
  b = (b << 12) + 5; /* 400000000005 */
! /* use the most relevant arithmetic ops */
  c = a * b;
  d = (c + b) / b;
! /* return different values, to prevent optimizations */
  if (d != a+1)
!   return 0;
! return 1;
  ])],
  [pgac_cv__128bit_int=yes],
  [pgac_cv__128bit_int=no])])
  if test x"$pgac_cv__128bit_int" = xyes ; then
!   AC_DEFINE(PG_INT128_TYPE, __int128, [Define to the name of a signed 128-bit integer type.])
!   AC_CHECK_ALIGNOF(PG_INT128_TYPE)
  fi])# PGAC_TYPE_128BIT_INT
  
  
--- 108,166 ----
  [AC_CACHE_CHECK([for __int128], [pgac_cv__128bit_int],
  [AC_LINK_IFELSE([AC_LANG_PROGRAM([
  /*
+  * We don't actually run this test, just link it to verify that any support
+  * functions needed for __int128 are present.
+  *
   * These are globals to discourage the compiler from folding all the
   * arithmetic tests down to compile-time constants.  We do not have
!  * convenient support for 128bit literals at this point...
   */
  __int128 a = 48828125;
! __int128 b = 97656250;
  ],[
  __int128 c,d;
  a = (a << 12) + 1; /* 200000000001 */
  b = (b << 12) + 5; /* 400000000005 */
! /* try the most relevant arithmetic ops */
  c = a * b;
  d = (c + b) / b;
! /* must use the results, else compiler may optimize arithmetic away */
  if (d != a+1)
!   return 1;
  ])],
  [pgac_cv__128bit_int=yes],
  [pgac_cv__128bit_int=no])])
  if test x"$pgac_cv__128bit_int" = xyes ; then
!   # Some versions of gcc have problems passing __int128 function arguments
!   # when using non-default alignment.  Test that, if not cross-compiling.
!   AC_CACHE_CHECK([for __int128 alignment bug], [pgac_cv__128bit_int_bug],
!   [AC_RUN_IFELSE([AC_LANG_PROGRAM([
! /* This must match the corresponding code in c.h: */
! #if defined(__GNUC__) || defined(__SUNPRO_C) || defined(__IBMC__)
! #define pg_attribute_aligned(a) __attribute__((aligned(a)))
! #endif
! typedef __int128 int128a
! #if defined(pg_attribute_aligned)
! pg_attribute_aligned(8)
! #endif
! ;
! int128a holder;
! void pass_by_val(void *buffer, int128a par) { holder = par; }
! ],[
! long int i64 = 97656225L << 12;
! int128a q;	
! pass_by_val(main, (int128a) i64);
! q = (int128a) i64;
! if (q != holder)
!   return 1;
! ])],
!   [pgac_cv__128bit_int_bug=ok],
!   [pgac_cv__128bit_int_bug=broken],
!   [pgac_cv__128bit_int_bug=assuming-ok])])
!   if test x"$pgac_cv__128bit_int_bug" != xbroken ; then
!     AC_DEFINE(PG_INT128_TYPE, __int128, [Define to the name of a signed 128-bit integer type.])
!     AC_CHECK_ALIGNOF(PG_INT128_TYPE)
!   fi
  fi])# PGAC_TYPE_128BIT_INT
  
  
diff --git a/configure b/configure
index 45221e1..6eaed45 100755
*** a/configure
--- b/configure
*************** else
*** 14996,15007 ****
  /* end confdefs.h.  */
  
  /*
   * These are globals to discourage the compiler from folding all the
   * arithmetic tests down to compile-time constants.  We do not have
!  * convenient support for 64bit literals at this point...
   */
  __int128 a = 48828125;
! __int128 b = 97656255;
  
  int
  main ()
--- 14996,15010 ----
  /* end confdefs.h.  */
  
  /*
+  * We don't actually run this test, just link it to verify that any support
+  * functions needed for __int128 are present.
+  *
   * These are globals to discourage the compiler from folding all the
   * arithmetic tests down to compile-time constants.  We do not have
!  * convenient support for 128bit literals at this point...
   */
  __int128 a = 48828125;
! __int128 b = 97656250;
  
  int
  main ()
*************** main ()
*** 15010,15022 ****
  __int128 c,d;
  a = (a << 12) + 1; /* 200000000001 */
  b = (b << 12) + 5; /* 400000000005 */
! /* use the most relevant arithmetic ops */
  c = a * b;
  d = (c + b) / b;
! /* return different values, to prevent optimizations */
  if (d != a+1)
!   return 0;
! return 1;
  
    ;
    return 0;
--- 15013,15024 ----
  __int128 c,d;
  a = (a << 12) + 1; /* 200000000001 */
  b = (b << 12) + 5; /* 400000000005 */
! /* try the most relevant arithmetic ops */
  c = a * b;
  d = (c + b) / b;
! /* must use the results, else compiler may optimize arithmetic away */
  if (d != a+1)
!   return 1;
  
    ;
    return 0;
*************** fi
*** 15033,15042 ****
  { $as_echo "$as_me:${as_lineno-$LINENO}: result: $pgac_cv__128bit_int" >&5
  $as_echo "$pgac_cv__128bit_int" >&6; }
  if test x"$pgac_cv__128bit_int" = xyes ; then
  
  $as_echo "#define PG_INT128_TYPE __int128" >>confdefs.h
  
!   # The cast to long int works around a bug in the HP C Compiler,
  # see AC_CHECK_SIZEOF for more information.
  { $as_echo "$as_me:${as_lineno-$LINENO}: checking alignment of PG_INT128_TYPE" >&5
  $as_echo_n "checking alignment of PG_INT128_TYPE... " >&6; }
--- 15035,15097 ----
  { $as_echo "$as_me:${as_lineno-$LINENO}: result: $pgac_cv__128bit_int" >&5
  $as_echo "$pgac_cv__128bit_int" >&6; }
  if test x"$pgac_cv__128bit_int" = xyes ; then
+   # Some versions of gcc have problems passing __int128 function arguments
+   # when using non-default alignment.  Test that, if not cross-compiling.
+   { $as_echo "$as_me:${as_lineno-$LINENO}: checking for __int128 alignment bug" >&5
+ $as_echo_n "checking for __int128 alignment bug... " >&6; }
+ if ${pgac_cv__128bit_int_bug+:} false; then :
+   $as_echo_n "(cached) " >&6
+ else
+   if test "$cross_compiling" = yes; then :
+   pgac_cv__128bit_int_bug=assuming-ok
+ else
+   cat confdefs.h - <<_ACEOF >conftest.$ac_ext
+ /* end confdefs.h.  */
+ 
+ /* This must match the corresponding code in c.h: */
+ #if defined(__GNUC__) || defined(__SUNPRO_C) || defined(__IBMC__)
+ #define pg_attribute_aligned(a) __attribute__((aligned(a)))
+ #endif
+ typedef __int128 int128a
+ #if defined(pg_attribute_aligned)
+ pg_attribute_aligned(8)
+ #endif
+ ;
+ int128a holder;
+ void pass_by_val(void *buffer, int128a par) { holder = par; }
+ 
+ int
+ main ()
+ {
+ 
+ long int i64 = 97656225L << 12;
+ int128a q;
+ pass_by_val(main, (int128a) i64);
+ q = (int128a) i64;
+ if (q != holder)
+   return 1;
+ 
+   ;
+   return 0;
+ }
+ _ACEOF
+ if ac_fn_c_try_run "$LINENO"; then :
+   pgac_cv__128bit_int_bug=ok
+ else
+   pgac_cv__128bit_int_bug=broken
+ fi
+ rm -f core *.core core.conftest.* gmon.out bb.out conftest$ac_exeext \
+   conftest.$ac_objext conftest.beam conftest.$ac_ext
+ fi
+ 
+ fi
+ { $as_echo "$as_me:${as_lineno-$LINENO}: result: $pgac_cv__128bit_int_bug" >&5
+ $as_echo "$pgac_cv__128bit_int_bug" >&6; }
+   if test x"$pgac_cv__128bit_int_bug" != xbroken ; then
  
  $as_echo "#define PG_INT128_TYPE __int128" >>confdefs.h
  
!     # The cast to long int works around a bug in the HP C Compiler,
  # see AC_CHECK_SIZEOF for more information.
  { $as_echo "$as_me:${as_lineno-$LINENO}: checking alignment of PG_INT128_TYPE" >&5
  $as_echo_n "checking alignment of PG_INT128_TYPE... " >&6; }
*************** cat >>confdefs.h <<_ACEOF
*** 15071,15076 ****
--- 15126,15132 ----
  _ACEOF
  
  
+   fi
  fi
  
  # Check for various atomic operations now that we have checked how to declare