[
https://issues.apache.org/jira/browse/TRAFODION-138?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Selvaganesan Govindarajan updated TRAFODION-138:
------------------------------------------------
Fix Version/s: (was: 2.3)
2.4
> LP Bug: 1246183 - volatile table is not dropped after hpdci session ends
> ------------------------------------------------------------------------
>
> Key: TRAFODION-138
> URL: https://issues.apache.org/jira/browse/TRAFODION-138
> Project: Apache Trafodion
> Issue Type: Bug
> Components: sql-exe
> Reporter: Weishiun Tsai
> Assignee: Sandhya Sundaresan
> Priority: Critical
> Fix For: 2.4
>
>
> A volatile table is not dropped after the hpdci session has ended. In the
> following example, the volatile table persists after several hpdci
> disconnects and reconnects. This problem is not seen from sqlci, so I am
> assuming that the problem is in how mxosvr handles volatile tables.
> -bash-4.1$ hpdci.seascape2-sqtopl7.sh
> Welcome to HP Database Command Interface 3.0
> (c) Copyright 2010-2012 Hewlett-Packard Development Company, LP.
> Connected to Data Source: TDM_Default_DataSource
> SQL>set schema seabase.mytest;
> --- SQL operation complete.
> SQL>create volatile table abc (a int not null not droppable primary key);
> --- SQL operation complete.
> SQL>showddl abc;
> CREATE VOLATILE TABLE ABC
> (
> A INT NO DEFAULT NOT NULL NOT DROPPABLE
> , PRIMARY KEY (A ASC)
> )
> ;
> --- SQL operation complete.
> SQL>exit;
> -bash-4.1$ hpdci.seascape2-sqtopl7.sh
> Welcome to HP Database Command Interface 3.0
> (c) Copyright 2010-2012 Hewlett-Packard Development Company, LP.
> Connected to Data Source: TDM_Default_DataSource
> SQL>set schema seabase.mytest;
> --- SQL operation complete.
> SQL>showddl abc;
> CREATE VOLATILE TABLE ABC
> (
> A INT NO DEFAULT NOT NULL NOT DROPPABLE
> , PRIMARY KEY (A ASC)
> )
> ;
> --- SQL operation complete.
> SQL>exit;
> -bash-4.1$ hpdci.seascape2-sqtopl7.sh
> Welcome to HP Database Command Interface 3.0
> (c) Copyright 2010-2012 Hewlett-Packard Development Company, LP.
> Connected to Data Source: TDM_Default_DataSource
> SQL>set schema seabase.mytest;
> --- SQL operation complete.
> SQL>showddl abc;
> CREATE VOLATILE TABLE ABC
> (
> A INT NO DEFAULT NOT NULL NOT DROPPABLE
> , PRIMARY KEY (A ASC)
> )
> ;
> --- SQL operation complete.
> SQL>exit;
> -bash-4.1$ hpdci.seascape2-sqtopl7.sh
> Welcome to HP Database Command Interface 3.0
> (c) Copyright 2010-2012 Hewlett-Packard Development Company, LP.
> Connected to Data Source: TDM_Default_DataSource
> SQL>set schema seabase.mytest;
> --- SQL operation complete.
> SQL>showddl abc;
> CREATE VOLATILE TABLE ABC
> (
> A INT NO DEFAULT NOT NULL NOT DROPPABLE
> , PRIMARY KEY (A ASC)
> )
> ;
> --- SQL operation complete.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
