Uploaded image for project: 'Phoenix'
  1. Phoenix
  2. PHOENIX-1508 VIEW enhancements
  3. PHOENIX-978

Allow views to extend base table's PK (only if last PK column is fixed length)

    Details

    • 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:

      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.

        Attachments

        1. PHOENIX-978-v2.patch
          50 kB
          Thomas D'Silva
        2. PHOENIX-978.patch
          32 kB
          Thomas D'Silva
        3. PHOENIX-978.final.patch
          51 kB
          Thomas D'Silva
        4. PHOENIX-978.diff
          14 kB
          Eli Levine

          Issue Links

            Activity

              People

              • Assignee:
                elilevine Eli Levine
                Reporter:
                elilevine Eli Levine
              • Votes:
                0 Vote for this issue
                Watchers:
                8 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: