============================================================================
POSTGRESQL BUG REPORT TEMPLATE
============================================================================
Your name : Wen Jiang
Your email address : wj691781@bcm.tmc.edu
Category : runtime: front-end: C++
Severity : non-critical
Summary: byte order problem on Inter and SGI
System Configuration
--------------------
Operating System : RedHat 5.2 i386 and SGI Irix 6.5
PostgreSQL version : 6.4.2
Compiler used : g++
Hardware:
---------
Versions of other tools:
------------------------
--------------------------------------------------------------------------
Problem Description:
--------------------
I setup backend on Redhat 5.2 on a PC, and C++ frontend on linux
and SGI, the testlibpq5 program worked correctly, but the
sgi version has wrong byte order for the binary cursor.
--------------------------------------------------------------------------
Test Case:
----------
results from PC frontend/PC backend:
tuple 0: got
i = (4 bytes) 1,
d = (4 bytes) 3.567,
p = (4 bytes) 2 points boundbox = (hi=3/4,lo = 1,2)
tuple 1: got
i = (4 bytes) 2,
d = (4 bytes) 89.05,
p = (4 bytes) 2 points boundbox = (hi=4/3,lo = 2,1)
results from SGI frontend/PC backend:
tuple 0: got
i = (4 bytes) 16777216,
d = (4 bytes) -0.000768248,
p = (4 bytes) 33554432 points boundbox = (hi=0e-321/0e-321,lo = 0e-320,0e-323)
tuple 1: got
i = (4 bytes) 33554432,
d = (4 bytes) -3.17837e-23,
--------------------------------------------------------------------------
Solution:
---------
--------------------------------------------------------------------------