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

Phoenix allows duplicate column names when one of them is a primary key

Attach filesAttach ScreenshotVotersWatch issueWatchersCreate sub-taskLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 5.0.0, 4.15.0
    • Fix Version/s: 5.1.1, 4.16.0, 5.2.0
    • Component/s: core
    • Labels:
      None
    • Release Note:
      Although user provided CF can have same column name as one of primary keys, default CF is no longer supported to have same column name as primary key columns.

      Description

      CREATE TABLE IF NOT EXISTS test_duplicate_columns (
      name VARCHAR NOT NULL PRIMARY KEY,
      city VARCHAR, name VARCHAR);
      
      select * from test_duplicate_columns;
      +------+------+------+
      | NAME | CITY | NAME |
      +------+------+------+
      +------+------+------+
      No rows selected (0.015 seconds)
      

        Attachments

          Activity

            People

            • Assignee:
              vjasani Viraj Jasani
              Reporter:
              stoty Istvan Toth

              Dates

              • Created:
                Updated:
                Resolved:

                Issue deployment