Port Bug Report: SELECT * FROM ETHER WHERE MAC = '00:80:48:a9:88:32'; leads to coredump

From: Unprivileged user <nobody>
To: pgsql-ports(at)postgresql(dot)org
Subject: Port Bug Report: SELECT * FROM ETHER WHERE MAC = '00:80:48:a9:88:32'; leads to coredump
Date: 1999-01-04 11:54:40
Message-ID: 199901041154.GAA07735@hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-ports


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

Your name : Mikhail Kourinny
Your email address : misio(at)real(dot)kharkov(dot)ua

Category : runtime: back-end: SQL
Severity : critical

Summary: SELECT * FROM ETHER WHERE MAC = '00:80:48:a9:88:32'; leads to coredump

System Configuration
--------------------
Operating System : Linux 2.0.35, Slackware-3.4 based

PostgreSQL version : 6.4.2

Compiler used : gcc 2.7.2.3

Hardware:
---------
Pentium-166 MMX, 32M RAM; uname -a:
Linux bill 2.0.35 #3 Wed Nov 25 09:45:19 EET 1998 i586 unknown

Versions of other tools:
------------------------
GNU Make version 3.76.1,
flex version 2.5.4

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

Problem Description:
--------------------
I experience the problem since 6.3.2 version, the first
one I was developing my project with. There's nothing
much to tell, I'd rather describe a way to repeat a problem...

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

Test Case:
----------
$ createdb test
$ psql test <qqq
CREATE TABLE "_" (
"num" int4 NOT NULL,
"subclass" character varying(16) DEFAULT '_',
"type" int4,
"isok" bool DEFAULT 1,
"comment" text);
CREATE
CREATE TABLE "ether" (
"mac" macaddr)
inherits ("_");
CREATE
COPY "ether" FROM stdin;
EOF
bill:~/tmp/t3$ psql test
Welcome to the POSTGRESQL interactive sql monitor:
Please read the file COPYRIGHT for copyright terms of POSTGRESQL

type \? for help on slash commands
type \q to quit
type \g or terminate with semicolon to execute query
You are currently connected to the database: test

test=> select * from ether ;
num|subclass|type|isok|comment|mac
---+--------+----+----+-------+-----------------
1|ether | |t | |
4|ether | |t | |00:aa:00:6a:c9:35
(2 rows)

test=> select * from ether where mac = '00:aa:00:6a:c9:35';
pqReadData() -- backend closed the channel unexpectedly.
This probably means the backend terminated abnormally before or while processing the request.
We have lost the connection to the backend, so further processing is impossible. Terminating.
bill:~/tmp/t3$ cat qqq
CREATE TABLE "_" (
"num" int4 NOT NULL,
"subclass" character varying(16) DEFAULT '_',
"type" int4,
"isok" bool DEFAULT 1,
"comment" text);
CREATE TABLE "ether" (
"mac" macaddr)
inherits ("_");
COPY "ether" FROM stdin;
1 ether \N t \N \N
4 ether \N t \N 00:aa:00:6a:c9:35
\.

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

Solution:
---------

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

Browse pgsql-ports by date

  From Date Subject
Next Message Unprivileged user 1999-01-04 14:35:33 Port Bug Report: odbc interface can't be compiled (even in version 6.4.1)
Previous Message Unprivileged user 1999-01-04 09:28:23 Port Bug Report: ./configure stops while invoking conftest.sh