Trafodion

Comment 2 for bug 1246183

Revision history for this message

Weishiun Tsai (wei-shiun-tsai) wrote on 2013-11-14:

Repoened this bug. This problem has reapeared on the 11/11/2013 build, as shown here:

-bash-4.1$ hpdci.sqws138.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.sqws138.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.sqws138.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$