[
https://issues.apache.org/jira/browse/HAWQ-369?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15129285#comment-15129285
]
ASF GitHub Bot commented on HAWQ-369:
-------------------------------------
Github user sansanichfb commented on a diff in the pull request:
https://github.com/apache/incubator-hawq/pull/324#discussion_r51652164
--- Diff: src/test/regress/output/hcatalog_lookup.source ---
@@ -266,6 +266,29 @@ select pg_catalog.pg_database_size('hcatalog');
ERROR: database hcatalog (OID 6120) is reserved (SOMEFILE:SOMEFUNC)
select pg_catalog.pg_database_size(6120);
ERROR: database hcatalog (OID 6120) is reserved (SOMEFILE:SOMEFUNC)
+--positive test: should be able to create table named "hcatalog"
+CREATE TABLE hcatalog(a int);
+--negative test: cannot create database named "hcatalog"
+CREATE DATABASE hcatalog;
+ERROR: "hcatalog" is a reserved name for hcatalog feature integration
+--allow renaming schemas and databases
+SET gp_called_by_pgdump = true;
+--negative test: cannot rename exiting database to "hcatalog"
+ALTER DATABASE regression RENAME TO hcatalog;
+ERROR: "hcatalog" is a reserved name for hcatalog feature integration
+--positive test: can rename exiting schema to "hcatalog"
--- End diff --
fixed
> Hcatalog as reserved name
> -------------------------
>
> Key: HAWQ-369
> URL: https://issues.apache.org/jira/browse/HAWQ-369
> Project: Apache HAWQ
> Issue Type: New Feature
> Components: PXF
> Reporter: Goden Yao
> Assignee: Goden Yao
> Labels: Hcatalog
>
> 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. {code}CREATE DATABASE hcatalog{code} should fail with a reserved name error
> {code}
> "hcatalog" is a reserved name for hcatalog feature integration
> {code}
> 2. {code}CREATE SCHEMA hcatalog{code} should be fine.
> 3. {code}CREATE TABLE hcatalog(hcatalog int){code} should be fine, there is
> no ambiguity for table/column names.
> 4. {code}ALTER DATABASE name RENAME to hcatalog{code} should fail with a
> reserved name error
> {code}"hcatalog" is a reserved name for hcatalog feature integration{code}
> 5. {code}ALTER DATABASE hcatalog RENAME to xxx{code} should fail with a
> system error
> {code}permission denied to ALTER DATABASE hcatalog is reserved for system
> use{code}
> 6. {code}\connect hcatalog{code} should fail with a system error
> {code}hcatalog database is only for system use{code}
> 7. Add regression tests to the above scenarios
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
