[PHOENIX-2156] Support drop of column from table with views

• Type: Sub-task
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 4.8.0
• Assignee: Thomas D'Silva
• Reporter: James R. Taylor
• Created: 30/Jul/15 05:47
• Updated: 11/Aug/16 08:28
• Resolved: 13/Apr/16 01:37

Description

Much like PHOENIX-1504 allows a column to be added to a base view, we should support dropping a column from a table that has views as well. These seems like a simpler problem: you just need to query for all views with a BASE_COLUMN_COUNT < dropped_column_ordinal_pos, decrement the ordinal positions of columns after that, and drop indexes that reference the column being dropped.