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

Поиск
Список
Период
Сортировка
От bashtanov@imap.cc
Тема BUG #8395: empty aclitem arrays are considered 1-dimensional
Дата
Msg-id E1VCu3f-0000Hh-JU@wrigleys.postgresql.org
обсуждение исходный текст
Ответы Re: BUG #8395: empty aclitem arrays are considered 1-dimensional  (Bruce Momjian <bruce@momjian.us>)
Список pgsql-bugs
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

В списке pgsql-bugs по дате отправления:

Предыдущее
От: yzhang@trinityusa.com
Дата:
Сообщение: BUG #8394: SQL command REINDEX doesn't work
Следующее
От: Thomas Kellerer
Дата:
Сообщение: Re: BUG #8394: SQL command REINDEX doesn't work