[ 
https://issues.apache.org/jira/browse/TRAFODION-138?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Suresh Subbiah updated TRAFODION-138:
-------------------------------------
    Fix Version/s:     (was: 2.2.0)
                   2.3

> 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.3
>
>
> 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)

Reply via email to