[jira] [Created] (PHOENIX-6025) alter view column doesn't update ordinal position

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

Xinyi Yan created PHOENIX-6025:
----------------------------------

             Summary: alter view column doesn't update ordinal position
                 Key: PHOENIX-6025
                 URL: https://issues.apache.org/jira/browse/PHOENIX-6025
             Project: Phoenix
          Issue Type: Improvement
    Affects Versions: 4.15.0, 4.16.0
            Reporter: Xinyi Yan
             Fix For: 4.16.0


{code:java}
CREATE TABLE DUMMY (A BIGINT PRIMARY KEY);

CREATE VIEW DUMMY_VIEW (B BIGINT PRIMARY KEY, C BIGINT, D BIGINT) AS SELECT * FROM DUMMY;

SELECT COLUMN_NAME, ORDINAL_POSITION FROM SYSTEM.CATALOG WHERE TABLE_NAME = 'DUMMY_VIEW' AND ORDINAL_POSITION IS NOT NULL ORDER BY ORDINAL_POSITION;

+--------------+-------------------+                                                                  │
| COLUMN_NAME  | ORDINAL_POSITION  |                                                                  │
+--------------+-------------------+                                                                  │
| B            | 2                 |                                                                  │
| D            | 4                 |                                                                  │
+--------------+-------------------+ 

{code}
The right original position for D should be 3 instead of 4.



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