trafci does not reset CQD after 'CQD * RESET'

[Weishiun Tsai]

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
>>