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:49 UTC
[jira] [Created] (TRAFODION-374) LP Bug: 1329358 - Sessions keeping
metadata in cache/missing DML operations.
Alice Chen created TRAFODION-374:
------------------------------------
Summary: LP Bug: 1329358 - Sessions keeping metadata in cache/missing DML operations.
Key: TRAFODION-374
URL: https://issues.apache.org/jira/browse/TRAFODION-374
Project: Apache Trafodion
Issue Type: Bug
Components: sql-general
Reporter: Guy Groulx
Assignee: Apache Trafodion
Priority: Critical
Fix For: 0.9 (pre-incubation)
sqlci and dcs sessions are caching metadata and not refreshing when dml operations are being performed.
Using 2 sqlci sessions.
SESSION 1
/home/squser2> sqlci
Trafodion Conversational Interface 0.8.0
(c) Copyright 2014 Hewlett-Packard Development Company, LP.
>>SET SCHEMA TRAFODION.TESTSCH;
--- SQL operation complete.
>>CREATE TABLE TESTTABLE (
>>+ FIELD1 CHAR(10) NOT NULL
>>+ , FIELD2 CHAR(15) NOT NULL
>>+ , PRIMARY KEY (FIELD1 ASC)
>>+ );
--- SQL operation complete.
>>invoke testtable;
-- Definition of Trafodion table TRAFODION.TESTSCH.TESTTABLE
-- Definition current Thu Jun 12 15:07:45 2014
(
FIELD1 CHAR(10) CHARACTER SET ISO88591 COLLATE
DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE
, FIELD2 CHAR(15) CHARACTER SET ISO88591 COLLATE
DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE
)
PRIMARY KEY (FIELD1 ASC)
--- SQL operation complete.
SESSION 2 in a different window. Keep session 1's window opened.
/home/squser2> sqlci
Trafodion Conversational Interface 0.8.0
(c) Copyright 2014 Hewlett-Packard Development Company, LP.
>>SET SCHEMA TRAFODION.TESTSCH;
--- SQL operation complete.
>>get tables;
Tables in Schema TRAFODION.TESTSCH
==================================
TESTTABLE
--- SQL operation complete.
>>invoke testtable;
-- Definition of Trafodion table TRAFODION.TESTSCH.TESTTABLE
-- Definition current Thu Jun 12 15:07:38 2014
(
FIELD1 CHAR(10) CHARACTER SET ISO88591 COLLATE
DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE
, FIELD2 CHAR(15) CHARACTER SET ISO88591 COLLATE
DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE
)
PRIMARY KEY (FIELD1 ASC)
--- SQL operation complete.
NOW BACK TO SESSION 1. Keep session 2 window opened.
>>DROP TABLE TESTTABLE;
-- SQL operation complete.
>> CREATE TABLE TESTTABLE (
>>+ FIELD1 CHAR(10) NOT NULL
>>+ , FIELD2 CHAR(15) NOT NULL
>>+ , FIELD3 CHAR(10) NOT NULL
>>+ , FIELD4 CHAR(15) NOT NULL
>>+, PRIMARY KEY (FIELD1 ASC)
>>+ );
--- SQL operation complete.
>>invoke testtable;
-- Definition of Trafodion table TRAFODION.TESTSCH.TESTTABLE
-- Definition current Thu Jun 12 15:08:06 2014
(
FIELD1 CHAR(10) CHARACTER SET ISO88591 COLLATE
DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE
, FIELD2 CHAR(15) CHARACTER SET ISO88591 COLLATE
DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE
, FIELD3 CHAR(10) CHARACTER SET ISO88591 COLLATE
DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE
, FIELD4 CHAR(15) CHARACTER SET ISO88591 COLLATE
DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE
)
PRIMARY KEY (FIELD1 ASC)
--- SQL operation complete.
>>
BUT BACK ON SESSION 2:
>>invoke testtable;
-- Definition of Trafodion table TRAFODION.TESTSCH.TESTTABLE
-- Definition current Thu Jun 12 15:08:15 2014
(
FIELD1 CHAR(10) CHARACTER SET ISO88591 COLLATE
DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE
, FIELD2 CHAR(15) CHARACTER SET ISO88591 COLLATE
DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE
)
PRIMARY KEY (FIELD1 ASC)
--- SQL operation complete.
>>
Notice how session 2 still has the old form or table.
Assigned to LaunchPad User Mike Hanlon
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)