Comment 1 for bug 1246183

Revision history for this message
Weishiun Tsai (wei-shiun-tsai) wrote :

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;
-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;

*** ERROR[4082] Object SEABASE.MYTEST.ABC does not exist or is inaccessible. [2013-11-06 17:34:20]

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;

*** ERROR[4082] Object SEABASE.MYTEST.ABC does not exist or is inaccessible. [2013-11-06 17:34:39]

SQL>exit;