[TRAFODION-138] LP Bug: 1246183 - volatile table is not dropped after hpdci session ends

• Type: Bug
• Status: Open
• Priority: Critical
• Resolution: Unresolved
• Fix Version/s: 2.4
• Component/s: sql-exe
• External issue URL: https://bugs.launchpad.net/bugs/1246183
• Assignee: Sandhya Sundaresan
• Reporter: Weishiun Tsai
• Created: 22/Jul/15 18:14
• Updated: 16/Apr/20 02:20

Description

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.