You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@trafodion.apache.org by "Alice Chen (JIRA)" <ji...@apache.org> on 2015/07/22 20:15:09 UTC
[jira] [Created] (TRAFODION-191) LP Bug: 1289120 - trafci does not
reset CQD after 'CQD * RESET'
Alice Chen created TRAFODION-191:
------------------------------------
Summary: LP Bug: 1289120 - trafci does not reset CQD after 'CQD * RESET'
Key: TRAFODION-191
URL: https://issues.apache.org/jira/browse/TRAFODION-191
Project: Apache Trafodion
Issue Type: Bug
Components: client-ci
Reporter: Weishiun Tsai
Assignee: Arvind Narain
In trafci, the statement CONTROL QUERY DEFAULT * RESET does not reset the SCHEMA CQD, as shown in the first part of the output. After using CONTROL QUERY DEFAULT SCHEMA ‘myschema’ to change the schema, a CONTROL QUERY DEFAULT * RESET does not restore the schema. Only CONTROL QUERY DEFAULT SCHEMA RESET takes effect.
This problem does not exist in sqlci. As shown in the second part of the output, both CONTROL QUERY DEFAULT * RESET, and CONTROL QUERY DEFAULT SCHEMA RESET reset the schema.
This is seen on the datalake build trafodion-ci-project-datalake_64_1-20140303-v38027_release.tar.
=====================================================
Output from trafci
=====================================================
Welcome to Trafodion Command Interface
Copyright(C) 2013-2014 Hewlett-Packard Development Company, L.P.
Host Name/IP Address: sqws138.houston.hp.com:37800
User Name: dont
Connected to Trafodion
SQL>env;
COLSEP " "
HISTOPT DEFAULT [No expansion of script files]
IDLETIMEOUT 30 min(s)
LIST_COUNT 0 [All Rows]
LOG OFF
MARKUP RAW
PROMPT SQL>
SCHEMA SEABASE
SERVER sqws138.houston.hp.com:37800
SQLTERMINATOR ;
STATISTICS OFF
TIME OFF
TIMING OFF
USER dont
SQL>control query default schema 'myschema';
--- SQL operation complete.
SQL>env;
COLSEP " "
HISTOPT DEFAULT [No expansion of script files]
IDLETIMEOUT 30 min(s)
LIST_COUNT 0 [All Rows]
LOG OFF
MARKUP RAW
PROMPT SQL>
SCHEMA MYSCHEMA
SERVER sqws138.houston.hp.com:37800
SQLTERMINATOR ;
STATISTICS OFF
TIME OFF
TIMING OFF
USER dont
SQL>control query default * reset;
--- SQL operation complete.
SQL>env;
COLSEP " "
HISTOPT DEFAULT [No expansion of script files]
IDLETIMEOUT 30 min(s)
LIST_COUNT 0 [All Rows]
LOG OFF
MARKUP RAW
PROMPT SQL>
SCHEMA MYSCHEMA
SERVER sqws138.houston.hp.com:37800
SQLTERMINATOR ;
STATISTICS OFF
TIME OFF
TIMING OFF
USER dont
SQL>control query default schema reset;
--- SQL operation complete.
SQL>env;
COLSEP " "
HISTOPT DEFAULT [No expansion of script files]
IDLETIMEOUT 30 min(s)
LIST_COUNT 0 [All Rows]
LOG OFF
MARKUP RAW
PROMPT SQL>
SCHEMA SEABASE
SERVER sqws138.houston.hp.com:37800
SQLTERMINATOR ;
STATISTICS OFF
TIME OFF
TIMING OFF
USER dont
SQL>
=====================================================
Output from sqlci
=====================================================
-bash-4.1$ sqlci
Trafodion Conversational Interface 0.7.0
(c) Copyright 2014 Hewlett-Packard Development Company, LP.
>>env;
----------------------------------
Current Environment
----------------------------------
CURRENT DIRECTORY /opt/home/wtsai/dlv38027/trafci/bin
LIST_COUNT 4294967295
LOG FILE
MESSAGEFILE /opt/home/wtsai/dlv38027/export/bin64/mxcierrors.cat
TERMINAL CHARSET ISO88591
MESSAGEFILE LANG US English
MESSAGEFILE VRSN {2014-03-03 17:43 LINUX:G4T2992.HOUSTON.HP.COM/sqlnxadm}
SQL USER NAME DB__ROOT
SQL USER ID 99999
SQL CATALOG TRAFODION
SQL SCHEMA SEABASE
TRANSACTION ID
TRANSACTION STATE not in progress
WARNINGS on
>>control query default schema 'myschema';
--- SQL operation complete.
>>env;
----------------------------------
Current Environment
----------------------------------
CURRENT DIRECTORY /opt/home/wtsai/dlv38027/trafci/bin
LIST_COUNT 4294967295
LOG FILE
MESSAGEFILE /opt/home/wtsai/dlv38027/export/bin64/mxcierrors.cat
TERMINAL CHARSET ISO88591
MESSAGEFILE LANG US English
MESSAGEFILE VRSN {2014-03-03 17:43 LINUX:G4T2992.HOUSTON.HP.COM/sqlnxadm}
SQL USER NAME DB__ROOT
SQL USER ID 99999
SQL CATALOG TRAFODION
SQL SCHEMA MYSCHEMA
TRANSACTION ID
TRANSACTION STATE not in progress
WARNINGS on
>>control query default * reset;
--- SQL operation complete.
>>env;
----------------------------------
Current Environment
----------------------------------
CURRENT DIRECTORY /opt/home/wtsai/dlv38027/trafci/bin
LIST_COUNT 4294967295
LOG FILE
MESSAGEFILE /opt/home/wtsai/dlv38027/export/bin64/mxcierrors.cat
TERMINAL CHARSET ISO88591
MESSAGEFILE LANG US English
MESSAGEFILE VRSN {2014-03-03 17:43 LINUX:G4T2992.HOUSTON.HP.COM/sqlnxadm}
SQL USER NAME DB__ROOT
SQL USER ID 99999
SQL CATALOG TRAFODION
SQL SCHEMA SEABASE
TRANSACTION ID
TRANSACTION STATE not in progress
WARNINGS on
>>control query default schema 'myschema';
--- SQL operation complete.
>>env;
----------------------------------
Current Environment
----------------------------------
CURRENT DIRECTORY /opt/home/wtsai/dlv38027/trafci/bin
LIST_COUNT 4294967295
LOG FILE
MESSAGEFILE /opt/home/wtsai/dlv38027/export/bin64/mxcierrors.cat
TERMINAL CHARSET ISO88591
MESSAGEFILE LANG US English
MESSAGEFILE VRSN {2014-03-03 17:43 LINUX:G4T2992.HOUSTON.HP.COM/sqlnxadm}
SQL USER NAME DB__ROOT
SQL USER ID 99999
SQL CATALOG TRAFODION
SQL SCHEMA MYSCHEMA
TRANSACTION ID
TRANSACTION STATE not in progress
WARNINGS on
>>control query default schema reset;
--- SQL operation complete.
>>env;
----------------------------------
Current Environment
----------------------------------
CURRENT DIRECTORY /opt/home/wtsai/dlv38027/trafci/bin
LIST_COUNT 4294967295
LOG FILE
MESSAGEFILE /opt/home/wtsai/dlv38027/export/bin64/mxcierrors.cat
TERMINAL CHARSET ISO88591
MESSAGEFILE LANG US English
MESSAGEFILE VRSN {2014-03-03 17:43 LINUX:G4T2992.HOUSTON.HP.COM/sqlnxadm}
SQL USER NAME DB__ROOT
SQL USER ID 99999
SQL CATALOG TRAFODION
SQL SCHEMA SEABASE
TRANSACTION ID
TRANSACTION STATE not in progress
WARNINGS on
>>
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)