pgsql 7.1: int4out() brokeness?

From: James Troup <james(at)nocrew(dot)org>
To: pgsql-bugs(at)postgresql(dot)org
Subject: pgsql 7.1: int4out() brokeness?
Date: 2001-01-09 06:52:24
Message-ID: 87u279fc9j.fsf@dt-jtlaptop.datatrans
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

============================================================================
POSTGRESQL BUG REPORT TEMPLATE
============================================================================

Your name : James Troup
Your email address : james(at)nocrew(dot)org

System Configuration
---------------------
Architecture (example: Intel Pentium) : Intel Pentium

Operating System (example: Linux 2.0.26 ELF) : Linux 2.4.0 ELF

PostgreSQL version (example: PostgreSQL-7.0) : PostgreSQL-7.1 snapshot (from 2001-01-07 or -08)

Compiler used (example: gcc 2.8.0) : gcc 2.95.2

Please enter a FULL description of your problem:
------------------------------------------------

int4out() seems to be broken which in turn breaks ODBC.

With pgsql 7.1:

| template1=# create table x (y int4); insert into x values (31); select y, int4out(y) from x;
| CREATE
| INSERT 34029 1
| y | int4out
| ----+-----------
| 31 | 136420312
| (1 row)

With pgsql 7.0.3:

| template1=> create table x (y int4); insert into x values (31); select y, int4out(y) from x;
| CREATE
| INSERT 35923 1
| y | int4out
| ----+---------
| 31 | 31
| (1 row)

Please describe a way to repeat the problem. Please try to provide a
concise reproducible example, if at all possible:
----------------------------------------------------------------------

As above:

CREATE TABLE x (y int4); INSERT INTO x VALUES (31); SELECT y, int4out(y) FROM x;

Both rows returned should (unless I'm missing something horribly
obvious) be 31.

If you know how this problem might be fixed, list the solution below:
---------------------------------------------------------------------

--
James

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Mitchell Brandsma 2001-01-10 04:28:03 Interval bug
Previous Message maheswarry ramakrishnan 2001-01-08 15:11:10 Query!