Content-Type: multipart/alternative;
 boundary="------------nFslT5enzVxmIxGwnB2Jnc7v"
Message-ID: <5bd6b5cd-ce74-4ff2-9cfb-c1c9e8e5b824@gmail.com>
Date: Mon, 4 Nov 2024 13:17:14 -0300
MIME-Version: 1.0
User-Agent: Betterbird (Linux)
Content-Language: en-US
To: pgsql-hackers@lists.postgresql.org
From: Diego <mrstephenamell@gmail.com>
Subject: Bug in create type when missed the comma between element list
Archived-At: <https://www.postgresql.org/message-id/5bd6b5cd-ce74-4ff2-9cfb-c1c9e8e5b824%40gmail.com>
Precedence: bulk

This is a multi-part message in MIME format.
--------------nFslT5enzVxmIxGwnB2Jnc7v
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit

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.

--------------nFslT5enzVxmIxGwnB2Jnc7v
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 8bit

<!DOCTYPE html>
<html>
  <head>

    <meta http-equiv="content-type" content="text/html; charset=UTF-8">
  </head>
  <body>
    Hi team!<br>
    <br>
    <p>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.</p>
    <p>I detected the problem in v14.4, and it is alive in v17.</p>
    <p>pglatest$ psql -h 127.0.0.1 -p 55532<br>
      Password for user daf: <br>
      Time: 0.481 ms<br>
      psql (16.4 (Ubuntu 16.4-1.pgdg24.04+2), server 17.0 (Debian
      17.0-1.pgdg120+1))<br>
      WARNING: psql major version 16, server major version 17.<br>
               Some psql features might not work.<br>
      Type "help" for help.<br>
      <br>
      u: daf db: daf # CREATE TYPE test_enum AS ENUM(<br>
          'one'<br>
          'two',<br>
          'three',<br>
          'four'<br>
      );<br>
      CREATE TYPE<br>
      Time: 12.242 ms<br>
      u: daf db: daf # \dt+<br>
      Did not find any relations.<br>
      u: daf db: daf # \dT+<br>
                                             List of data types<br>
       Schema |   Name    | Internal name | Size | Elements | Owner |
      Access privileges | Description <br>
--------+-----------+---------------+------+----------+-------+-------------------+-------------<br>
       public | test_enum | test_enum     | 4    | onetwo  +| daf  
      |                   | <br>
              |           |               |      | three   +|      
      |                   | <br>
              |           |               |      | four     |      
      |                   | <br>
      (1 row)<br>
      <br>
      u: daf db: daf # <br>
    </p>
    <p><br>
    </p>
    <p>maybe, some of you can help me to report it properly.</p>
    <p>Thank you,<br>
      Diego.<br>
    </p>
  </body>
</html>

--------------nFslT5enzVxmIxGwnB2Jnc7v--