BUG #3796: crash after select from indexed columns - Mailing list pgsql-bugs

The following bug has been logged online:

Bug reference:      3796
Logged by:          Matthias
Email address:      matthias.schoeneich@gmx.net
PostgreSQL version: 8.3beta3
Operating system:   Win XP SP2
Description:        crash after select from indexed columns
Details:

Hi all,

I'm not sure if this is the correct group to post, so please feel free to
move this report to the correct one.
Playing with the beta I was able to crash the server(fresh installed, no
config change except logging) with a simple select. Maybe you are able to
reproduce the behavior using the following script. I added as much
information as I could get (script output, server log and windows event
log).



Best regards
Matthias
(sorry for my bad english)


------------------------------------
script------------------------------------
select version();
drop table if exists test;
create table test (test_id integer   ,
                   value   integer  );

create        index test_value_id on test(value,test_id);


select max(test_id) from test where value is null;



------------------------------------ script output
------------------------------------
                       version
--------------------------------------------------------
 PostgreSQL 8.3beta3, compiled by Visual C++ build 1400
(1 row)

psql:C:/Temp/Edit781:3: NOTICE:  table "test" does not exist, skipping
DROP TABLE
CREATE TABLE
CREATE INDEX
psql:C:/Temp/Edit781:10: server closed the connection unexpectedly
    This probably means the server terminated abnormally
    before or while processing the request.
psql:C:/Temp/Edit781:10: connection to server was lost

------------------------------------ server log
------------------------------------
2007-12-03 21:42:53 CET LOG:  00000: statement: select max(test_id) from
test where value is null;
2007-12-03 21:42:53 CET LOCATION:  exec_simple_query,
.\src\backend\tcop\postgres.c:827


This application has requested the Runtime to terminate it in an unusual
way.
Please contact the application's support team for more information.

2007-12-03 21:42:55 CET LOG:  00000: server process (PID 2572) exited with
exit code 3
2007-12-03 21:42:55 CET LOCATION:  LogChildExit,
.\src\backend\postmaster\postmaster.c:2490
2007-12-03 21:42:55 CET LOG:  00000: terminating any other active server
processes
2007-12-03 21:42:55 CET LOCATION:  HandleChildCrash,
.\src\backend\postmaster\postmaster.c:2355
2007-12-03 21:42:55 CET LOG:  00000: all server processes terminated;
reinitializing
2007-12-03 21:42:55 CET LOCATION:  PostmasterStateMachine,
.\src\backend\postmaster\postmaster.c:2663
2007-12-03 21:42:56 CET FATAL:  XX000: pre-existing shared memory block is
still in use
2007-12-03 21:42:56 CET HINT:  Check if there are any old server processes
still running, and terminate them.
2007-12-03 21:42:56 CET LOCATION:  PGSharedMemoryCreate,
.\src\backend\port\win32_shmem.c:168

------------------------------------ windows event log
------------------------------------
TRAP: FailedAssertion("!(((rinfo->clause) != ((void *)0) &&
((((Node*)(rinfo->clause))->type) == T_OpExpr)))", File:
".\src\backend\optimizer\plan\planagg.c", Line: 371)