============================================================================
POSTGRESQL BUG REPORT TEMPLATE
============================================================================
Your name : Rodney McDuff
Your email address : mcduff@its.uq.edu.au
Category : runtime: back-end
Severity : critical
Summary: rules regression test SEGV
System Configuration
--------------------
Operating System : Digital Unix 4.0D
PostgreSQL version : 6.5.1
Compiler used : cc
Hardware:
---------
OSF1 V4.0 878 alpha
Versions of other tools:
------------------------
--------------------------------------------------------------------------
Problem Description:
--------------------
The rules regress test in 6.5.1 fails on DU 4.0D with a
segmenation fault at the sql line 'update rtest_v1 set a = rtest_t3.a + 20 where b = rtest_t3.b;'
dbx /usr/local/pgsql/bin/postgres
dbx version 3.11.10
Type 'help' for help.
main: Source not available
(dbx) run regression
POSTGRES backend interactive interface
$Revision: 1.119 $ $Date: 1999/07/02 18:09:27 $
backend> update rtest_v1 set a = rtest_t3.a + 20 where b = rtest_t3.b;
signal Segmentation fault at [replace_opid:95 ,0x1200de984] Source not available
(dbx) where
> 0 replace_opid(oper = 0x40257280) ["nodeFuncs.c":95, 0x1200de984]
1 fix_opid_walker(node = 0x140257250, context = (nil)) ["clauses.c":539, 0x1200ffbfc]
2 fix_opid(clause = 0x140257250) ["clauses.c":530, 0x1200ffba4]
3 preprocess_targetlist(tlist = 0x140235330, command_type = 2, result_relation = 5, range_table = 0x140257960)
["preptlist.c":84,0x1200fd6c0]
4 union_planner(parse = 0x1402343a0) ["planner.c":161, 0x1200f838c]
5 planner(parse = 0x1402343a0) ["planner.c":83, 0x1200f81d8]
6 pg_parse_and_plan(query_string = 0x11fffb858 = "update rtest_v1 set a = rtest_t3.a + 20 where b = rtest_t3.b;\n",
typev= (nil), nargs = 0, queryListP = 0x11fffb7a8, dest = Debug, aclOverride = '^@') ["postgres.c":590, 0x1201333ec]
7 pg_exec_query_dest(query_string = 0x11fffb858 = "update rtest_v1 set a = rtest_t3.a + 20 where b = rtest_t3.b;\n",
dest= Debug, aclOverride = '^@') ["postgres.c":678, 0x120133690]
8 pg_exec_query(query_string = 0x11fffb858 = "update rtest_v1 set a = rtest_t3.a + 20 where b = rtest_t3.b;\n")
["postgres.c":656,0x1201335dc]
9 PostgresMain(argc = 2, argv = 0x11ffff8a8, real_argc = 2, real_argv = 0x11ffff8a8) ["postgres.c":1647,
0x12013506c]
10 main(argc = 2, argv = 0x11ffff8a8) ["main.c":103, 0x1200c1904]
--------------------------------------------------------------------------
Test Case:
----------
--------------------------------------------------------------------------
Solution:
---------
--------------------------------------------------------------------------