COPY BINARY broken on Linux/AXP - Mailing list pgsql-bugs

From pgsql-bugs@postgresql.org
Subject COPY BINARY broken on Linux/AXP
Date
Msg-id 200106271515.f5RFFNO84141@hub.org
Whole thread Raw
Responses Re: COPY BINARY broken on Linux/AXP  (Reinhard Max <max@suse.de>)
Re: COPY BINARY broken on Linux/AXP  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
Reinhard Max (max@suse.de) reports a bug with a severity of 3
The lower the number the more severe it is.

Short Description
COPY BINARY broken on Linux/AXP

Long Description
On SuSE Linux for the Alpha(AXP) architecture 'COPY BINARY FROM'
seems not to be able to read a file that was generated by
'COPY BINARY TO' before. Therefore the regression test fails
on test 'misc'.
On our other architectures (i386, IA-64, S390) everything is fine.

I'v copied the first hunk of regression.diffs to the example code
section. There are more hunks, but they seem only to be a result of
the failed 'COPY FROM'.


Sample Code
*** ./expected/misc.out Wed Jun 27 14:35:40 2001
--- ./results/misc.out  Wed Jun 27 14:37:03 2001
***************
*** 61,73 ****
  COPY BINARY stud_emp TO '/usr/src/packages/BUILD/postgresql-7.1.2/src/test/regress/results/stud_emp.data';
  DELETE FROM stud_emp;
  COPY BINARY stud_emp FROM '/usr/src/packages/BUILD/postgresql-7.1.2/src/test/regress/results/stud_emp.data';
  SELECT * FROM stud_emp;
   name  | age |  location  | salary | manager | gpa | percent
! -------+-----+------------+--------+---------+-----+---------
!  jeff  |  23 | (8,7.7)    |    600 | sharon  | 3.5 |
!  cim   |  30 | (10.5,4.7) |    400 |         | 3.4 |
!  linda |  19 | (0.9,6.1)  |    100 |         | 2.9 |
! (3 rows)

  -- COPY aggtest FROM stdin;
  -- 56 7.8
--- 61,71 ----
  COPY BINARY stud_emp TO '/usr/src/packages/BUILD/postgresql-7.1.2/src/test/regress/results/stud_emp.data';
  DELETE FROM stud_emp;
  COPY BINARY stud_emp FROM '/usr/src/packages/BUILD/postgresql-7.1.2/src/test/regress/results/stud_emp.data';
+ ERROR:  copy: line 1, COPY BINARY: sizeof(field 3) is 0, expected 16
  SELECT * FROM stud_emp;
   name | age | location | salary | manager | gpa | percent
! ------+-----+----------+--------+---------+-----+---------
! (0 rows)

  -- COPY aggtest FROM stdin;
  -- 56 7.8


No file was uploaded with this report

pgsql-bugs by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: Configure fails for SCO Openserver 5.0.5/gcc 2.7.2.3
Next
From: Reinhard Max
Date:
Subject: Re: COPY BINARY broken on Linux/AXP