Github user EEDY commented on a diff in the pull request:
https://github.com/apache/incubator-trafodion/pull/1288#discussion_r149039183
--- Diff: core/sql/sqlcomp/CmpDescribe.cpp ---
@@ -3059,6 +3061,36 @@ short CmpDescribeSeabaseTable (
outputLongLine(*space, viewtext, 0);
+ //display comment for VIEW
+ if (objectUID > 0/* && COMMENT_CQD*/)
+ {
+ if (cmpSBD.switchCompiler())
+ {
+ *CmpCommon::diags() <<
DgSqlCode(-CAT_UNABLE_TO_RETRIEVE_PRIVS);
+ return -1;
+ }
+
+ ComTdbVirtObjCommentInfo * objCommentInfo = NULL;
+ cmpSBD.getSeabaseObjectComment(objectUID, COM_VIEW_OBJECT,
objCommentInfo);
+
+ if (objCommentInfo != NULL)
+ {
+ //new line
+ outputLine(*space, "", 0);
+
+ //display VIEW COMMENT statements
+ if (objCommentInfo->objectComment != NULL)
+ {
+ sprintf(buf, "COMMENT ON VIEW %s IS '%s' ;",
+ tableName.data(),
+ objCommentInfo->objectComment);
+ outputLine(*space, buf, 0);
--- End diff --
Done
---
