[PHOENIX-978] Allow views to extend base table's PK (only if last PK column is fixed length)

• Type: Sub-task
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 3.0.0, 4.0.0
• Fix Version/s: 4.5.0
• Labels: SFDC
• Assignee: Eli Levine
• Reporter: Eli Levine
• Created: 12/May/14 20:51
• Updated: 21/Nov/15 02:15
• Resolved: 15/Jul/15 01:18

Description

CREATE VIEW syntax currently disallows PK constraint to be defined. As a result views and tenant-specific tables created using CREATE VIEW automatically inherit their base table's PK with no way to extend it.

Base tables should be allowed to be created with a minimum of PK columns to support views, and views to extend PKs as desired. This would allow a single base table to support a heterogeneous set of views on top of it.

Issue Links

• is cloned by: PHOENIX-2104 Allow views to extend base table's PK even if last PK col is variable lengthnly if last PK column is fixed length)