You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@trafodion.apache.org by "Pierre Smits (JIRA)" <ji...@apache.org> on 2018/03/04 09:17:07 UTC
[jira] [Updated] (TRAFODION-138) LP Bug: 1246183 - volatile table
is not dropped after hpdci session ends
[ https://issues.apache.org/jira/browse/TRAFODION-138?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Pierre Smits updated TRAFODION-138:
-----------------------------------
Fix Version/s: (was: 2.1-incubating)
2.2.0
> 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.2.0
>
>
> 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
(v7.6.3#76005)