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)
