trafci does not reset CQD after 'CQD * RESET'
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Trafodion |
In Progress
|
Medium
|
Arvind Narain |
Bug Description
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-
=======
Output from trafci
=======
Welcome to Trafodion Command Interface
Copyright(C) 2013-2014 Hewlett-Packard Development Company, L.P.
Host Name/IP Address: sqws138.
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.
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.
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.
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.
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/
LIST_COUNT 4294967295
LOG FILE
MESSAGEFILE /opt/home/
TERMINAL CHARSET ISO88591
MESSAGEFILE LANG US English
MESSAGEFILE VRSN {2014-03-03 17:43 LINUX:G4T2992.
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/
LIST_COUNT 4294967295
LOG FILE
MESSAGEFILE /opt/home/
TERMINAL CHARSET ISO88591
MESSAGEFILE LANG US English
MESSAGEFILE VRSN {2014-03-03 17:43 LINUX:G4T2992.
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/
LIST_COUNT 4294967295
LOG FILE
MESSAGEFILE /opt/home/
TERMINAL CHARSET ISO88591
MESSAGEFILE LANG US English
MESSAGEFILE VRSN {2014-03-03 17:43 LINUX:G4T2992.
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/
LIST_COUNT 4294967295
LOG FILE
MESSAGEFILE /opt/home/
TERMINAL CHARSET ISO88591
MESSAGEFILE LANG US English
MESSAGEFILE VRSN {2014-03-03 17:43 LINUX:G4T2992.
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/
LIST_COUNT 4294967295
LOG FILE
MESSAGEFILE /opt/home/
TERMINAL CHARSET ISO88591
MESSAGEFILE LANG US English
MESSAGEFILE VRSN {2014-03-03 17:43 LINUX:G4T2992.
SQL USER NAME DB__ROOT
SQL USER ID 99999
SQL CATALOG TRAFODION
SQL SCHEMA SEABASE
TRANSACTION ID
TRANSACTION STATE not in progress
WARNINGS on
>>
tags: |
added: sql-general removed: sql |
tags: |
added: client-ci removed: sql-general |
Changed in trafodion: | |
assignee: | nobody → Arvind Narain (arvind-narain) |
Changed in trafodion: | |
status: | New → In Progress |
information type: | Proprietary → Public |