Uploaded image for project: 'Phoenix'
  1. Phoenix
  2. PHOENIX-1327

Disallow creating arrays of fixed width base type without the max length being specified

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Duplicate
    • None
    • 4.2.0, 3.2.0
    • None
    • None

    Description

      Today, we allow a user to specify an array who base type is of fixed width as:

      CREATE TABLE foo (k BINARY_ARRAY NOT NULL PRIMARY KEY)

      This shouldn't be allowed as for fixed width data types like CHAR and BINARY, specifying a max length is mandatory.

      These alternate statements properly enforce the max length constraint:
      CREATE TABLE foo (k BINARY ARRAY NOT NULL PRIMARY KEY)
      CREATE TABLE foo (k BINARY[] NOT NULL PRIMARY KEY)

      Attachments

        Activity

          People

            samarthjain Samarth Jain
            samarthjain Samarth Jain
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: