phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Xinyi Yan (Jira)" <j...@apache.org>
Subject [jira] [Created] (PHOENIX-6025) alter view column doesn't update ordinal position
Date Fri, 17 Jul 2020 20:43:00 GMT
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)

Mime
View raw message