I do not know if this is the correct place to post this
message but here goes...
I read the previous postings regarding the query 
optimizer crashing with regards to ANDS and ORS and 
apparently it is this same code which will crash the
following query:

select supply, location, chgdate from charges where
supply in ('111111', '222222') and location in ('4 EAST') 

because the optimizer is reducing the location in ('4 EAST') to
location = '4 EAST', and then hitting the 
bug in the optimizer.  Therefore, I have to always 
generate queries as follows:

select supply, location, chgdate from charges where
supply in ('111111', '222222') and location in 
('4 EAST', 'garbage to trick postgres')

and I receive the expected results.

Here is the backtrace:

Core was generated by `/usr/local/pgsql/bin/postgres localhost
mmsadmin m'.
Program terminated with signal 11, Segmentation fault.
Reading symbols from /lib/libdl.so.1...done.
Reading symbols from /lib/libm.so.5...done.
Reading symbols from /lib/libtermcap.so.2...done.
Reading symbols from /lib/libncurses.so.3.0...done.
Reading symbols from /lib/libc.so.5...done.
Reading symbols from /lib/ld-linux.so.1...done.
#0  0x80af4e0 in equal_path_path_ordering ()
(gdb) bt
#0  0x80af4e0 in equal_path_path_ordering ()
#1  0x80af6d3 in better_path ()
#2  0x80af648 in add_pathlist ()
#3  0x80a5618 in find_rel_paths ()
#4  0x80a5583 in find_paths ()
#5  0x80aa19d in subplanner ()
#6  0x80aa0d4 in query_planner ()
#7  0x80aa71f in union_planner ()
#8  0x80aa5d1 in planner ()
#9  0x80d5fc0 in pg_parse_and_plan ()
#10 0x80d60eb in pg_exec_query_dest ()
#11 0x80d60ac in pg_exec_query ()
#12 0x80d7114 in PostgresMain ()
#13 0x80c3580 in DoBackend ()
#14 0x80c30ce in BackendStartup ()
#15 0x80c2856 in ServerLoop ()
#16 0x80c2468 in PostmasterMain ()
#17 0x809bec0 in main ()
#18 0x80606fe in _start ()

I hope this helps.  I love postgres except for this 
single bug which rears its ugly head on one-to-many 
an occassion.

Marcus Mascari







_________________________________________________________
DO YOU YAHOO!?
Get your free @yahoo.com address at http://mail.yahoo.com


Mon, 21 Sep 1998 19:38:35 -0700 (PDT)
Marcus Mascari <mascarim@yahoo.com>
backend crashes under 6.4beta