COPY BINARY broken on Linux/AXP

From: pgsql-bugs(at)postgresql(dot)org
To: pgsql-bugs(at)postgresql(dot)org
Subject: COPY BINARY broken on Linux/AXP
Date: 2001-06-27 15:15:23
Message-ID: 200106271515.f5RFFNO84141@hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Reinhard Max (max(at)suse(dot)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

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Reinhard Max 2001-06-27 15:34:43 Re: COPY BINARY broken on Linux/AXP
Previous Message Peter Eisentraut 2001-06-26 17:05:15 Re: Configure fails for SCO Openserver 5.0.5/gcc 2.7.2.3