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

From: borz_off(at)cs(dot)msu(dot)su
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #8401: weird input accepted for intervals and geometric types
Date: 2013-08-27 09:04:03
Message-ID: E1VEFBz-0000Lh-QK@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 8401
Logged by: Alexey Borzov
Email address: borz_off(at)cs(dot)msu(dot)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.

Browse pgsql-bugs by date

  From Date Subject
Next Message bughunt 2013-08-27 09:30:52 BUG #8402: Bad error message by psql
Previous Message ajayaksadvance 2013-08-27 08:31:30 BUG #8400: DB size changed after restore