Bug#90856: postgresql: query with unused table in from clause causes crash (fwd)

This error was in 7.0.3 and is still found in 7.1. Could someone take a
look please.

------- Forwarded Message

Date: 07 May 2001 11:38:45 -0400
From: Camm Maguire <camm(at)enhanced(dot)com>
To: "Oliver Elphick" <olly(at)lfix(dot)co(dot)uk>
cc: 90856(at)bugs(dot)debian(dot)org
Subject: Bug#90856: postgresql: query with unused table in from clause causes c
rash

Greetings! Alas, the problem still persists. I've upgraded to the
7.1 release 3 binaries for potato you list on your site. Here are the
results. In the error case, the system appears to want to allocate
all available, or almost all, virtual memory before ending with this
error.

Thanks for your wonderful work with this package!
=============================================================================
rdb2=# select t1.asof,t1.rinfo,(t1.cprice*t1.split+t1.dividend)/t1.price -1.0 a
s ret from rprices t1 where t1.asof >= '20000103' and t1.asof < '20000403' an
d t1.price!=0.0;
asof | rinfo | ret
- ------------+-------+-----------------------
2000-02-04 | 7323 | -1
2000-03-31 | 7009 | -0.0736842105263158
...
(176113 rows)

rdb2=# select t1.asof,t1.rinfo,(t1.cprice*t1.split+t1.dividend)/t1.price -1.0 a
s ret from rprices t1,dates where t1.asof >= '20000103' and t1.asof < '200004
03' and t1.price!=0.0;
Backend sent D message without prior T
Backend sent D message without prior T
Backend sent D message without prior T
Backend sent D message without prior T
Backend sent D message without prior T
Backend sent D message without prior T
Backend sent D message without prior T
Backend sent D message without prior T
Backend sent D message without prior T
Backend sent D message without prior T
Backend sent D message without prior T
Backend sent D message without prior T
Backend sent D message without prior T
Backend sent D message without prior T
Backend sent D message without prior T
Backend sent D message without prior T
Backend sent D message without prior T
Backend sent D message without prior T
Backend sent D message without prior T
Backend sent D message without prior T
Backend sent D message without prior T
Backend sent D message without prior T
Backend sent D message without prior T
Backend sent D message without prior T
Backend sent D message without prior T
Backend sent D message without prior T
Backend sent D message without prior T
Backend sent D message without prior T
Backend sent D message without prior T
Backend sent D message without prior T
Backend sent D message without prior T
Backend sent D message without prior T
Backend sent D message without prior T
Backend sent D message without prior T
Backend sent D message without prior T
Backend sent D message without prior T
Backend sent D message without prior T
Backend sent D message without prior T
Backend sent D message without prior T
Backend sent D message without prior T
Backend sent D message without prior T
Backend sent D message without prior T
Segmentation fault
=============================================================================

"Oliver Elphick" <olly(at)lfix(dot)co(dot)uk> writes:

> Camm Maguire wrote:
> >Its totally reproducible. Just did both 3 times with the same
> >results.
>
> Can you try with 7.1
>
> 7-1release-3 is in non-us incoming.
>
> --
> Oliver Elphick Oliver(dot)Elphick(at)lfix(dot)co(dot)uk
> Isle of Wight http://www.lfix.co.uk/oliver
> PGP: 1024R/32B8FAA1: 97 EA 1D 47 72 3F 28 47 6B 7E 39 CC 56 E4 C1 47
> GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C
> ========================================
> "Live in harmony with one another. Do not be proud, but
> be willing to associate with people of low position.
> Do not be conceited." Romans 12:16
>
>
>
>

- --
Camm Maguire camm(at)enhanced(dot)com
==========================================================================
"The earth is but one country, and mankind its citizens." -- Baha'u'llah

------- End of Forwarded Message

--
Oliver Elphick Oliver(dot)Elphick(at)lfix(dot)co(dot)uk
Isle of Wight http://www.lfix.co.uk/oliver
PGP: 1024R/32B8FAA1: 97 EA 1D 47 72 3F 28 47 6B 7E 39 CC 56 E4 C1 47
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C
========================================
"Dearly beloved, avenge not yourselves, but rather give
place unto wrath. For it is written, Vengeance is
mine; I will repay, saith the Lord. Therefore if thine
enemy hunger, feed him; if he thirst, give him drink;
for in so doing thou shalt heap coals of fire on his
head. Be not overcome of evil, but overcome evil with
good." Romans 12:19-21