Re: float4/float8/int64 passed by value with tsearchfixup

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: float4/float8/int64 passed by value with tsearchfixup
Дата
Msg-id 20080418221856.GP572@alvh.no-ip.org
обсуждение исходный текст
Ответ на Re: float4/float8/int64 passed by value with tsearchfixup  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: float4/float8/int64 passed by value with tsearchfixup  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-patches
Tom Lane wrote:
> Gregory Stark <stark@enterprisedb.com> writes:
> >> Tom Lane wrote:
> >>> Specifically, I think what you missed is that on some platforms C
> >>> functions pass or return float values differently from similar-sized
> >>> integer or pointer values (typically, the float values get passed in
> >>> floating-point registers).
>
> > Hum. That's a valid concern for some platforms, Sparc I think?
> > But I'm skeptical that it would hit such a wide swathe of the build
> > farm.
>
> I was wondering about that too, once it became obvious that (almost?)
> everything was failing not just some platforms.  However, this
> afternoon's CVS HEAD *does* pass the seg regression test for me on HPPA,
> and I presume it passed on whatever Alvaro is using (btw, what was
> that?).  So there's definitely a platform dependency involved and not
> just you-missed-a-pointer-someplace.

Yeah, it passed for me -- this is a dual-core AMD X2 (amd64), gcc 4.1.3.

Also, it didn't fail in the same way everywhere: for example, fennec
(x86-64, gcc 4.1) shows everything returned as zeros instead of random
values that most other platforms show.

Further fumbling says that fennec, chinchilla, heron, dungbeetle and
platypus display zeroes. These are all the AMD64 machines (different
operating systems: mostly Linux, one FreeBSD) that managed to run during
the time that the bug was out there.

Dugong failed differently, returning NaN.

The others returned random pointers, all in the same area (they all
display the same power of 10 values, presumably random but nearby stack
or data addresses or something like that).


http://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=fennec&dt=2008-04-18%2021:10:01
***************
*** 1070,1218 ****
  FROM test_seg WHERE s @> '11.2..11.3' OR s IS NULL ORDER BY s;
   seg_lower | seg_center | seg_upper
  -----------+------------+-----------
!  -Infinity |  -Infinity |        40
!  -Infinity |  -Infinity |        82
!  -Infinity |  -Infinity |        90
!          1 |          7 |        13
!        1.3 |       6.65 |        12
!          2 |       6.75 |      11.5
!        2.1 |       6.95 |      11.8
!        2.3 |   Infinity |  Infinity
!        2.3 |   Infinity |  Infinity
!        2.4 |       6.85 |      11.3
!        2.5 |          7 |      11.5
!        2.5 |       7.15 |      11.8
!        2.6 |   Infinity |  Infinity
!        2.7 |       7.35 |        12
!          3 |   Infinity |  Infinity
!          3 |       30.5 |        58
!        3.1 |        7.3 |      11.5
!        3.5 |        7.5 |      11.5
!        3.5 |       7.85 |      12.2
!          4 |          8 |        12
!          4 |   Infinity |  Infinity
!          4 |          8 |        12
!          4 |       7.85 |      11.7
!          4 |       8.25 |      12.5
!          4 |        8.5 |        13
!          4 |         32 |        60
!          4 |   Infinity |  Infinity
!        4.2 |       7.85 |      11.5
!        4.2 |       7.95 |      11.7
!        4.5 |       8.25 |        12
!        4.5 |          8 |      11.5
!        4.5 |       8.25 |        12
!        4.5 |       8.25 |        12
!        4.5 |        8.5 |      12.5
!        4.5 |      59.75 |       115
!        4.7 |       8.25 |      11.8
!        4.8 |       8.15 |      11.5
!        4.8 |        8.2 |      11.6
!        4.8 |       8.65 |      12.5
!        4.8 |   Infinity |  Infinity
!        4.9 |       8.45 |        12
!        4.9 |   Infinity |  Infinity
!          5 |       8.25 |      11.5
!          5 |        8.5 |        12
!          5 |       17.5 |        30
!          5 |        8.2 |      11.4
!          5 |       8.25 |      11.5
!          5 |        8.3 |      11.6
!          5 |       8.35 |      11.7
!          5 |        8.5 |        12
!          5 |        8.5 |        12
!          5 |        8.5 |        12
!        5.2 |       8.35 |      11.5
!        5.2 |        8.6 |        12
!       5.25 |      8.625 |        12
!        5.3 |        8.4 |      11.5
!        5.3 |       9.15 |        13
!        5.3 |      47.65 |        90
!        5.3 |   Infinity |  Infinity
!        5.4 |   Infinity |  Infinity
!        5.5 |        8.5 |      11.5
!        5.5 |        8.6 |      11.7
!        5.5 |       8.75 |        12
!        5.5 |       8.75 |        12
!        5.5 |          9 |      12.5
!        5.5 |        9.5 |      13.5
!        5.5 |   Infinity |  Infinity
!        5.5 |   Infinity |  Infinity
!        5.7 |   Infinity |  Infinity
!        5.9 |   Infinity |  Infinity
!          6 |       8.75 |      11.5
!          6 |          9 |        12
!          6 |       8.75 |      11.5
!          6 |        9.5 |        13
!          6 |       8.75 |      11.5
!        6.1 |       9.05 |        12
!        6.1 |   Infinity |  Infinity
!        6.2 |       8.85 |      11.5
!        6.3 |   Infinity |  Infinity
!        6.5 |          9 |      11.5
!        6.5 |       9.25 |        12
!        6.5 |       9.25 |        12
!        6.5 |   Infinity |  Infinity
!        6.6 |   Infinity |  Infinity
!        6.7 |        9.1 |      11.5
!        6.7 |   Infinity |  Infinity
!       6.75 |   Infinity |  Infinity
!        6.8 |   Infinity |  Infinity
!        6.9 |       9.55 |      12.2
!        6.9 |      48.45 |        90
!        6.9 |   Infinity |  Infinity
!          7 |       9.25 |      11.5
!          7 |       9.25 |      11.5
!          7 |       9.25 |      11.5
!          7 |   Infinity |  Infinity
!       7.15 |   Infinity |  Infinity
!        7.2 |      10.35 |      13.5
!        7.3 |      48.65 |        90
!        7.3 |   Infinity |  Infinity
!        7.3 |   Infinity |  Infinity
!        7.4 |       9.75 |      12.1
!        7.4 |   Infinity |  Infinity
!        7.5 |        9.5 |      11.5
!        7.5 |       9.75 |        12
!        7.5 |   Infinity |  Infinity
!        7.7 |        9.6 |      11.5
!        7.7 |   Infinity |  Infinity
!       7.75 |   Infinity |  Infinity
!          8 |       9.85 |      11.7
!          8 |         10 |        12
!          8 |       10.5 |        13
!        8.2 |   Infinity |  Infinity
!        8.3 |   Infinity |  Infinity
!        8.5 |         10 |      11.5
!        8.5 |       10.5 |      12.5
!        8.5 |   Infinity |  Infinity
!        8.6 |       53.8 |        99
!        8.7 |         10 |      11.3
!        8.7 |       10.2 |      11.7
!        8.9 |       10.2 |      11.5
!          9 |       10.5 |        12
!          9 |      10.15 |      11.3
!          9 |      10.25 |      11.5
!          9 |       10.5 |        12
!          9 |   Infinity |  Infinity
!        9.2 |       10.6 |        12
!        9.4 |       10.8 |      12.2
!        9.5 |      10.75 |        12
!        9.5 |      10.85 |      12.2
!        9.5 |   Infinity |  Infinity
!        9.6 |      10.55 |      11.5
!        9.7 |       10.6 |      11.5
!        9.7 |      10.85 |        12
!        9.8 |      11.15 |      12.5
!         10 |       10.8 |      11.6
!         10 |      10.75 |      11.5
!         10 |      11.25 |      12.5
!         10 |      11.25 |      12.5
!       10.2 |         11 |      11.8
!       10.5 |         11 |      11.5
!       10.5 |         11 |      11.5
!       10.5 |         12 |      13.5
!       10.7 |       11.5 |      12.3
             |            |
  (144 rows)

--- 1070,1218 ----
  FROM test_seg WHERE s @> '11.2..11.3' OR s IS NULL ORDER BY s;
   seg_lower | seg_center | seg_upper
  -----------+------------+-----------
!          0 |          0 |         0
!          0 |          0 |         0
!          0 |          0 |         0
!          0 |          0 |         0
!          0 |          0 |         0
!          0 |          0 |         0
!          0 |          0 |         0
!          0 |          0 |         0
!          0 |          0 |         0
!          0 |          0 |         0
!          0 |          0 |         0
!          0 |          0 |         0
!          0 |          0 |         0
!          0 |          0 |         0
!          0 |          0 |         0
!          0 |          0 |         0
!          0 |          0 |         0
!          0 |          0 |         0
!          0 |          0 |         0
!          0 |          0 |         0
!          0 |          0 |         0
!          0 |          0 |         0
!          0 |          0 |         0
!          0 |          0 |         0
!          0 |          0 |         0
!          0 |          0 |         0
!          0 |          0 |         0
!          0 |          0 |         0
!          0 |          0 |         0
!          0 |          0 |         0
!          0 |          0 |         0
!          0 |          0 |         0
!          0 |          0 |         0
!          0 |          0 |         0
!          0 |          0 |         0
!          0 |          0 |         0
!          0 |          0 |         0
!          0 |          0 |         0
!          0 |          0 |         0
!          0 |          0 |         0
!          0 |          0 |         0
!          0 |          0 |         0
!          0 |          0 |         0
!          0 |          0 |         0
!          0 |          0 |         0
!          0 |          0 |         0
!          0 |          0 |         0
!          0 |          0 |         0
!          0 |          0 |         0
!          0 |          0 |         0
!          0 |          0 |         0
!          0 |          0 |         0
!          0 |          0 |         0
!          0 |          0 |         0
!          0 |          0 |         0
!          0 |          0 |         0
!          0 |          0 |         0
!          0 |          0 |         0
!          0 |          0 |         0
!          0 |          0 |         0
!          0 |          0 |         0
!          0 |          0 |         0
!          0 |          0 |         0
!          0 |          0 |         0
!          0 |          0 |         0
!          0 |          0 |         0
!          0 |          0 |         0
!          0 |          0 |         0
!          0 |          0 |         0
!          0 |          0 |         0
!          0 |          0 |         0
!          0 |          0 |         0
!          0 |          0 |         0
!          0 |          0 |         0
!          0 |          0 |         0
!          0 |          0 |         0
!          0 |          0 |         0
!          0 |          0 |         0
!          0 |          0 |         0
!          0 |          0 |         0
!          0 |          0 |         0
!          0 |          0 |         0
!          0 |          0 |         0
!          0 |          0 |         0
!          0 |          0 |         0
!          0 |          0 |         0
!          0 |          0 |         0
!          0 |          0 |         0
!          0 |          0 |         0
!          0 |          0 |         0
!          0 |          0 |         0
!          0 |          0 |         0
!          0 |          0 |         0
!          0 |          0 |         0
!          0 |          0 |         0
!          0 |          0 |         0
!          0 |          0 |         0
!          0 |          0 |         0
!          0 |          0 |         0
!          0 |          0 |         0
!          0 |          0 |         0
!          0 |          0 |         0
!          0 |          0 |         0
!          0 |          0 |         0
!          0 |          0 |         0
!          0 |          0 |         0
!          0 |          0 |         0
!          0 |          0 |         0
!          0 |          0 |         0
!          0 |          0 |         0
!          0 |          0 |         0
!          0 |          0 |         0
!          0 |          0 |         0
!          0 |          0 |         0
!          0 |          0 |         0
!          0 |          0 |         0
!          0 |          0 |         0
!          0 |          0 |         0
!          0 |          0 |         0
!          0 |          0 |         0
!          0 |          0 |         0
!          0 |          0 |         0
!          0 |          0 |         0
!          0 |          0 |         0
!          0 |          0 |         0
!          0 |          0 |         0
!          0 |          0 |         0
!          0 |          0 |         0
!          0 |          0 |         0
!          0 |          0 |         0
!          0 |          0 |         0
!          0 |          0 |         0
!          0 |          0 |         0
!          0 |          0 |         0
!          0 |          0 |         0
!          0 |          0 |         0
!          0 |          0 |         0
!          0 |          0 |         0
!          0 |          0 |         0
!          0 |          0 |         0
!          0 |          0 |         0
!          0 |          0 |         0
!          0 |          0 |         0
             |            |
  (144 rows)




Mastodon, Windows 2003, MSVC
http://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=mastodon&dt=2008-04-18%2019:00:00

================= pgsql.4236/contrib/seg/regression.diffs ===================
*** ./expected/seg_1.out    2008-04-18 20:00:10.593750000 +0100
--- ./results/seg.out    2008-04-18 20:16:25.375000000 +0100
***************
*** 1069,1218 ****
  SELECT seg_lower(s), seg_center(s), seg_upper(s)
  FROM test_seg WHERE s @> '11.2..11.3' OR s IS NULL ORDER BY s;
   seg_lower | seg_center | seg_upper
! -----------+------------+-----------
!  -Infinity |  -Infinity |        40
!  -Infinity |  -Infinity |        82
!  -Infinity |  -Infinity |        90
!          1 |          7 |        13
!        1.3 |       6.65 |        12
!          2 |       6.75 |      11.5
!        2.1 |       6.95 |      11.8
!        2.3 |   Infinity |  Infinity
!        2.3 |   Infinity |  Infinity
!        2.4 |       6.85 |      11.3
!        2.5 |          7 |      11.5
!        2.5 |       7.15 |      11.8
!        2.6 |   Infinity |  Infinity
!        2.7 |       7.35 |        12
!          3 |   Infinity |  Infinity
!          3 |       30.5 |        58
!        3.1 |        7.3 |      11.5
!        3.5 |        7.5 |      11.5
!        3.5 |       7.85 |      12.2
!          4 |          8 |        12
!          4 |   Infinity |  Infinity
!          4 |          8 |        12
!          4 |       7.85 |      11.7
!          4 |       8.25 |      12.5
!          4 |        8.5 |        13
!          4 |         32 |        60
!          4 |   Infinity |  Infinity
!        4.2 |       7.85 |      11.5
!        4.2 |       7.95 |      11.7
!        4.5 |       8.25 |        12
!        4.5 |          8 |      11.5
!        4.5 |       8.25 |        12
!        4.5 |       8.25 |        12
!        4.5 |        8.5 |      12.5
!        4.5 |      59.75 |       115
!        4.7 |       8.25 |      11.8
!        4.8 |       8.15 |      11.5
!        4.8 |        8.2 |      11.6
!        4.8 |       8.65 |      12.5
!        4.8 |   Infinity |  Infinity
!        4.9 |       8.45 |        12
!        4.9 |   Infinity |  Infinity
!          5 |       8.25 |      11.5
!          5 |        8.5 |        12
!          5 |       17.5 |        30
!          5 |        8.2 |      11.4
!          5 |       8.25 |      11.5
!          5 |        8.3 |      11.6
!          5 |       8.35 |      11.7
!          5 |        8.5 |        12
!          5 |        8.5 |        12
!          5 |        8.5 |        12
!        5.2 |       8.35 |      11.5
!        5.2 |        8.6 |        12
!       5.25 |      8.625 |        12
!        5.3 |        8.4 |      11.5
!        5.3 |       9.15 |        13
!        5.3 |      47.65 |        90
!        5.3 |   Infinity |  Infinity
!        5.4 |   Infinity |  Infinity
!        5.5 |        8.5 |      11.5
!        5.5 |        8.6 |      11.7
!        5.5 |       8.75 |        12
!        5.5 |       8.75 |        12
!        5.5 |          9 |      12.5
!        5.5 |        9.5 |      13.5
!        5.5 |   Infinity |  Infinity
!        5.5 |   Infinity |  Infinity
!        5.7 |   Infinity |  Infinity
!        5.9 |   Infinity |  Infinity
!          6 |       8.75 |      11.5
!          6 |          9 |        12
!          6 |       8.75 |      11.5
!          6 |        9.5 |        13
!          6 |       8.75 |      11.5
!        6.1 |       9.05 |        12
!        6.1 |   Infinity |  Infinity
!        6.2 |       8.85 |      11.5
!        6.3 |   Infinity |  Infinity
!        6.5 |          9 |      11.5
!        6.5 |       9.25 |        12
!        6.5 |       9.25 |        12
!        6.5 |   Infinity |  Infinity
!        6.6 |   Infinity |  Infinity
!        6.7 |        9.1 |      11.5
!        6.7 |   Infinity |  Infinity
!       6.75 |   Infinity |  Infinity
!        6.8 |   Infinity |  Infinity
!        6.9 |       9.55 |      12.2
!        6.9 |      48.45 |        90
!        6.9 |   Infinity |  Infinity
!          7 |       9.25 |      11.5
!          7 |       9.25 |      11.5
!          7 |       9.25 |      11.5
!          7 |   Infinity |  Infinity
!       7.15 |   Infinity |  Infinity
!        7.2 |      10.35 |      13.5
!        7.3 |      48.65 |        90
!        7.3 |   Infinity |  Infinity
!        7.3 |   Infinity |  Infinity
!        7.4 |       9.75 |      12.1
!        7.4 |   Infinity |  Infinity
!        7.5 |        9.5 |      11.5
!        7.5 |       9.75 |        12
!        7.5 |   Infinity |  Infinity
!        7.7 |        9.6 |      11.5
!        7.7 |   Infinity |  Infinity
!       7.75 |   Infinity |  Infinity
!          8 |       9.85 |      11.7
!          8 |         10 |        12
!          8 |       10.5 |        13
!        8.2 |   Infinity |  Infinity
!        8.3 |   Infinity |  Infinity
!        8.5 |         10 |      11.5
!        8.5 |       10.5 |      12.5
!        8.5 |   Infinity |  Infinity
!        8.6 |       53.8 |        99
!        8.7 |         10 |      11.3
!        8.7 |       10.2 |      11.7
!        8.9 |       10.2 |      11.5
!          9 |       10.5 |        12
!          9 |      10.15 |      11.3
!          9 |      10.25 |      11.5
!          9 |       10.5 |        12
!          9 |   Infinity |  Infinity
!        9.2 |       10.6 |        12
!        9.4 |       10.8 |      12.2
!        9.5 |      10.75 |        12
!        9.5 |      10.85 |      12.2
!        9.5 |   Infinity |  Infinity
!        9.6 |      10.55 |      11.5
!        9.7 |       10.6 |      11.5
!        9.7 |      10.85 |        12
!        9.8 |      11.15 |      12.5
!         10 |       10.8 |      11.6
!         10 |      10.75 |      11.5
!         10 |      11.25 |      12.5
!         10 |      11.25 |      12.5
!       10.2 |         11 |      11.8
!       10.5 |         11 |      11.5
!       10.5 |         11 |      11.5
!       10.5 |         12 |      13.5
!       10.7 |       11.5 |      12.3
             |            |
  (144 rows)

--- 1069,1218 ----
  SELECT seg_lower(s), seg_center(s), seg_upper(s)
  FROM test_seg WHERE s @> '11.2..11.3' OR s IS NULL ORDER BY s;
    seg_lower   |  seg_center  |  seg_upper
! --------------+--------------+--------------
!  9.04487e-038 | 9.04487e-038 | 9.04487e-038
!  9.04408e-038 | 9.04408e-038 | 9.04408e-038
!  9.04435e-038 | 9.04435e-038 | 9.04435e-038
!  9.03785e-038 | 9.03785e-038 | 9.03785e-038
!   9.0302e-038 |  9.0302e-038 |  9.0302e-038
!   9.0297e-038 |  9.0297e-038 |  9.0297e-038
!  9.02923e-038 | 9.02923e-038 | 9.02923e-038
!  9.03752e-038 | 9.03752e-038 | 9.03752e-038
!  9.03118e-038 | 9.03118e-038 | 9.03118e-038
!  9.02887e-038 | 9.02887e-038 | 9.02887e-038
!  9.02869e-038 | 9.02869e-038 | 9.02869e-038
!  9.02867e-038 | 9.02867e-038 | 9.02867e-038
!  9.02829e-038 | 9.02829e-038 | 9.02829e-038
!  9.02813e-038 | 9.02813e-038 | 9.02813e-038
!  9.04377e-038 | 9.04377e-038 | 9.04377e-038
!  9.02744e-038 | 9.02744e-038 | 9.02744e-038
!  9.02623e-038 | 9.02623e-038 | 9.02623e-038
!  9.02522e-038 | 9.02522e-038 | 9.02522e-038
!   9.0252e-038 |  9.0252e-038 |  9.0252e-038
!   9.0431e-038 |  9.0431e-038 |  9.0431e-038
!   9.0433e-038 |  9.0433e-038 |  9.0433e-038
!  9.02336e-038 | 9.02336e-038 | 9.02336e-038
!    9.023e-038 |   9.023e-038 |   9.023e-038
!  9.02298e-038 | 9.02298e-038 | 9.02298e-038
!  9.02296e-038 | 9.02296e-038 | 9.02296e-038
!   9.0226e-038 |  9.0226e-038 |  9.0226e-038
!  9.02314e-038 | 9.02314e-038 | 9.02314e-038
!  9.02146e-038 | 9.02146e-038 | 9.02146e-038
!  9.02144e-038 | 9.02144e-038 | 9.02144e-038
!  9.04272e-038 | 9.04272e-038 | 9.04272e-038
!  9.01994e-038 | 9.01994e-038 | 9.01994e-038
!  9.01917e-038 | 9.01917e-038 | 9.01917e-038
!  9.01913e-038 | 9.01913e-038 | 9.01913e-038
!  9.01989e-038 | 9.01989e-038 | 9.01989e-038
!  9.01991e-038 | 9.01991e-038 | 9.01991e-038
!  9.01839e-038 | 9.01839e-038 | 9.01839e-038
!   9.0173e-038 |  9.0173e-038 |  9.0173e-038
!  9.01727e-038 | 9.01727e-038 | 9.01727e-038
!  9.01725e-038 | 9.01725e-038 | 9.01725e-038
!  9.01734e-038 | 9.01734e-038 | 9.01734e-038
!  9.01649e-038 | 9.01649e-038 | 9.01649e-038
!  9.01669e-038 | 9.01669e-038 | 9.01669e-038
!  9.01633e-038 | 9.01633e-038 | 9.01633e-038
!  9.01631e-038 | 9.01631e-038 | 9.01631e-038
!  9.01629e-038 | 9.01629e-038 | 9.01629e-038
!   9.0159e-038 |  9.0159e-038 |  9.0159e-038
!  9.01588e-038 | 9.01588e-038 | 9.01588e-038
!  9.01586e-038 | 9.01586e-038 | 9.01586e-038
!  9.01584e-038 | 9.01584e-038 | 9.01584e-038
!  9.01582e-038 | 9.01582e-038 | 9.01582e-038
!  9.01505e-038 | 9.01505e-038 | 9.01505e-038
!  9.01508e-038 | 9.01508e-038 | 9.01508e-038
!  9.01445e-038 | 9.01445e-038 | 9.01445e-038
!  9.01378e-038 | 9.01378e-038 | 9.01378e-038
!   9.0136e-038 |  9.0136e-038 |  9.0136e-038
!  9.01342e-038 | 9.01342e-038 | 9.01342e-038
!  9.01339e-038 | 9.01339e-038 | 9.01339e-038
!  9.01243e-038 | 9.01243e-038 | 9.01243e-038
!  9.01355e-038 | 9.01355e-038 | 9.01355e-038
!  9.01237e-038 | 9.01237e-038 | 9.01237e-038
!  9.01183e-038 | 9.01183e-038 | 9.01183e-038
!  9.01181e-038 | 9.01181e-038 | 9.01181e-038
!  9.01178e-038 | 9.01178e-038 | 9.01178e-038
!  9.01093e-038 | 9.01093e-038 | 9.01093e-038
!  9.01176e-038 | 9.01176e-038 | 9.01176e-038
!  9.01174e-038 | 9.01174e-038 | 9.01174e-038
!  9.01194e-038 | 9.01194e-038 | 9.01194e-038
!  9.03205e-038 | 9.03205e-038 | 9.03205e-038
!  9.01001e-038 | 9.01001e-038 | 9.01001e-038
!  9.00791e-038 | 9.00791e-038 | 9.00791e-038
!  9.00744e-038 | 9.00744e-038 | 9.00744e-038
!  9.00724e-038 | 9.00724e-038 | 9.00724e-038
!  9.00695e-038 | 9.00695e-038 | 9.00695e-038
!  9.00692e-038 | 9.00692e-038 | 9.00692e-038
!  9.03196e-038 | 9.03196e-038 | 9.03196e-038
!  9.00535e-038 | 9.00535e-038 | 9.00535e-038
!  9.00585e-038 | 9.00585e-038 | 9.00585e-038
!  9.00446e-038 | 9.00446e-038 | 9.00446e-038
!  9.00419e-038 | 9.00419e-038 | 9.00419e-038
!  9.00184e-038 | 9.00184e-038 | 9.00184e-038
!  9.00182e-038 | 9.00182e-038 | 9.00182e-038
!  9.00101e-038 | 9.00101e-038 | 9.00101e-038
!  9.00202e-038 | 9.00202e-038 | 9.00202e-038
!  9.00072e-038 | 9.00072e-038 | 9.00072e-038
!  9.00009e-038 | 9.00009e-038 | 9.00009e-038
!  9.00013e-038 | 9.00013e-038 | 9.00013e-038
!  8.99886e-038 | 8.99886e-038 | 8.99886e-038
!   8.9987e-038 |  8.9987e-038 |  8.9987e-038
!  8.99769e-038 | 8.99769e-038 | 8.99769e-038
!  8.99713e-038 | 8.99713e-038 | 8.99713e-038
!  8.99774e-038 | 8.99774e-038 | 8.99774e-038
!  9.03313e-038 | 9.03313e-038 | 9.03313e-038
!   8.9966e-038 |  8.9966e-038 |  8.9966e-038
!  8.99581e-038 | 8.99581e-038 | 8.99581e-038
!   8.9968e-038 |  8.9968e-038 |  8.9968e-038
!  9.03178e-038 | 9.03178e-038 | 9.03178e-038
!  8.99494e-038 | 8.99494e-038 | 8.99494e-038
!   8.9927e-038 |  8.9927e-038 |  8.9927e-038
!  8.99346e-038 | 8.99346e-038 | 8.99346e-038
!  9.03078e-038 | 9.03078e-038 | 9.03078e-038
!  8.99254e-038 | 8.99254e-038 | 8.99254e-038
!  8.99261e-038 | 8.99261e-038 | 8.99261e-038
!  8.99174e-038 | 8.99174e-038 | 8.99174e-038
!  8.99171e-038 | 8.99171e-038 | 8.99171e-038
!  8.99196e-038 | 8.99196e-038 | 8.99196e-038
!  8.98974e-038 | 8.98974e-038 | 8.98974e-038
!  8.98988e-038 | 8.98988e-038 | 8.98988e-038
!  8.98934e-038 | 8.98934e-038 | 8.98934e-038
!  8.98806e-038 | 8.98806e-038 | 8.98806e-038
!  8.98804e-038 | 8.98804e-038 | 8.98804e-038
!  8.98761e-038 | 8.98761e-038 | 8.98761e-038
!  8.98714e-038 | 8.98714e-038 | 8.98714e-038
!  8.98663e-038 | 8.98663e-038 | 8.98663e-038
!  8.98509e-038 | 8.98509e-038 | 8.98509e-038
!   8.9858e-038 |  8.9858e-038 |  8.9858e-038
!  8.98598e-038 | 8.98598e-038 | 8.98598e-038
!  8.98484e-038 | 8.98484e-038 | 8.98484e-038
!  8.98473e-038 | 8.98473e-038 | 8.98473e-038
!   8.9847e-038 |  8.9847e-038 |  8.9847e-038
!  8.98432e-038 | 8.98432e-038 | 8.98432e-038
!  8.98419e-038 | 8.98419e-038 | 8.98419e-038
!  8.98394e-038 | 8.98394e-038 | 8.98394e-038
!  8.98392e-038 | 8.98392e-038 | 8.98392e-038
!   8.9839e-038 |  8.9839e-038 |  8.9839e-038
!  8.98414e-038 | 8.98414e-038 | 8.98414e-038
!  8.98361e-038 | 8.98361e-038 | 8.98361e-038
!   8.9834e-038 |  8.9834e-038 |  8.9834e-038
!  9.03228e-038 | 9.03228e-038 | 9.03228e-038
!  9.03225e-038 | 9.03225e-038 | 9.03225e-038
!  8.98334e-038 | 8.98334e-038 | 8.98334e-038
!  8.98302e-038 | 8.98302e-038 | 8.98302e-038
!  8.98291e-038 | 8.98291e-038 | 8.98291e-038
!  8.98287e-038 | 8.98287e-038 | 8.98287e-038
!  8.98273e-038 | 8.98273e-038 | 8.98273e-038
!  9.04397e-038 | 9.04397e-038 | 9.04397e-038
!  8.98251e-038 | 8.98251e-038 | 8.98251e-038
!  8.98248e-038 | 8.98248e-038 | 8.98248e-038
!  8.98246e-038 | 8.98246e-038 | 8.98246e-038
!  8.98242e-038 | 8.98242e-038 | 8.98242e-038
!  9.03781e-038 | 9.03781e-038 | 9.03781e-038
!  8.98224e-038 | 8.98224e-038 | 8.98224e-038
!  8.98222e-038 | 8.98222e-038 | 8.98222e-038
!  8.98215e-038 | 8.98215e-038 | 8.98215e-038
                |              |
  (144 rows)

--
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.

В списке pgsql-patches по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: float4/float8/int64 passed by value with tsearchfixup
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: float4/float8/int64 passed by value with tsearchfixup