Re: BUG #8395: empty aclitem arrays are considered 1-dimensional

On Fri, Aug 23, 2013 at 04:17:55PM +0000, bashtanov(at)imap(dot)cc wrote:
> The following bug has been logged on the website:
>
> Bug reference: 8395
> Logged by: Alexey Bashtanov
> Email address: bashtanov(at)imap(dot)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

Can someone comment on this bug report?

--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com

+ Everyone has their own god. +