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 2016/05/25 20:34:26 UTC
[04/39] incubator-trafodion git commit: Fix for TRAFODION-1948 Drop
schema cascade internally selects against objects table. The fix is to use a
distinct clause in the internal select query.
Fix for TRAFODION-1948
Drop schema cascade internally selects against objects table.
The fix is to use a distinct clause in the internal select query.
Project: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/repo
Commit: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/commit/6e674c65
Tree: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/tree/6e674c65
Diff: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/diff/6e674c65
Branch: refs/heads/master
Commit: 6e674c65c2a9ebd05c53f8a88b4464601a24808f
Parents: 5dc6754
Author: Prashant Vasudev <pr...@esgyn.com>
Authored: Thu Apr 28 21:12:17 2016 +0000
Committer: Prashant Vasudev <pr...@esgyn.com>
Committed: Thu Apr 28 21:12:17 2016 +0000
----------------------------------------------------------------------
core/sql/sqlcomp/CmpSeabaseDDLschema.cpp | 2 +-
1 file changed, 1 insertion(+), 1 deletion(-)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/6e674c65/core/sql/sqlcomp/CmpSeabaseDDLschema.cpp
----------------------------------------------------------------------
diff --git a/core/sql/sqlcomp/CmpSeabaseDDLschema.cpp b/core/sql/sqlcomp/CmpSeabaseDDLschema.cpp
index d37306b..c36f62c 100644
--- a/core/sql/sqlcomp/CmpSeabaseDDLschema.cpp
+++ b/core/sql/sqlcomp/CmpSeabaseDDLschema.cpp
@@ -503,7 +503,7 @@ void CmpSeabaseDDL::dropSeabaseSchema(StmtDDLDropSchema * dropSchemaNode)
// they always get removed when the parent table is dropped.
// Filter out the LOB depenedent tables too - they will get dropped when
//the main LOB table is dropped.
- str_sprintf(query,"SELECT TRIM(object_name), TRIM(object_type) "
+ str_sprintf(query,"SELECT distinct TRIM(object_name), TRIM(object_type) "
"FROM %s.\"%s\".%s "
"WHERE catalog_name = '%s' AND schema_name = '%s' AND "
"object_name <> '"SEABASE_SCHEMA_OBJECTNAME"' AND "