[jira] [Created] (TRAFODION-640) LP Bug: 1370754 - Objects with delimited names not displayed correctly for SHOWDDL

["Alice Chen (JIRA)" <ji...@apache.org>]

Alice Chen created TRAFODION-640:
------------------------------------

             Summary: LP Bug: 1370754 - Objects with delimited names not displayed correctly for SHOWDDL
                 Key: TRAFODION-640
                 URL: https://issues.apache.org/jira/browse/TRAFODION-640
             Project: Apache Trafodion
          Issue Type: Bug
          Components: sql-security
            Reporter: Roberta Marton
            Assignee: Roberta Marton
            Priority: Minor
             Fix For: 2.0-incubating


When objects are created, a set of default privileges are granted by the system to the creator.  Later when SHOWDDL is executed, associated grants are returned.  The initial grants to the owner for delimited names are not stored correctly.


create table "my-schema"."my-table" (c1 int not null primary key, c2 int);
grant select on "my-schema"."my-table" to sql_user1;

showddl "my-schema"."my-table";

CREATE TABLE TRAFODION."my-schema"."my-table"
  (
    C1                               INT NO DEFAULT NOT NULL NOT DROPPABLE
  , C2                               INT DEFAULT NULL
  , PRIMARY KEY (C1 ASC)
  )
;

-- GRANT DELETE, INSERT, SELECT, UPDATE, REFERENCES ON TRAFODION.my-schema.my-table TO DB__ROOT WITH GRANT OPTION;
  GRANT SELECT ON TRAFODION."my-schema"."my-table" TO SQL_USER1;

Since it is only happening on the owner grants, this is just cosmetic:

drop table "my-schema"."my-table";
 
--> recreate of table using SHOWDDL output does succeed:

CREATE TABLE TRAFODION."my-schema"."my-table"
  (
    C1                               INT NO DEFAULT NOT NULL NOT DROPPABLE
  , C2                               INT DEFAULT NULL
  , PRIMARY KEY (C1 ASC)
  )
;

-- GRANT DELETE, INSERT, SELECT, UPDATE, REFERENCES ON TRAFODION.my-schema.my-table TO DB__ROOT WITH GRANT OPTION;
  GRANT SELECT ON TRAFODION."my-schema"."my-table" TO SQL_USER1;



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)