You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@trafodion.apache.org by ar...@apache.org on 2016/01/08 18:06:06 UTC
[5/6] incubator-trafodion git commit: redefine PRODUCEDURE_TYPE
redefine PRODUCEDURE_TYPE
Project: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/repo
Commit: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/commit/441769d8
Tree: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/tree/441769d8
Diff: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/diff/441769d8
Branch: refs/heads/master
Commit: 441769d8bb2c1bc812e84ee7d9d8e4a5c8789a92
Parents: 4b1b60d
Author: Kevin Xu <ka...@esgyn.cn>
Authored: Fri Jan 8 15:21:15 2016 +0800
Committer: Kevin Xu <ka...@esgyn.cn>
Committed: Fri Jan 8 15:21:15 2016 +0800
----------------------------------------------------------------------
core/conn/jdbc_type2/native/SrvrCommon.cpp | 6 +++++-
1 file changed, 5 insertions(+), 1 deletion(-)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/441769d8/core/conn/jdbc_type2/native/SrvrCommon.cpp
----------------------------------------------------------------------
diff --git a/core/conn/jdbc_type2/native/SrvrCommon.cpp b/core/conn/jdbc_type2/native/SrvrCommon.cpp
index 8fe4e66..b12c949 100644
--- a/core/conn/jdbc_type2/native/SrvrCommon.cpp
+++ b/core/conn/jdbc_type2/native/SrvrCommon.cpp
@@ -1661,9 +1661,13 @@ tableNm, tableNmNoEsc)) && !metadataId)
snprintf((char *)sqlString->dataValue._buffer, totalSize,
"select obj.CATALOG_NAME PROCEDURE_CAT, obj.SCHEMA_NAME PROCEDURE_SCHEM, "
"obj.OBJECT_NAME PROCEDURE_NAME, cast(NULL as varchar(10)) R1,cast(NULL as varchar(10)) R2,"
- "cast(NULL as varchar(10)) R3, cast(NULL as varchar(10)) REMARKS, cast(0 as smallint) PROCEDURE_TYPE, "
+ "cast(NULL as varchar(10)) R3, cast(NULL as varchar(10)) REMARKS,"
+ "cast(case when routines.UDR_TYPE = 'P' then 1"
+ " when routines.UDR_TYPE = 'F' or routines.UDR_TYPE = 'T'"
+ " then 2 else 0 end as smallint) PROCEDURE_TYPE, "
"obj.OBJECT_NAME SPECIFIC_NAME "
" from TRAFODION.\"_MD_\".OBJECTS obj "
+ " left join TRAFODION.\"_MD_\".ROUTINES routines on obj.OBJECT_UID = routines.UDR_UID"
" where "
" (obj.SCHEMA_NAME = '%s' or trim(obj.SCHEMA_NAME) LIKE '%s' ESCAPE '\\')"
" and (obj.OBJECT_NAME = '%s' or trim(obj.OBJECT_NAME) LIKE '%s' ESCAPE '\\')"