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

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Duplicate
    • Affects Version/s: None
    • Fix Version/s: 4.2.0, 3.2.0
    • Labels:
      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

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

              Dates

              • Created:
                Updated:
                Resolved: