volatile table is not dropped after hpdci session ends
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Trafodion |
In Progress
|
High
|
Sandhya Sundaresan |
Bug 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
Welcome to HP Database Command Interface 3.0
(c) Copyright 2010-2012 Hewlett-Packard Development Company, LP.
Connected to Data Source: TDM_Default_
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
Welcome to HP Database Command Interface 3.0
(c) Copyright 2010-2012 Hewlett-Packard Development Company, LP.
Connected to Data Source: TDM_Default_
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
Welcome to HP Database Command Interface 3.0
(c) Copyright 2010-2012 Hewlett-Packard Development Company, LP.
Connected to Data Source: TDM_Default_
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
Welcome to HP Database Command Interface 3.0
(c) Copyright 2010-2012 Hewlett-Packard Development Company, LP.
Connected to Data Source: TDM_Default_
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.
Changed in trafodion: | |
assignee: | nobody → Anoop Sharma (anoop-sharma) |
Changed in trafodion: | |
assignee: | Anoop Sharma (anoop-sharma) → Selvaganesan (selva-ganesan) |
tags: |
added: client-ci removed: dcs |
information type: | Proprietary → Public |
tags: |
added: sql-exe removed: client-ci |
Changed in trafodion: | |
assignee: | Selvaganesan Govindarajan (selva-ganesan) → Pavani Puppala (pavani-puppala) |
Changed in trafodion: | |
assignee: | Pavani Puppala (pavani-puppala) → Selvaganesan Govindarajan (selva-ganesan) |
Changed in trafodion: | |
milestone: | none → r0.9 |
Changed in trafodion: | |
assignee: | Selvaganesan Govindarajan (selva-ganesan) → Sandhya Sundaresan (sandhya-sundaresan) |
Changed in trafodion: | |
milestone: | r0.9 → r1.1 |
Changed in trafodion: | |
milestone: | r1.1 → r1.2 |
Verified on 11/6/2013, this problem has been fixed.
-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; -sqtopl7. sh
-bash-4.1$ hpdci.seascape2
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;
*** ERROR[4082] Object SEABASE.MYTEST.ABC does not exist or is inaccessible. [2013-11-06 17:34:20]
SQL>exit; -sqtopl7. sh
-bash-4.1$ hpdci.seascape2
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;
*** ERROR[4082] Object SEABASE.MYTEST.ABC does not exist or is inaccessible. [2013-11-06 17:34:39]
SQL>exit;