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

Incorrect index rowkey generated when updating only non-indexed columns after a delete

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

Details

    • Bug
    • Status: Closed
    • Critical
    • Resolution: Resolved
    • 4.14.0
    • 4.14.1, 5.1.0
    • None
    • None

    Description

      The following steps result in an incorrect index rowkey being generated after an index update to a non-indexed column.

      create table test (k VARCHAR NOT NULL PRIMARY KEY, v1 VARCHAR, v2 VARCHAR)
      create index test_ind ON test (v2)
      upsert into test (k,v1,v2) VALUES ('testKey','v1_1','v2_1');
      delete from test;
      upsert into test (k,v1,v2) VALUES ('testKey','v1_2','v2_2');
      delete from test;
      upsert into test (k,v1) VALUES ('testKey','v1_3');

      Attachments

        Issue Links

        Activity

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

          People

            vincentpoon Vincent Poon
            vincentpoon Vincent Poon
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Slack

                Issue deployment