Bug in create type when missed the comma between element list

From: Diego <mrstephenamell(at)gmail(dot)com>
To: pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject: Bug in create type when missed the comma between element list
Date: 2024-11-04 16:17:14
Message-ID: 5bd6b5cd-ce74-4ff2-9cfb-c1c9e8e5b824@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi team!

I found this bug in the create type command. If you miss the comma
between the elements, the command doesn't fail; it runs and concatenates
the elements.

I detected the problem in v14.4, and it is alive in v17.

pglatest$ psql -h 127.0.0.1 -p 55532
Password for user daf:
Time: 0.481 ms
psql (16.4 (Ubuntu 16.4-1.pgdg24.04+2), server 17.0 (Debian
17.0-1.pgdg120+1))
WARNING: psql major version 16, server major version 17.
         Some psql features might not work.
Type "help" for help.

u: daf db: daf # CREATE TYPE test_enum AS ENUM(
    'one'
    'two',
    'three',
    'four'
);
CREATE TYPE
Time: 12.242 ms
u: daf db: daf # \dt+
Did not find any relations.
u: daf db: daf # \dT+
                                       List of data types
 Schema |   Name    | Internal name | Size | Elements | Owner | Access
privileges | Description
--------+-----------+---------------+------+----------+-------+-------------------+-------------
 public | test_enum | test_enum     | 4    | onetwo  +| daf
|                   |
        |           |               |      | three   +|
|                   |
        |           |               |      | four     |
|                   |
(1 row)

u: daf db: daf #

maybe, some of you can help me to report it properly.

Thank you,
Diego.

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message David G. Johnston 2024-11-04 16:19:38 Re: Bug in create type when missed the comma between element list
Previous Message Tom Lane 2024-11-04 16:10:01 Re: Converting contrib SQL functions to new style