Bug ? different behaviour between 8.3 and 8.4 won IS NULL with sub arrays of nulls

From: ioguix(at)free(dot)fr
To: PostgreSQL-development Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Bug ? different behaviour between 8.3 and 8.4 won IS NULL with sub arrays of nulls
Date: 2010-01-19 15:19:11
Message-ID: alpine.DEB.2.00.1001191600101.25223@xigix.ioguix.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,

I found a difference of behaviour between 8.3 and 8.4 on IS NULL with
multi-level arrays with NULL values.

I looked at the Changelog between 8.3 and 8.4, but I didn't find something
really clear about this.

Is this a bug or a known issue or a normal, documented,
difference of behaviour ?

See the following use case:

<~~~~~~~~~~~~~~~~~~~~~~~~
$ psql -p 5433 -U postgres -h localhost -c \
'SELECT substring(version() from 0 for 15),
ROW(NULL,NULL) IS NULL, ROW(ROW(NULL),NULL) IS NULL;'

substring | ?column? | ?column?
----------------+----------+----------
PostgreSQL 8.3 | t | f
(1 ligne)

$ psql -p 5434 -U postgres -h localhost -c \
'SELECT substring(version() from 0 for 15),
ROW(NULL,NULL) IS NULL, ROW(ROW(NULL),NULL) IS NULL;'

substring | ?column? | ?column?
----------------+----------+----------
PostgreSQL 8.4 | t | t
(1 ligne)
~~~~~~~~~~~~~~~~~~~~~~~~>

Regards,
--
Jehan-Guillaume (ioguix) de Rorthais
DBA
http://www.dalibo.com

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Magnus Hagander 2010-01-19 15:19:58 Re: RADIUS authentication
Previous Message Andres Freund 2010-01-19 15:03:16 Re: [HACKERS] Re: Faster CREATE DATABASE by delaying fsync (was 8.4.1 ubuntu karmic slow createdb)