[
https://issues.apache.org/jira/browse/HIVE-15976?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16520257#comment-16520257
]
Hive QA commented on HIVE-15976:
--------------------------------
Here are the results of testing the latest attachment:
https://issues.apache.org/jira/secure/attachment/12928609/HIVE-15976.08.patch
{color:green}SUCCESS:{color} +1 due to 1 test(s) being added or modified.
{color:green}SUCCESS:{color} +1 due to 14590 tests passed
Test results:
https://builds.apache.org/job/PreCommit-HIVE-Build/11993/testReport
Console output: https://builds.apache.org/job/PreCommit-HIVE-Build/11993/console
Test logs: http://104.198.109.242/logs/PreCommit-HIVE-Build-11993/
Messages:
{noformat}
Executing org.apache.hive.ptest.execution.TestCheckPhase
Executing org.apache.hive.ptest.execution.PrepPhase
Executing org.apache.hive.ptest.execution.YetusPhase
Executing org.apache.hive.ptest.execution.ExecutionPhase
Executing org.apache.hive.ptest.execution.ReportingPhase
{noformat}
This message is automatically generated.
ATTACHMENT ID: 12928609 - PreCommit-HIVE-Build
> Support CURRENT_CATALOG and CURRENT_SCHEMA
> ------------------------------------------
>
> Key: HIVE-15976
> URL: https://issues.apache.org/jira/browse/HIVE-15976
> Project: Hive
> Issue Type: Sub-task
> Components: SQL
> Reporter: Carter Shanklin
> Assignee: Laszlo Bodor
> Priority: Major
> Attachments: HIVE-15976.01.patch, HIVE-15976.02.patch,
> HIVE-15976.03.patch, HIVE-15976.04.patch, HIVE-15976.05.patch,
> HIVE-15976.06.patch, HIVE-15976.07.patch, HIVE-15976.08.patch
>
>
> Support these keywords for querying the current catalog and schema. SQL
> reference: section 6.4
> *oracle*
> CREATE TABLE CURRENT_SCHEMA (col VARCHAR2(1)); -- ok
> SELECT CURRENT_SCHEMA FROM DUAL; -- error, ORA-00904: "CURRENT_SCHEMA":
> invalid identifier
> SELECT CURRENT_SCHEMA() FROM DUAL; -- error, ORA-00904: "CURRENT_SCHEMA":
> invalid identifier
> *postgres*
> CREATE TABLE CURRENT_SCHEMA (col VARCHAR(1)); -- error: syntax error at or
> near "CURRENT_SCHEMA"
> SELECT CURRENT_SCHEMA; -- ok, "public"
> SELECT CURRENT_SCHEMA(); -- ok, "public"
> *mysql*
> CREATE TABLE CURRENT_SCHEMA (col VARCHAR(1)); -- ok
> SELECT CURRENT_SCHEMA; -- error, Unknown column 'CURRENT_SCHEMA' in 'field
> list'
> SELECT CURRENT_SCHEMA(); -- error, FUNCTION db_9_e28e6f.CURRENT_SCHEMA does
> not exist
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
