[ https://issues.apache.org/jira/browse/PHOENIX-6025?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Xinyi Yan resolved PHOENIX-6025. -------------------------------- Resolution: Won't Fix > 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 > Priority: Major > 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)