Re: [HACKERS] int8 type -- call for porting results!

"Thomas G. Lockhart" <lockhart(at)alumni(dot)caltech(dot)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