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

Allow column to be added to PK of a view when last PK column of table is variable length

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

Details

    • Bug
    • Status: Open
    • Major
    • Resolution: Unresolved
    • None
    • None
    • None
    • None

    Description

      We currently disallow adding a column to the PK of a view if the last column of the base table is variable length. The reason is that we would no longer be able to correctly read rows of the derived view from the base table. This is because we assume that we do not need to search for a separator byte for the last PK column. Instead, if the column is variable length, we'd navigate by searching for the terminator and stopping if we reach the end of the byte array.

      Attachments

        Activity

          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

            Unassigned Unassigned
            jamestaylor James R. Taylor

            Dates

              Created:
              Updated:

              Slack

                Issue deployment