[prev in list] [next in list] [prev in thread] [next in thread] 

List:       pgsql-bugs
Subject:    [BUGS] BUG #8395: empty aclitem arrays are considered 1-dimensional
From:       bashtanov () imap ! cc
Date:       2013-08-23 16:17:55
Message-ID: E1VCu3f-0000Hh-JU () wrigleys ! postgresql ! org
[Download RAW message or body]

The following bug has been logged on the website:

Bug reference:      8395
Logged by:          Alexey Bashtanov
Email address:      bashtanov@imap.cc
PostgreSQL version: 9.1.9
Operating system:   Ubuntu linux 12.04
Description:        

Empty aclitem arrays are considered 1-dimensional, but in general empty
arrays are 0-dimensional. It leads to the following problems:


STEPS TO REPRODUCE
1) install fresh postgres, connect to it
2) select relacl, relacl = '{}'::aclitem[], (select aclexplode(relacl)),
array_length(relacl, 1) from pg_class where oid::regclass =
'pg_largeobject'::regclass;
3) select aclexplode('{}'::aclitem[]);


EXPECTED
2) {}, false, null, null
3) no error, zero-lines table


GOT
2)  relacl | ?column? | ?column? | array_length 
--------+----------+----------+--------------
 {}     | f        |          |            0
3) ERROR:  ACL arrays must be one-dimensional


also it can be reproduced on some 9.2 version






-- 
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
[prev in list] [next in list] [prev in thread] [next in thread]