Uploaded image for project: 'Apache HAWQ'
  1. Apache HAWQ
  2. HAWQ-369

Hcatalog as reserved name

    XMLWordPrintableJSON

    Details

    • Type: New Feature
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 2.0.0.0-incubating
    • Component/s: PXF
    • Labels:

      Description

      https://github.com/apache/incubator-hawq/tree/master/src/test/regress

      With Hcatalog integration, we've reserved "hcatalog" as keyword for the following scenarios

      Acceptance Criteria
      1.

      CREATE DATABASE hcatalog

      should fail with a reserved name error

      "hcatalog" is a reserved name for hcatalog feature integration
      

      2.

      CREATE SCHEMA hcatalog

      should be fine.
      3.

      CREATE TABLE hcatalog(hcatalog int)

      should be fine, there is no ambiguity for table/column names.
      4.

      ALTER DATABASE name RENAME to hcatalog

      should fail with a reserved name error

      "hcatalog" is a reserved name for hcatalog feature integration

      5.

      ALTER DATABASE hcatalog RENAME to xxx

      should fail with a system error

      permission denied to ALTER DATABASE hcatalog is reserved for system use

      6.

      \connect hcatalog

      should fail with a system error

      hcatalog database is only for system use

      7. Add regression tests to the above scenarios

        Attachments

          Activity

            People

            • Assignee:
              odiachenko Oleksandr Diachenko
              Reporter:
              godenyao Goden Yao
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: