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 <[email protected]> Authored: Fri Nov 10 09:51:00 2017 +0800 Committer: eedy <[email protected]> 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 "}, {" ; "} };
