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

List:       pgsql-bugs
Subject:    [BUGS] BUG #8401: weird input accepted for intervals and geometric types
From:       borz_off () cs ! msu ! su
Date:       2013-08-27 9:04:03
Message-ID: E1VEFBz-0000Lh-QK () wrigleys ! postgresql ! org
[Download RAW message or body]

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.



-- 
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]