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