Port Bug Report: byte order problem on Inter and SGI - Mailing list pgsql-ports

From Unprivileged user
Subject Port Bug Report: byte order problem on Inter and SGI
Date
Msg-id 199905132009.QAA00436@hub.org
Whole thread Raw
List pgsql-ports
============================================================================
                        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:
---------


--------------------------------------------------------------------------


pgsql-ports by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [PORTS] Port Bug Report: Incorrect search using 'select .... like ...' statement.
Next
From: Unprivileged user
Date:
Subject: Port Bug Report: Date problem