Uploaded image for project: 'Phoenix'
  1. Phoenix
  2. PHOENIX-4035

Consider tables and sequences under same namespace in Phoenix-Calcite

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None

      Description

      Currently tables and sequences are different namespaces so there can be sequences with table names or vice versa but in calcite sequences are resolved as tables so it's very difficult to distinguish them when the names are same. Physically we can have different tables for both sequences and tables but if we don't allow to create sequences or tables with existing names.

      And at the same time Calcite expects table names also should not match with schema names so we should not allow creating tables with existing schema names as well.

      FYI James R. Taylor Julian Hyde Ankit Singhal.

        Attachments

          Activity

            People

            • Assignee:
              rajeshbabu Rajeshbabu Chintaguntla
              Reporter:
              rajeshbabu Rajeshbabu Chintaguntla
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated: