Subject: ISNULL dumps core

From: [email-masked] (Mahlon Stacy 4-4558)
Date: Thu, 17 Sep 92 09:12:53 -0700

Following Jeff's reply of July 24, saying 

>In version 4 you can say:
>
>	retrieve (test.all) where test.attr ISNULL

I tried the following query:

 retrieve (UDF.all) where  UDF.survey92 ISNULL \g

Query sent to backend is "retrieve (UDF.all) where  UDF.survey92 ISNULL "
Error: No response from the backend, exiting...

dumps core. The stack trace is:

route66# dbx ~postgres/bin/postgres core
Reading symbolic information...
Read 5736 symbols
program terminated by signal SEGV (no mapping at the fault address)
(dbx) where
NodeIsType() at 0xa118c
match_clause_to_indexkey() at 0x4b57c
group_clauses_by_indexkey() at 0x4b468
find_index_paths() at 0x4afb4
find_rel_paths() at 0x49200
find_paths() at 0x49160
subplanner() at 0x46d58
query_planner() at 0x46c04
init_query_planner() at 0x47ac4
planner() at 0x478d4
pg_plan() at 0x763e4
pg_eval_dest() at 0x764bc
pg_eval() at 0x76490
PostgresMain() at 0x77b6c
main() at 0x3b9bc

Is there a way to test for NULL attributes?

	-Mahlon
-------------------------------------------------------------
Mahlon Stacy                   Internet:   [email-masked]
Mayo Foundation                Amateur:    KF0AW
Rochester, MN 55905            Medical Science Bldg 1-29
(507) 284-4558                 FAX (507) 284-1428
-------------------------------------------------------------