BUG #8401: weird input accepted for intervals and geometric types

Поиск
Список
Период
Сортировка
От borz_off@cs.msu.su
Тема BUG #8401: weird input accepted for intervals and geometric types
Дата
Msg-id E1VEFBz-0000Lh-QK@wrigleys.postgresql.org
обсуждение исходный текст
Список pgsql-bugs
The following bug has been logged on the website:

Bug reference:      8401
Logged by:          Alexey Borzov
Email address:      borz_off@cs.msu.su
PostgreSQL version: 9.3rc1
Operating system:   irrelevant
Description:

For interval, multiple units:


postgres=# select '1 year day second'::interval;
 interval
----------
 1 year
(1 row)


Geometric, missing comma:


postgres=# select '(1,2)(3,4)'::box, '1,2 3,4'::box;
     box     |     box
-------------+-------------
 (3,4),(1,2) | (3,4),(1,2)
(1 row)


Geometric, one trailing comma:


postgres=# select '(1,2)(3,4),'::box;
     box
-------------
 (3,4),(1,2)
(1 row)


Geometric, more trailing commas:


postgres=# select '(1,2)(3,4)(5,6),,'::path;
        path
---------------------
 ((1,2),(3,4),(5,6))
(1 row)


Geometric, unbalanced delimiters:


postgres=# select '(1,2),3)'::circle;
  circle
-----------
 <(1,2),3>
(1 row)


Geometric, mismatched delimiters:


postgres=# select '((1,2),3>'::circle;
  circle
-----------
 <(1,2),3>
(1 row)


Confirmed on 9.0.13 and 9.3rc1, dates waaaaaay back.

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

Предыдущее
От: borz_off@cs.msu.su
Дата:
Сообщение: BUG #8399: inconsistent input of multidimensional arrays
Следующее
От: vincent@searidgetech.com
Дата:
Сообщение: BUG #8403: installing PostgreSQL breaks future registration of w32tm service