Thread: Port Bug Report: SELECT * FROM ETHER WHERE MAC = '00:80:48:a9:88:32'; leads to coredump
Port Bug Report: SELECT * FROM ETHER WHERE MAC = '00:80:48:a9:88:32'; leads to coredump
From
Unprivileged user
Date:
============================================================================
POSTGRESQL BUG REPORT TEMPLATE
============================================================================
Your name : Mikhail Kourinny
Your email address : misio@real.kharkov.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:
---------
--------------------------------------------------------------------------