Re: [HACKERS] int8 type -- call for porting results! - Mailing list pgsql-hackers

"Thomas G. Lockhart" <lockhart@alumni.caltech.edu> writes:
> Anyway, I implemented it on a gcc/x86/Linux machine, and we will need to
> ensure that it works on other platforms. If you are doing any work at
> all with a post-v6.3.2 source tree on another platform/OS combination,
> can you please look at the results of the int8 regression test, or run
> that test on your own, and let me know if it worked?

It looks pretty broken on HPUX 9.03 (PA-RISC 1.1, gcc 2.7.2.2):

*** expected/int8.out    Wed Jul  8 10:29:08 1998
--- results/int8.out    Sat Aug 15 13:41:00 1998
***************
*** 6,115 ****
  QUERY: INSERT INTO INT8_TBL VALUES('4567890123456789','-4567890123456789');
  QUERY: SELECT * FROM INT8_TBL;
                q1|               q2
! ----------------+-----------------
               123|              456
!              123| 4567890123456789
! 4567890123456789|              123
! 4567890123456789| 4567890123456789
! 4567890123456789|-4567890123456789
  (5 rows)

[ much more in the same vein omitted ]

--- 6,117 ----
  QUERY: INSERT INTO INT8_TBL VALUES('4567890123456789','-4567890123456789');
  QUERY: SELECT * FROM INT8_TBL;
          q1|        q2
! ----------+----------
         123|       456
!        123|-869367531
! -869367531|       123
! -869367531|-869367531
! -869367531| 869367531
  (5 rows)

[ much more in the same vein omitted ]

At a guess, something is getting cast to int32 somewhere along the line,
or maybe the I/O conversion routines just don't work.

Any thoughts where to look for the problem?

            regards, tom lane