add set schema for drop lib
Project: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/repo Commit: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/commit/62b91c31 Tree: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/tree/62b91c31 Diff: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/diff/62b91c31 Branch: refs/heads/master Commit: 62b91c3173022d2b1d91d424539a1fe1a0c47a38 Parents: a355f84 Author: Kevin Xu <[email protected]> Authored: Fri Dec 25 18:24:16 2015 +0800 Committer: Kevin Xu <[email protected]> Committed: Fri Dec 25 18:24:16 2015 +0800 ---------------------------------------------------------------------- core/sql/lib_mgmt/src/main/resources/init_libmgmt.sh | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/62b91c31/core/sql/lib_mgmt/src/main/resources/init_libmgmt.sh ---------------------------------------------------------------------- diff --git a/core/sql/lib_mgmt/src/main/resources/init_libmgmt.sh b/core/sql/lib_mgmt/src/main/resources/init_libmgmt.sh index 13b64bf..003c785 100644 --- a/core/sql/lib_mgmt/src/main/resources/init_libmgmt.sh +++ b/core/sql/lib_mgmt/src/main/resources/init_libmgmt.sh @@ -34,9 +34,10 @@ function dropAndCreateSchema { cqd CAT_IGNORE_ALREADY_EXISTS_ERROR 'on'; cqd CAT_IGNORE_DOES_NOT_EXIST_ERROR 'on'; - DROP LIBRARY ${LIB_NAME} CASCADE; DROP SCHEMA $CATALOG_NAME.$LIB_SCHEMA CLEANUP CASCADE; CREATE SCHEMA $CATALOG_NAME.$LIB_SCHEMA; + set schema $CATALOG_NAME.$LIB_SCHEMA; + DROP LIBRARY ${LIB_NAME} CASCADE; CREATE LIBRARY ${LIB_NAME} FILE '${SERVER_JAR}'; CREATE ROLE ${DB__LIBMGRROLE};
