Test for new context column in natablecache()
Project: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/repo Commit: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/commit/0cf01f09 Tree: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/tree/0cf01f09 Diff: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/diff/0cf01f09 Branch: refs/heads/master Commit: 0cf01f09502fa6b22769e401348bfffd36590435 Parents: 985cecc Author: Hans Zeller <[email protected]> Authored: Tue Apr 19 23:52:40 2016 +0000 Committer: Hans Zeller <[email protected]> Committed: Tue Apr 19 23:52:40 2016 +0000 ---------------------------------------------------------------------- core/sql/regress/core/EXPECTED005.SB | 8 ++++---- core/sql/regress/core/TEST005 | 2 +- 2 files changed, 5 insertions(+), 5 deletions(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/0cf01f09/core/sql/regress/core/EXPECTED005.SB ---------------------------------------------------------------------- diff --git a/core/sql/regress/core/EXPECTED005.SB b/core/sql/regress/core/EXPECTED005.SB index 6a200c8..8b283d2 100644 --- a/core/sql/regress/core/EXPECTED005.SB +++ b/core/sql/regress/core/EXPECTED005.SB @@ -1488,12 +1488,12 @@ S OPERATOR LC RC TAB_NAME --- SQL operation complete. >> ->>select num_lookups, num_cache_hits, num_entries, max_cache_size from table(natablecache('user','local')) ; +>>select context, num_lookups, num_cache_hits, num_entries, max_cache_size from table(natablecache('user','local')) ; -NUM_LOOKUPS NUM_CACHE_HITS NUM_ENTRIES MAX_CACHE_SIZE ------------ -------------- ----------- -------------- +CONTEXT NUM_LOOKUPS NUM_CACHE_HITS NUM_ENTRIES MAX_CACHE_SIZE +-------- ----------- -------------- ----------- -------------- - 165 135 16 20971520 +NONE 165 135 16 20971520 --- 1 row(s) selected. >> http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/0cf01f09/core/sql/regress/core/TEST005 ---------------------------------------------------------------------- diff --git a/core/sql/regress/core/TEST005 b/core/sql/regress/core/TEST005 index 1cfb036..098954a 100755 --- a/core/sql/regress/core/TEST005 +++ b/core/sql/regress/core/TEST005 @@ -636,7 +636,7 @@ control query shape cut; ?section clnup control query shape cut; -select num_lookups, num_cache_hits, num_entries, max_cache_size from table(natablecache('user','local')) ; +select context, num_lookups, num_cache_hits, num_entries, max_cache_size from table(natablecache('user','local')) ; obey TEST005(ddl);
