Details
-
New Feature
-
Status: Resolved
-
Major
-
Resolution: Fixed
-
None
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