You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@trafodion.apache.org by db...@apache.org on 2017/11/15 18:03:06 UTC
[09/11] incubator-trafodion git commit: new COMMENT-ON SQL statement:
review change - fix a error in new build-in view
new COMMENT-ON SQL statement: review change - fix a error in new build-in view
1. fix a error in new build-in view
Project: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/repo
Commit: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/commit/6af42567
Tree: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/tree/6af42567
Diff: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/diff/6af42567
Branch: refs/heads/master
Commit: 6af42567b9c6d53937fa735f162da4833dee8896
Parents: 96570c4
Author: eedy <cq...@gmail.com>
Authored: Fri Nov 10 09:51:00 2017 +0800
Committer: eedy <cq...@gmail.com>
Committed: Fri Nov 10 09:51:00 2017 +0800
----------------------------------------------------------------------
core/sql/sqlcomp/CmpSeabaseDDLmd.h | 2 +-
1 file changed, 1 insertion(+), 1 deletion(-)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/6af42567/core/sql/sqlcomp/CmpSeabaseDDLmd.h
----------------------------------------------------------------------
diff --git a/core/sql/sqlcomp/CmpSeabaseDDLmd.h b/core/sql/sqlcomp/CmpSeabaseDDLmd.h
index 9a1e91d..3ca7e78 100644
--- a/core/sql/sqlcomp/CmpSeabaseDDLmd.h
+++ b/core/sql/sqlcomp/CmpSeabaseDDLmd.h
@@ -1712,7 +1712,7 @@ static const QString createTrafColumnCommentViewQuery[] =
{" create view %s.\"%s\"."TRAF_COLUMN_COMMENT_VIEW" as "},
{" select O.CATALOG_NAME, O.SCHEMA_NAME, O.OBJECT_NAME, C.COLUMN_NAME, T.TEXT as COMMENT "},
{" from %s.\"%s\".\"%s\" as O, %s.\"%s\".\"%s\" as C, %s.\"%s\".\"%s\" as T "},
- {" where O.OBJECT_UID = C.OBJECT_UID and T.TEXT_UID = O.OBJECT_UID and T.TEXT_TYPE = %s "},
+ {" where O.OBJECT_UID = C.OBJECT_UID and T.TEXT_UID = O.OBJECT_UID and T.TEXT_TYPE = %s and T.SUB_ID = C.COLUMN_NUMBER "},
{" order by O.OBJECT_UID, C.COLUMN_NUMBER "},
{" ; "}
};