From a7cfd655322745b724523195f9879aa9896fa968 Mon Sep 17 00:00:00 2001
From: Marc G. Fournier
Date: Fri, 19 Jul 1996 07:14:14 +0000
Subject: Fixes:

Select queries with an isnull or notnull clause, like "select * where
somefield isnull", crash the backend if the table has at least one index.
If the indices are deleted the queries work again. Also the explain
command fail in the same way.
The is caused by a bug in subroutine of the optimizer which doesn't check
null values in the clauses.

Submitted by: Massimo Dal Zotto <dz@cs.unitn.it>
---
 src/backend/utils/adt/varlena.c | 4 +---
 1 file changed, 1 insertion(+), 3 deletions(-)

(limited to 'src/backend/utils')

diff --git a/src/backend/utils/adt/varlena.c b/src/backend/utils/adt/varlena.c
index e3f3c939306..7b186f02fe4 100644
--- a/src/backend/utils/adt/varlena.c
+++ b/src/backend/utils/adt/varlena.c
@@ -7,7 +7,7 @@
  *
  *
  * IDENTIFICATION
- *    $Header: /cvsroot/pgsql/src/backend/utils/adt/varlena.c,v 1.2 1996/07/19 06:08:21 scrappy Exp $
+ *    $Header: /cvsroot/pgsql/src/backend/utils/adt/varlena.c,v 1.3 1996/07/19 07:14:14 scrappy Exp $
  *
  *-------------------------------------------------------------------------
  */
@@ -198,8 +198,6 @@ textout(struct varlena *vlena)
 
 /* ========== PUBLIC ROUTINES ========== */
 
-/* 
-
 /*
  * textlen -
  *    returns the actual length of a text* (which may be less than
-- 
cgit v1.2.3