Bug#90856: postgresql: query with unused table in from clause causes crash (fwd) - Mailing list pgsql-general

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@enhanced.com>
To:      "Oliver Elphick" <olly@lfix.co.uk>
cc:      90856@bugs.debian.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@lfix.co.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.Elphick@lfix.co.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@enhanced.com
==========================================================================
"The earth is but one country, and mankind its citizens."  --  Baha'u'llah


------- End of Forwarded Message


--
Oliver Elphick                                Oliver.Elphick@lfix.co.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