8.2 Crash on Query

Started by D. Hagemanabout 19 years ago2 messages
#1D. Hageman
dhageman@dracken.com
3 attachment(s)

I have been able to crash the database consistently on a Fedora Core 5
machine running postgresql 8.2.0.

The attached files are an example database (crash.shema) and the query
that is used (crash.sql) as well as the log output from turning on all the
debugging (crash.log).

I have a couple of other queries that do this as well, but this is the
first one that I noticed. This database schema and query works fine
version 8.1.4.

--
//========================================================\\
|| D. Hageman <dhageman@dracken.com> ||
\\========================================================//

Attachments:

crash.logtext/plain; charset=US-ASCII; name=crash.logDownload
crash.sqltext/plain; charset=US-ASCII; name=crash.sqlDownload
crash.schematext/plain; charset=US-ASCII; name=crash.schemaDownload
#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: D. Hageman (#1)
Re: 8.2 Crash on Query

"D. Hageman" <dhageman@dracken.com> writes:

I have been able to crash the database consistently on a Fedora Core 5
machine running postgresql 8.2.0.

Yeah, LIMIT ALL is known broken in 8.2.0 :-(. It's been fixed for
awhile, will be in 8.2.1.

regards, tom lane