Repository: incubator-trafodion Updated Branches: refs/heads/master ccd7c5581 -> 6400ecb96
[TRAFODION-2411] Conn aborted when connecting with a reregisterd user APIs used to clear compiler caches had changed, leading to syntax errors. Project: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/repo Commit: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/commit/35e928be Tree: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/tree/35e928be Diff: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/diff/35e928be Branch: refs/heads/master Commit: 35e928be46167deb381faa5ad0318e99a2433c0a Parents: c69b501 Author: Arvind Narain <[email protected]> Authored: Fri Dec 23 00:03:12 2016 +0000 Committer: Arvind Narain <[email protected]> Committed: Fri Dec 23 00:03:12 2016 +0000 ---------------------------------------------------------------------- core/conn/odbc/src/odbc/nsksrvr/SrvrConnect.cpp | 5 ++--- 1 file changed, 2 insertions(+), 3 deletions(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/35e928be/core/conn/odbc/src/odbc/nsksrvr/SrvrConnect.cpp ---------------------------------------------------------------------- diff --git a/core/conn/odbc/src/odbc/nsksrvr/SrvrConnect.cpp b/core/conn/odbc/src/odbc/nsksrvr/SrvrConnect.cpp index bbb8a1d..0ccb927 100644 --- a/core/conn/odbc/src/odbc/nsksrvr/SrvrConnect.cpp +++ b/core/conn/odbc/src/odbc/nsksrvr/SrvrConnect.cpp @@ -4145,9 +4145,8 @@ bool __cdecl SRVR::CompilerCacheReset(char *errorMsg) // Clear compiler cache by executing the following DELETE statements // - // DELETE ALL FROM TABLE(QUERYCACHE()) + // DELETE ALL FROM TABLE(QUERYCACHE('ALL','LOCAL')) // DELETE ALL FROM TABLE(NATABLECACHE()) - // DELETE ALL FROM TABLE(NAROUTINECACHE()) SRVR_STMT_HDL *CmpStmt = NULL; @@ -4164,7 +4163,7 @@ bool __cdecl SRVR::CompilerCacheReset(char *errorMsg) //LCOV_EXCL_STOP } - strcpy(CmpQuery,"DELETE ALL FROM TABLE(QUERYCACHE())"); + strcpy(CmpQuery,"DELETE ALL FROM TABLE(QUERYCACHE('ALL','LOCAL'))"); retcode = CmpStmt->ExecDirect(NULL, CmpQuery, INTERNAL_STMT, TYPE_UNKNOWN, SQL_ASYNC_ENABLE_OFF, 0); if (retcode != SQL_ERROR) {
