Showddl after granting privs on metadata tables fails

[Roberta Marton]

The showddl statement for tables should show all the granted privileges.
After the select priv is granted on a system metadata table followed by a showddl, the showddl does not show any privileges.

sqlci
Trafodion Conversational Interface 1.0.0
(c) Copyright 2014 Hewlett-Packard Development Company, LP.
>>grant select on "_MD_".keys to sql_user2;

--- SQL operation complete.
>>showddl "_MD_".keys;

CREATE TABLE TRAFODION."_MD_".KEYS
  (
    OBJECT_UID LARGEINT NO DEFAULT NOT NULL NOT DROPPABLE
  , COLUMN_NAME VARCHAR(256 BYTES) CHARACTER SET UTF8
      COLLATE DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE
  , KEYSEQ_NUMBER INT NO DEFAULT NOT NULL NOT DROPPABLE
  , COLUMN_NUMBER INT NO DEFAULT NOT NULL NOT DROPPABLE
  , ORDERING INT NO DEFAULT NOT NULL NOT DROPPABLE
  , NONKEYCOL INT NO DEFAULT NOT NULL NOT DROPPABLE
  , FLAGS LARGEINT NO DEFAULT NOT NULL NOT DROPPABLE
  , PRIMARY KEY (OBJECT_UID ASC, KEYSEQ_NUMBER ASC)
  )
;

--- SQL operation complete.
>>

If you exit out of sqlci and rerun the showddl command, it now shows all the privileges.
>exit

sqlci

>>showddl "_MD_".keys;

CREATE TABLE TRAFODION."_MD_".KEYS
  (
    OBJECT_UID LARGEINT NO DEFAULT NOT NULL NOT DROPPABLE
  , COLUMN_NAME VARCHAR(256 BYTES) CHARACTER SET UTF8
      COLLATE DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE
  , KEYSEQ_NUMBER INT NO DEFAULT NOT NULL NOT DROPPABLE
  , COLUMN_NUMBER INT NO DEFAULT NOT NULL NOT DROPPABLE
  , ORDERING INT NO DEFAULT NOT NULL NOT DROPPABLE
  , NONKEYCOL INT NO DEFAULT NOT NULL NOT DROPPABLE
  , FLAGS LARGEINT NO DEFAULT NOT NULL NOT DROPPABLE
  , PRIMARY KEY (OBJECT_UID ASC, KEYSEQ_NUMBER ASC)
  )
;

-- GRANT DELETE, INSERT, SELECT, UPDATE, REFERENCES ON TRAFODION."_MD_"."KEYS" TO DB__ROOT WITH GRANT OPTION;
  GRANT SELECT ON TRAFODION."_MD_".KEYS TO SQL_USER1;
GRANT SELECT ON
  TRAFODION."_MD_".KEYS TO SQL_USER2;

--- SQL operation complete.

[Roberta Marton (roberta-marton)]

fixed

[Paul Low (paul-low-x)]

verified in 0327 build