[
https://issues.apache.org/jira/browse/TRAFODION-370?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Suresh Subbiah resolved TRAFODION-370.
--------------------------------------
Resolution: Won't Fix
> LP Bug: 1328698 - Get schemas does not return a schema being used in Trafci
> ---------------------------------------------------------------------------
>
> Key: TRAFODION-370
> URL: https://issues.apache.org/jira/browse/TRAFODION-370
> Project: Apache Trafodion
> Issue Type: Bug
> Components: sql-exe
> Reporter: Weishiun Tsai
> Assignee: Suresh Subbiah
> Priority: Critical
> Fix For: 1.1 (pre-incubation)
>
>
> This is a strange behavior that we sometimes saw in Trafci. As shown in the
> following execution output, the schema ‘TRAF_SYNTAX_MISC’ is being used. It
> contains the table MYTABLE and MYVIEW, but ‘get schemas’ does not return the
> schema name at all. This problem only seem to exist in Trafci. Running the
> same sequence of commands from sqlci returns the schema name just fine.
> This problem is seen on the GIT 0606_0930 build installed on a cluster
> (centos-mapr1 in this case). There may be a caching issue somewhere. This
> problem may seem minor, but we have seen our Trafodion metadata falls into an
> inconsistent state and suspect that this strange behavior may be related.
> Therefore we want to document it.
> -bash-4.1$ trafci.sh -h centos-mapr1.hpl.hp.com:37800 -u dontcare -p dontcare
> Welcome to Trafodion Command Interface
> Copyright(C) 2013-2014 Hewlett-Packard Development Company, L.P.
> Host Name/IP Address: centos-mapr1.hpl.hp.com:37800
> User Name: dontcare
> Connected to Trafodion
> SQL>get schemas;
> Schemas in Catalog TRAFODION
> ============================
> G_ARKCASEDB
> G_CMUREG
> G_SQLDOPT
> G_SQLDPOP
> G_TPCDS1X
> OPENCART
> SCH2
> SEABASE
> T001A
> T001B
> VOLATILE_SCHEMA_MXID110030325812122688891779899280000000002
> _MD_
> --- SQL operation complete.
> SQL>set schema TRAF_SYNTAX_MISC;
> --- SQL operation complete.
> SQL>create table mytable (a int);
> --- SQL operation complete.
> SQL>get schemas;
> Schemas in Catalog TRAFODION
> ============================
> G_ARKCASEDB
> G_CMUREG
> G_SQLDOPT
> G_SQLDPOP
> G_TPCDS1X
> OPENCART
> SCH2
> SEABASE
> T001A
> T001B
> VOLATILE_SCHEMA_MXID110030325812122688891779899280000000002
> _MD_
> --- SQL operation complete.
> SQL>create view myview as select * from mytable;
> --- SQL operation complete.
> SQL>get schemas;
> Schemas in Catalog TRAFODION
> ============================
> G_ARKCASEDB
> G_CMUREG
> G_SQLDOPT
> G_SQLDPOP
> G_TPCDS1X
> OPENCART
> SCH2
> SEABASE
> T001A
> T001B
> VOLATILE_SCHEMA_MXID110030325812122688891779899280000000002
> _MD_
> --- SQL operation complete.
> SQL>
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
