[jira] [Created] (PHOENIX-6241) ViewIndexId sequences collide with ones created on the pre-4.15 version

["Xinyi Yan (Jira)" <ji...@apache.org>]

Xinyi Yan created PHOENIX-6241:
----------------------------------

             Summary: ViewIndexId sequences collide with ones created on the pre-4.15 version
                 Key: PHOENIX-6241
                 URL: https://issues.apache.org/jira/browse/PHOENIX-6241
             Project: Phoenix
          Issue Type: Bug
            Reporter: Xinyi Yan
             Fix For: 4.16.0


Start with 4.14 server and 4.14 client, create a table with PK (TENANT_ID, ID), create a global views with PK (A,B) and ID='firstView', and then create an index on firstView (a,b).

Upgrade to the current 4.x branch server and client jar, create another global view with the same PK(A,B) but id = 'secondView', and then create an index on secondView(a,b).

The sequence table created 2 rows and saw the sequence id collision(both of them have viewIndexid as SHORT.MIN_VALUE). This will cause index table data collisions because the index table starts with viewIndexId and tenantId in this case. 



--
This message was sent by Atlassian Jira
(v8.3.4#803005)