You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@trafodion.apache.org by li...@apache.org on 2018/07/21 16:05:36 UTC
[1/9] trafodion git commit: [TRAFODION-3101] enhance get command to
show rows get
Repository: trafodion
Updated Branches:
refs/heads/master efd564727 -> 8b56ed242
[TRAFODION-3101] enhance get command to show rows get
Project: http://git-wip-us.apache.org/repos/asf/trafodion/repo
Commit: http://git-wip-us.apache.org/repos/asf/trafodion/commit/591e0fa6
Tree: http://git-wip-us.apache.org/repos/asf/trafodion/tree/591e0fa6
Diff: http://git-wip-us.apache.org/repos/asf/trafodion/diff/591e0fa6
Branch: refs/heads/master
Commit: 591e0fa60a13f9f57eee1bc7a9b35fe5a10145a2
Parents: 0db94ea
Author: Liu Ming <ov...@sina.com>
Authored: Sun Jun 24 20:48:37 2018 -0400
Committer: Liu Ming <ov...@sina.com>
Committed: Sun Jun 24 20:48:37 2018 -0400
----------------------------------------------------------------------
core/sql/executor/ExExeUtilGet.cpp | 14 +++++++
core/sql/regress/compGeneral/EXPECTED023 | 56 +++++++++++++++++++++++++++
core/sql/regress/core/EXPECTED116 | 21 ++++++++++
core/sql/regress/executor/EXPECTED130 | 4 ++
core/sql/regress/seabase/EXPECTED011 | 4 ++
core/sql/regress/seabase/EXPECTED012 | 52 +++++++++++++++++++++++++
core/sql/regress/seabase/EXPECTED022 | 17 ++++++++
core/sql/regress/seabase/EXPECTED031 | 4 ++
8 files changed, 172 insertions(+)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/trafodion/blob/591e0fa6/core/sql/executor/ExExeUtilGet.cpp
----------------------------------------------------------------------
diff --git a/core/sql/executor/ExExeUtilGet.cpp b/core/sql/executor/ExExeUtilGet.cpp
index 163b190..5bb4793 100644
--- a/core/sql/executor/ExExeUtilGet.cpp
+++ b/core/sql/executor/ExExeUtilGet.cpp
@@ -949,6 +949,7 @@ short ExExeUtilGetMetadataInfoTcb::displayHeading()
{
if (getMItdb().noHeader())
{
+printf("LMDBG noheader is true\n");
return 0;
}
// make sure there is enough space to move header
@@ -1818,8 +1819,12 @@ short ExExeUtilGetMetadataInfoTcb::work()
{
short retcode = 0;
Lng32 cliRC = 0;
+ Lng32 returnRowCount=0;
+ char returnMsg[256];
ex_expr::exp_return_type exprRetCode = ex_expr::EXPR_OK;
+ memset(returnMsg, 0, 256);
+
// if no parent request, return
if (qparent_.down->isEmpty())
return WORK_OK;
@@ -3184,6 +3189,7 @@ short ExExeUtilGetMetadataInfoTcb::work()
}
infoList_->advance();
+ returnRowCount++;
}
break;
@@ -3343,6 +3349,14 @@ short ExExeUtilGetMetadataInfoTcb::work()
case DONE_:
{
+ if (NOT getMItdb().noHeader())
+ {
+ short rc = 0;
+ sprintf(returnMsg, "\n=======================\nSummary info of get:\nGet %d rows.", returnRowCount);
+ moveRowToUpQueue(returnMsg, strlen(returnMsg), &rc);
+ moveRowToUpQueue(" ");
+ }
+
retcode = handleDone();
if (retcode == 1)
return WORK_OK;
http://git-wip-us.apache.org/repos/asf/trafodion/blob/591e0fa6/core/sql/regress/compGeneral/EXPECTED023
----------------------------------------------------------------------
diff --git a/core/sql/regress/compGeneral/EXPECTED023 b/core/sql/regress/compGeneral/EXPECTED023
index 8a46e13..2f1f012 100644
--- a/core/sql/regress/compGeneral/EXPECTED023
+++ b/core/sql/regress/compGeneral/EXPECTED023
@@ -23,6 +23,10 @@ SB_HISTOGRAMS
SB_HISTOGRAM_INTERVALS
SB_PERSISTENT_SAMPLES
+=======================
+Summary info of get:
+Get 3 rows.
+
--- SQL operation complete.
>>
>>CREATE TABLE stest
@@ -106,6 +110,10 @@ STEST
STESTC
STEST_EMPTY
+=======================
+Summary info of get:
+Get 6 rows.
+
--- SQL operation complete.
>> -- should be just stest, stest_empty, stestc, and the sb_* tables
>>
@@ -149,6 +157,10 @@ STESTC
STEST_EMPTY
TRAF_SAMPLE_07158060726899021395_1517441663_444545
+=======================
+Summary info of get:
+Get 7 rows.
+
--- SQL operation complete.
>> -- should be stest, stest_empty, stestc, sb_* tables + a sample table
>>
@@ -173,6 +185,10 @@ STESTC
STEST_EMPTY
TRAF_SAMPLE_07158060726899021395_1517441711_141471
+=======================
+Summary info of get:
+Get 7 rows.
+
--- SQL operation complete.
>> -- should be stest, stest_empty, stestc, sb_* tables + a different sample table
>>
@@ -203,6 +219,10 @@ STEST
STESTC
STEST_EMPTY
+=======================
+Summary info of get:
+Get 6 rows.
+
--- SQL operation complete.
>> -- should be stest, stest_empty, stestc, sb_* tables only
>>
@@ -230,6 +250,10 @@ STESTC
STEST_EMPTY
TRAF_SAMPLE_07158060726899021395_1517441748_979037
+=======================
+Summary info of get:
+Get 7 rows.
+
--- SQL operation complete.
>> -- should be stest, stest_empty, stestc, sb_* tables + another sample table
>>
@@ -264,6 +288,10 @@ STESTC
STEST_EMPTY
TRAF_SAMPLE_07158060726899021395_1517441802_045572
+=======================
+Summary info of get:
+Get 7 rows.
+
--- SQL operation complete.
>> -- should be stest, stest_empty, stestc, sb_* tables + another sample table
>>
@@ -393,6 +421,10 @@ STEST_EMPTY
TRAF_SAMPLE_07158060726899021395_1517441802_045572
TRAF_SAMPLE_07158060726899023220_1517441862_582002
+=======================
+Summary info of get:
+Get 8 rows.
+
--- SQL operation complete.
>>
>>execute s1 using 'STESTC';
@@ -428,6 +460,10 @@ STEST_EMPTY
TRAF_SAMPLE_07158060726899021395_1517441802_045572
TRAF_SAMPLE_07158060726899023220_1517441862_582002
+=======================
+Summary info of get:
+Get 8 rows.
+
--- SQL operation complete.
>> -- should be the same as previous "get tables"
>>
@@ -456,6 +492,10 @@ STEST_EMPTY
TRAF_SAMPLE_07158060726899021395_1517441802_045572
TRAF_SAMPLE_07158060726899023220_1517441862_582002
+=======================
+Summary info of get:
+Get 8 rows.
+
--- SQL operation complete.
>> -- should be the same as previous "get tables"
>>
@@ -485,6 +525,10 @@ STEST_EMPTY
TRAF_SAMPLE_07158060726899021395_1517441802_045572
TRAF_SAMPLE_07158060726899023220_1517441862_582002
+=======================
+Summary info of get:
+Get 8 rows.
+
--- SQL operation complete.
>> -- should be the same as previous "get tables"
>>
@@ -516,6 +560,10 @@ STEST_EMPTY
TRAF_SAMPLE_07158060726899021395_1517441802_045572
TRAF_SAMPLE_07158060726899023220_1517441862_582002
+=======================
+Summary info of get:
+Get 8 rows.
+
--- SQL operation complete.
>> -- should be the same as previous "get tables"
>>
@@ -567,6 +615,10 @@ STESTC
STEST_EMPTY
TRAF_SAMPLE_07158060726899021395_1517441802_045572
+=======================
+Summary info of get:
+Get 7 rows.
+
--- SQL operation complete.
>> -- should be the same as previous "get tables" except only one sample table
>>
@@ -592,6 +644,10 @@ SB_HISTOGRAMS
SB_HISTOGRAM_INTERVALS
SB_PERSISTENT_SAMPLES
+=======================
+Summary info of get:
+Get 3 rows.
+
--- SQL operation complete.
>> -- sample tables should be gone too
>>
http://git-wip-us.apache.org/repos/asf/trafodion/blob/591e0fa6/core/sql/regress/core/EXPECTED116
----------------------------------------------------------------------
diff --git a/core/sql/regress/core/EXPECTED116 b/core/sql/regress/core/EXPECTED116
index a67e957..fcce935 100644
--- a/core/sql/regress/core/EXPECTED116
+++ b/core/sql/regress/core/EXPECTED116
@@ -735,6 +735,10 @@ Tables in Schema TRAFODION.T116SCH1
T116T1
+=======================
+Summary info of get:
+Get 1 rows.
+
--- SQL operation complete.
>>drop table t116t1;
@@ -748,6 +752,10 @@ SB_HISTOGRAMS
SB_HISTOGRAM_INTERVALS
SB_PERSISTENT_SAMPLES
+=======================
+Summary info of get:
+Get 3 rows.
+
--- SQL operation complete.
>>create table t116t2 (a int);
@@ -762,12 +770,21 @@ SB_HISTOGRAM_INTERVALS
SB_PERSISTENT_SAMPLES
T116T2
+=======================
+Summary info of get:
+Get 4 rows.
+
--- SQL operation complete.
>>drop schema t116sch1 cascade;
--- SQL operation complete.
>>get tables in schema t116sch1;
+
+=======================
+Summary info of get:
+Get 0 rows.
+
--- SQL operation complete.
>>select count(*) from "_MD_".objects where schema_name = 'T116SCH1'
+> for read uncommitted access;
@@ -791,6 +808,10 @@ SB_HISTOGRAM_INTERVALS
SB_PERSISTENT_SAMPLES
T116T1
+=======================
+Summary info of get:
+Get 4 rows.
+
--- SQL operation complete.
>>
>>set schema sch;
http://git-wip-us.apache.org/repos/asf/trafodion/blob/591e0fa6/core/sql/regress/executor/EXPECTED130
----------------------------------------------------------------------
diff --git a/core/sql/regress/executor/EXPECTED130 b/core/sql/regress/executor/EXPECTED130
index fa69e88..a14b67e 100644
--- a/core/sql/regress/executor/EXPECTED130
+++ b/core/sql/regress/executor/EXPECTED130
@@ -1595,6 +1595,10 @@ SB_HISTOGRAM_INTERVALS
SB_PERSISTENT_SAMPLES
TLOB130TS2
+=======================
+Summary info of get:
+Get 7 rows.
+
--- SQL operation complete.
>>drop schema trafodion.lobsch cascade;
http://git-wip-us.apache.org/repos/asf/trafodion/blob/591e0fa6/core/sql/regress/seabase/EXPECTED011
----------------------------------------------------------------------
diff --git a/core/sql/regress/seabase/EXPECTED011 b/core/sql/regress/seabase/EXPECTED011
index 56c32a0..b09633a 100644
--- a/core/sql/regress/seabase/EXPECTED011
+++ b/core/sql/regress/seabase/EXPECTED011
@@ -1295,6 +1295,10 @@ METRIC_QUERY_TABLE
METRIC_SESSION_TABLE
METRIC_TEXT_TABLE
+=======================
+Summary info of get:
+Get 4 rows.
+
--- SQL operation complete.
>>invoke trafodion."_REPOS_".metric_query_table;
http://git-wip-us.apache.org/repos/asf/trafodion/blob/591e0fa6/core/sql/regress/seabase/EXPECTED012
----------------------------------------------------------------------
diff --git a/core/sql/regress/seabase/EXPECTED012 b/core/sql/regress/seabase/EXPECTED012
index 3a59914..66c882b 100644
--- a/core/sql/regress/seabase/EXPECTED012
+++ b/core/sql/regress/seabase/EXPECTED012
@@ -289,6 +289,10 @@ SB_PERSISTENT_SAMPLES
T012T11
T012T12
+=======================
+Summary info of get:
+Get 5 rows.
+
--- SQL operation complete.
>>get indexes in schema trafodion.zschema;
@@ -300,6 +304,10 @@ T012T11C2
T012T11I1
T012T11I2
+=======================
+Summary info of get:
+Get 4 rows.
+
--- SQL operation complete.
>>get views in schema trafodion.zschema;
@@ -308,6 +316,10 @@ Views in Schema TRAFODION.ZSCHEMA
T012T11V1
+=======================
+Summary info of get:
+Get 1 rows.
+
--- SQL operation complete.
>>
>>drop schema trafodion.zschema cascade;
@@ -316,12 +328,27 @@ T012T11V1
>>
>>get tables in schema trafodion.zschema;
+
+=======================
+Summary info of get:
+Get 0 rows.
+
--- SQL operation complete.
>>get indexes in schema trafodion.zschema;
+
+=======================
+Summary info of get:
+Get 0 rows.
+
--- SQL operation complete.
>>get views in schema trafodion.zschema;
+
+=======================
+Summary info of get:
+Get 0 rows.
+
--- SQL operation complete.
>>
>>obey TEST012(getStmts);
@@ -364,6 +391,10 @@ Tables in View ZSCHEMA1.V
TRAFODION.ZSCHEMA1.T
TRAFODION.ZSCHEMA2.T
+=======================
+Summary info of get:
+Get 2 rows.
+
--- SQL operation complete.
>>get views on table zschema1.t;
@@ -373,6 +404,10 @@ Views on Table ZSCHEMA1.T
TRAFODION.ZSCHEMA1.V
TRAFODION.ZSCHEMA2.V
+=======================
+Summary info of get:
+Get 2 rows.
+
--- SQL operation complete.
>>
>>get tables in view zschema2.v2;
@@ -382,6 +417,10 @@ Tables in View ZSCHEMA2.V2
TRAFODION.ZSCHEMA2.T
+=======================
+Summary info of get:
+Get 1 rows.
+
--- SQL operation complete.
>>get all tables in view zschema2.v2;
@@ -391,6 +430,10 @@ Tables in View ZSCHEMA2.V2
TRAFODION.ZSCHEMA1.T
TRAFODION.ZSCHEMA2.T
+=======================
+Summary info of get:
+Get 2 rows.
+
--- SQL operation complete.
>>get views in view zschema2.v2;
@@ -399,6 +442,10 @@ Views in View ZSCHEMA2.V2
TRAFODION.ZSCHEMA1.V
+=======================
+Summary info of get:
+Get 1 rows.
+
--- SQL operation complete.
>>get all objects in view zschema2.v2;
@@ -409,6 +456,11 @@ TRAFODION.ZSCHEMA1.T
TRAFODION.ZSCHEMA1.V
TRAFODION.ZSCHEMA2.T
+
+=======================
+Summary info of get:
+Get 3 rows.
+
--- SQL operation complete.
>>
>>drop schema zschema1 cascade;
http://git-wip-us.apache.org/repos/asf/trafodion/blob/591e0fa6/core/sql/regress/seabase/EXPECTED022
----------------------------------------------------------------------
diff --git a/core/sql/regress/seabase/EXPECTED022 b/core/sql/regress/seabase/EXPECTED022
index f7f10d4..c89b2bd 100644
--- a/core/sql/regress/seabase/EXPECTED022
+++ b/core/sql/regress/seabase/EXPECTED022
@@ -1265,6 +1265,9 @@ HBase Registered Tables in Catalog TRAFODION
"_CELL_".T022HBM2
"_ROW_".T022HBM2
+=======================
+Summary info of get:
+Get 2 rows.
--- SQL operation complete.
>>unregister hbase table t022hbm2;
@@ -1280,6 +1283,9 @@ HBase Registered Tables in Catalog TRAFODION
"_CELL_".T022HBM2
"_ROW_".T022HBM2
+=======================
+Summary info of get:
+Get 2 rows.
--- SQL operation complete.
>>showddl hbase."_CELL_".t022hbm2;
@@ -1333,6 +1339,11 @@ REGISTER HBASE TABLE T022HBM2;
--- SQL operation complete.
>>get hbase registered tables in catalog trafodion, match '%T022HBM2%';
+
+=======================
+Summary info of get:
+Get 0 rows.
+
--- SQL operation complete.
>>showddl hbase."_CELL_".t022hbm2;
@@ -1384,6 +1395,9 @@ HBase Registered Tables in Catalog TRAFODION
"_CELL_".T022HBM2
+=======================
+Summary info of get:
+Get 1 rows.
--- SQL operation complete.
>>showddl hbase."_CELL_".t022hbm2;
@@ -1449,6 +1463,9 @@ HBase Registered Tables in Catalog TRAFODION
"_CELL_".T022HBM2
+=======================
+Summary info of get:
+Get 1 rows.
--- SQL operation complete.
>>showddl hbase."_CELL_".t022hbm2;
http://git-wip-us.apache.org/repos/asf/trafodion/blob/591e0fa6/core/sql/regress/seabase/EXPECTED031
----------------------------------------------------------------------
diff --git a/core/sql/regress/seabase/EXPECTED031 b/core/sql/regress/seabase/EXPECTED031
index f585e01..ea7a11c 100644
--- a/core/sql/regress/seabase/EXPECTED031
+++ b/core/sql/regress/seabase/EXPECTED031
@@ -1072,6 +1072,10 @@ Catalogs
TRAFODION
HIVE
+=======================
+Summary info of get:
+Get 2 rows.
+
--- SQL operation complete.
>>
>>-- external and hive table mismatch on hive 'string' datatype
[9/9] trafodion git commit: merge [TRAFODION-3101] enhance get
command to show rows get
Posted by li...@apache.org.
merge [TRAFODION-3101] enhance get command to show rows get
Project: http://git-wip-us.apache.org/repos/asf/trafodion/repo
Commit: http://git-wip-us.apache.org/repos/asf/trafodion/commit/8b56ed24
Tree: http://git-wip-us.apache.org/repos/asf/trafodion/tree/8b56ed24
Diff: http://git-wip-us.apache.org/repos/asf/trafodion/diff/8b56ed24
Branch: refs/heads/master
Commit: 8b56ed242aa177340ac2767766c42f529c470b88
Parents: efd5647 d5d8f0e
Author: Liu Ming <ov...@sina.com>
Authored: Sat Jul 21 10:51:33 2018 +0000
Committer: Liu Ming <ov...@sina.com>
Committed: Sat Jul 21 10:51:33 2018 +0000
----------------------------------------------------------------------
core/sql/executor/ExExeUtil.h | 8 +
core/sql/executor/ExExeUtilGet.cpp | 24 ++
core/sql/regress/compGeneral/EXPECTED023 | 42 +++
core/sql/regress/core/EXPECTED116 | 12 +
core/sql/regress/executor/EXPECTED130 | 4 +
core/sql/regress/hive/DIFF009.KNOWN | 2 +-
core/sql/regress/hive/EXPECTED007 | 60 ++++
core/sql/regress/hive/EXPECTED009 | 3 +
core/sql/regress/privs1/EXPECTED123 | 318 +++++++++++++++++++++
core/sql/regress/privs1/EXPECTED125 | 390 ++++++++++++++++++++++++++
core/sql/regress/privs1/EXPECTED132 | 48 ++++
core/sql/regress/privs1/EXPECTED136 | 3 +
core/sql/regress/privs1/EXPECTED141 | 30 ++
core/sql/regress/privs2/EXPECTED135 | 18 ++
core/sql/regress/privs2/EXPECTED138 | 105 +++++++
core/sql/regress/privs2/EXPECTED140 | 3 +
core/sql/regress/privs2/EXPECTED143 | 12 +
core/sql/regress/privs2/EXPECTED144 | 45 +++
core/sql/regress/privs2/EXPECTED146 | 36 +++
core/sql/regress/seabase/EXPECTED011 | 3 +
core/sql/regress/seabase/EXPECTED012 | 52 ++++
core/sql/regress/seabase/EXPECTED022 | 12 +
core/sql/regress/seabase/EXPECTED031 | 3 +
core/sql/regress/udr/EXPECTED001 | 6 +
core/sql/regress/udr/EXPECTED102 | 30 ++
core/sql/regress/udr/EXPECTED103 | 6 +
core/sql/regress/udr/EXPECTED107.SB | 3 +
27 files changed, 1277 insertions(+), 1 deletion(-)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/trafodion/blob/8b56ed24/core/sql/executor/ExExeUtil.h
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/trafodion/blob/8b56ed24/core/sql/executor/ExExeUtilGet.cpp
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/trafodion/blob/8b56ed24/core/sql/regress/executor/EXPECTED130
----------------------------------------------------------------------
[3/9] trafodion git commit: fix issues for local var and support
complex get command
Posted by li...@apache.org.
fix issues for local var and support complex get command
Project: http://git-wip-us.apache.org/repos/asf/trafodion/repo
Commit: http://git-wip-us.apache.org/repos/asf/trafodion/commit/14f57eaa
Tree: http://git-wip-us.apache.org/repos/asf/trafodion/tree/14f57eaa
Diff: http://git-wip-us.apache.org/repos/asf/trafodion/diff/14f57eaa
Branch: refs/heads/master
Commit: 14f57eaad0e8ffae58ff79f42c29b551e8fa2280
Parents: e18bab4
Author: Liu Ming <ov...@sina.com>
Authored: Wed Jul 11 12:24:38 2018 -0400
Committer: Liu Ming <ov...@sina.com>
Committed: Wed Jul 11 12:24:38 2018 -0400
----------------------------------------------------------------------
core/sql/executor/ExExeUtil.h | 7 +++++++
core/sql/executor/ExExeUtilGet.cpp | 21 ++++++++++++++++-----
2 files changed, 23 insertions(+), 5 deletions(-)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/trafodion/blob/14f57eaa/core/sql/executor/ExExeUtil.h
----------------------------------------------------------------------
diff --git a/core/sql/executor/ExExeUtil.h b/core/sql/executor/ExExeUtil.h
index 595a0a6..dac9c18 100644
--- a/core/sql/executor/ExExeUtil.h
+++ b/core/sql/executor/ExExeUtil.h
@@ -2491,6 +2491,11 @@ protected:
Lng32 getUsedObjects(Queue * infoList,
NABoolean isShorthandView,
char* &viewName, Lng32 &len);
+ void setReturnRowCount( Lng32 n) { returnRowCount_ = n; }
+
+ Lng32 getReturnRowCount() {return returnRowCount_;}
+
+ void incReturnRowCount() {returnRowCount_++; }
private:
@@ -2518,6 +2523,8 @@ private:
const char *schName,
const char *objName);
+ Lng32 returnRowCount_;
+
};
//////////////////////////////////////////////////////////////////////////
http://git-wip-us.apache.org/repos/asf/trafodion/blob/14f57eaa/core/sql/executor/ExExeUtilGet.cpp
----------------------------------------------------------------------
diff --git a/core/sql/executor/ExExeUtilGet.cpp b/core/sql/executor/ExExeUtilGet.cpp
index 27064e2..dbc5097 100644
--- a/core/sql/executor/ExExeUtilGet.cpp
+++ b/core/sql/executor/ExExeUtilGet.cpp
@@ -149,6 +149,7 @@ ExExeUtilGetMetadataInfoTcb::ExExeUtilGetMetadataInfoTcb(
patternStr_ = new(glob->getDefaultHeap()) char[1000];
numOutputEntries_ = 0;
+ returnRowCount_ = 0;
}
ExExeUtilGetMetadataInfoTcb::~ExExeUtilGetMetadataInfoTcb()
@@ -1818,11 +1819,8 @@ short ExExeUtilGetMetadataInfoTcb::work()
{
short retcode = 0;
Lng32 cliRC = 0;
- Lng32 returnRowCount=0;
- char returnMsg[256];
ex_expr::exp_return_type exprRetCode = ex_expr::EXPR_OK;
- memset(returnMsg, 0, 256);
// if no parent request, return
if (qparent_.down->isEmpty())
@@ -3188,7 +3186,7 @@ short ExExeUtilGetMetadataInfoTcb::work()
}
infoList_->advance();
- returnRowCount++;
+ incReturnRowCount();
}
break;
@@ -3351,7 +3349,9 @@ short ExExeUtilGetMetadataInfoTcb::work()
if (NOT getMItdb().noHeader())
{
short rc = 0;
- sprintf(returnMsg, "\n=======================\nSummary info of get:\nGet %d rows.", returnRowCount);
+ char returnMsg[256];
+ memset(returnMsg, 0, 256);
+ sprintf(returnMsg, "\n=======================\nSummary info of get:\nGet %d rows.", getReturnRowCount());
moveRowToUpQueue(returnMsg, strlen(returnMsg), &rc);
moveRowToUpQueue(" ");
}
@@ -3891,6 +3891,7 @@ short ExExeUtilGetMetadataInfoComplexTcb::work()
moveRowToUpQueue(" ", 0, &rc);
infoList_->advance();
+ incReturnRowCount();
}
break;
@@ -3906,6 +3907,15 @@ short ExExeUtilGetMetadataInfoComplexTcb::work()
case DONE_:
{
+ if (NOT getMItdb().noHeader())
+ {
+ short rc = 0;
+ char returnMsg[256];
+ memset(returnMsg, 0, 256);
+ sprintf(returnMsg, "\n=======================\nSummary info of get:\nGet %d rows.", getReturnRowCount());
+ moveRowToUpQueue(returnMsg, strlen(returnMsg), &rc);
+ moveRowToUpQueue(" ");
+ }
retcode = handleDone();
if (retcode == 1)
return WORK_OK;
@@ -4741,6 +4751,7 @@ short ExExeUtilGetHiveMetadataInfoTcb::work()
}
infoList_->advance();
+ incReturnRowCount();
}
break;
[6/9] trafodion git commit: fix regression test failure
Posted by li...@apache.org.
fix regression test failure
Project: http://git-wip-us.apache.org/repos/asf/trafodion/repo
Commit: http://git-wip-us.apache.org/repos/asf/trafodion/commit/ea5b8b7f
Tree: http://git-wip-us.apache.org/repos/asf/trafodion/tree/ea5b8b7f
Diff: http://git-wip-us.apache.org/repos/asf/trafodion/diff/ea5b8b7f
Branch: refs/heads/master
Commit: ea5b8b7f80ba4383dfd3737782ca36f5bf4e4256
Parents: 833f820
Author: Liu Ming <ov...@sina.com>
Authored: Sun Jul 15 23:43:31 2018 -0400
Committer: Liu Ming <ov...@sina.com>
Committed: Sun Jul 15 23:43:31 2018 -0400
----------------------------------------------------------------------
core/sql/regress/core/EXPECTED116 | 16 ++++------------
core/sql/regress/seabase/EXPECTED022 | 6 ------
2 files changed, 4 insertions(+), 18 deletions(-)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/trafodion/blob/ea5b8b7f/core/sql/regress/core/EXPECTED116
----------------------------------------------------------------------
diff --git a/core/sql/regress/core/EXPECTED116 b/core/sql/regress/core/EXPECTED116
index fed4995..f85703d 100644
--- a/core/sql/regress/core/EXPECTED116
+++ b/core/sql/regress/core/EXPECTED116
@@ -736,9 +736,7 @@ Tables in Schema TRAFODION.T116SCH1
T116T1
=======================
-Summary info of get:
-Get 1 rows.
-
+ 1 row(s) returned
--- SQL operation complete.
>>drop table t116t1;
@@ -754,9 +752,7 @@ SB_HISTOGRAM_INTERVALS
SB_PERSISTENT_SAMPLES
=======================
-Summary info of get:
-Get 3 rows.
-
+ 3 row(s) returned
--- SQL operation complete.
>>create table t116t2 (a int);
@@ -773,9 +769,7 @@ SB_PERSISTENT_SAMPLES
T116T2
=======================
-Summary info of get:
-Get 4 rows.
-
+ 4 row(s) returned
--- SQL operation complete.
>>drop schema t116sch1 cascade;
@@ -813,9 +807,7 @@ SB_PERSISTENT_SAMPLES
T116T1
=======================
-Summary info of get:
-Get 4 rows.
-
+ 4 row(s) returned
--- SQL operation complete.
>>
http://git-wip-us.apache.org/repos/asf/trafodion/blob/ea5b8b7f/core/sql/regress/seabase/EXPECTED022
----------------------------------------------------------------------
diff --git a/core/sql/regress/seabase/EXPECTED022 b/core/sql/regress/seabase/EXPECTED022
index d6af35f..ffd51e2 100644
--- a/core/sql/regress/seabase/EXPECTED022
+++ b/core/sql/regress/seabase/EXPECTED022
@@ -1339,12 +1339,6 @@ REGISTER HBASE TABLE T022HBM2;
--- SQL operation complete.
>>get hbase registered tables in catalog trafodion, match '%T022HBM2%';
-
-=======================
-Summary info of get:
-Get 0 rows.
-
-
--- SQL operation complete.
>>showddl hbase."_CELL_".t022hbm2;
[5/9] trafodion git commit: fix regression failures
Posted by li...@apache.org.
fix regression failures
Project: http://git-wip-us.apache.org/repos/asf/trafodion/repo
Commit: http://git-wip-us.apache.org/repos/asf/trafodion/commit/833f8206
Tree: http://git-wip-us.apache.org/repos/asf/trafodion/tree/833f8206
Diff: http://git-wip-us.apache.org/repos/asf/trafodion/diff/833f8206
Branch: refs/heads/master
Commit: 833f820675f44c58b5ad219fe2d6265616723f5b
Parents: 00e9d5b
Author: Liu Ming <ov...@sina.com>
Authored: Sun Jul 15 17:27:43 2018 -0400
Committer: Liu Ming <ov...@sina.com>
Committed: Sun Jul 15 17:27:43 2018 -0400
----------------------------------------------------------------------
core/sql/executor/ExExeUtil.h | 3 +-
core/sql/executor/ExExeUtilGet.cpp | 2 ++
core/sql/regress/hive/EXPECTED007 | 60 +++++++++++++++++++++++++++++++
core/sql/regress/hive/EXPECTED009 | 4 +--
core/sql/regress/privs1/EXPECTED132 | 48 +++++++++++++++++++++++++
core/sql/regress/seabase/EXPECTED011 | 4 +--
core/sql/regress/seabase/EXPECTED022 | 16 +++------
core/sql/regress/seabase/EXPECTED031 | 4 +--
8 files changed, 119 insertions(+), 22 deletions(-)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/trafodion/blob/833f8206/core/sql/executor/ExExeUtil.h
----------------------------------------------------------------------
diff --git a/core/sql/executor/ExExeUtil.h b/core/sql/executor/ExExeUtil.h
index dac9c18..4e760d9 100644
--- a/core/sql/executor/ExExeUtil.h
+++ b/core/sql/executor/ExExeUtil.h
@@ -2497,6 +2497,8 @@ protected:
void incReturnRowCount() {returnRowCount_++; }
+ Lng32 returnRowCount_;
+
private:
NABoolean checkUserPrivs(ContextCli * currConnext, const ComTdbExeUtilGetMetadataInfo::QueryType queryType);
@@ -2523,7 +2525,6 @@ private:
const char *schName,
const char *objName);
- Lng32 returnRowCount_;
};
http://git-wip-us.apache.org/repos/asf/trafodion/blob/833f8206/core/sql/executor/ExExeUtilGet.cpp
----------------------------------------------------------------------
diff --git a/core/sql/executor/ExExeUtilGet.cpp b/core/sql/executor/ExExeUtilGet.cpp
index 60486de..36e19f0 100644
--- a/core/sql/executor/ExExeUtilGet.cpp
+++ b/core/sql/executor/ExExeUtilGet.cpp
@@ -1851,6 +1851,7 @@ short ExExeUtilGetMetadataInfoTcb::work()
headingReturned_ = FALSE;
numOutputEntries_ = 1;
+ returnRowCount_ = 0 ;
objectUid_[0] = 0;
}
@@ -3420,6 +3421,7 @@ short ExExeUtilGetMetadataInfoComplexTcb::work()
case INITIAL_:
{
step_ = SETUP_QUERY_;
+ returnRowCount_ = 0 ;
}
break;
http://git-wip-us.apache.org/repos/asf/trafodion/blob/833f8206/core/sql/regress/hive/EXPECTED007
----------------------------------------------------------------------
diff --git a/core/sql/regress/hive/EXPECTED007 b/core/sql/regress/hive/EXPECTED007
index 4674f01..600d1b8 100644
--- a/core/sql/regress/hive/EXPECTED007
+++ b/core/sql/regress/hive/EXPECTED007
@@ -198,6 +198,9 @@ Tables in View SCH007.VHIVE1
HIVE.HIVE.THIVE1
+=======================
+ 1 row(s) returned
+
--- SQL operation complete.
>>get tables in view trafodion.sch007.vhive11;
@@ -206,6 +209,9 @@ Tables in View SCH007.VHIVE11
HIVE.HIVE.THIVE2
+=======================
+ 1 row(s) returned
+
--- SQL operation complete.
>>
>>get all tables in view trafodion.sch007.vhive3;
@@ -216,6 +222,9 @@ Tables in View SCH007.VHIVE3
HIVE.HIVE.THIVE1
HIVE.HIVE.THIVE2
+=======================
+ 2 row(s) returned
+
--- SQL operation complete.
>>get views in view trafodion.sch007.vhive3;
@@ -224,6 +233,9 @@ Views in View SCH007.VHIVE3
TRAFODION.SCH007.VHIVE2
+=======================
+ 1 row(s) returned
+
--- SQL operation complete.
>>get views on table hive.hive.thive1;
@@ -233,6 +245,9 @@ Views on Table HIVE.THIVE1
TRAFODION.SCH007.VHIVE1
TRAFODION.SCH007.VHIVE2
+=======================
+ 2 row(s) returned
+
--- SQL operation complete.
>>get all views on table hive.hive.thive2;
@@ -244,6 +259,9 @@ TRAFODION.SCH007.VHIVE2
TRAFODION.SCH007.VHIVE3
TRAFODION.SCH007.VHIVEHBASE
+=======================
+ 4 row(s) returned
+
--- SQL operation complete.
>>
>>drop external table thive2 for hive.hive.thive2 cascade;
@@ -283,6 +301,9 @@ TRAFODION.SCH007.VHIVE2
TRAFODION.SCH007.VHIVE3
TRAFODION.SCH007.VHIVEHBASE
+=======================
+ 4 row(s) returned
+
--- SQL operation complete.
>>
>>obey TEST007(error_tests_traf);
@@ -647,6 +668,9 @@ Views in View SCH007.VTRAFONHIVE
HIVE.HIVESCH007.VHIVE11
+=======================
+ 1 row(s) returned
+
--- SQL operation complete.
>>get views on view hive.hivesch007.vhive11;
@@ -655,6 +679,9 @@ Views ON View HIVESCH007.VHIVE11
TRAFODION.SCH007.VTRAFONHIVE
+=======================
+ 1 row(s) returned
+
--- SQL operation complete.
>>
>>unregister hive view hive.hivesch007.vhive11 cascade;
@@ -694,6 +721,9 @@ Views in View HIVESCH007.VHIVE11
HIVE.HIVESCH007.VHIVE1
+=======================
+ 1 row(s) returned
+
--- SQL operation complete.
>>get views on table hive.hivesch007.thive1;
@@ -702,6 +732,9 @@ Views on Table HIVESCH007.THIVE1
HIVE.HIVESCH007.VHIVE1
+=======================
+ 1 row(s) returned
+
--- SQL operation complete.
>>get views on view hive.hivesch007.vhive1;
@@ -710,6 +743,9 @@ Views ON View HIVESCH007.VHIVE1
HIVE.HIVESCH007.VHIVE11
+=======================
+ 1 row(s) returned
+
--- SQL operation complete.
>>
>>-- tests for recursive hive view/table register/unregister operations
@@ -759,6 +795,9 @@ Tables in View HIVESCH0071.VH11
HIVE.HIVESCH0071.H1
+=======================
+ 1 row(s) returned
+
--- SQL operation complete.
>>get views in view vh11;
@@ -767,6 +806,9 @@ Views in View HIVESCH0071.VH11
HIVE.HIVESCH0071.VH1
+=======================
+ 1 row(s) returned
+
--- SQL operation complete.
>>get all objects in view vh11;
@@ -776,6 +818,9 @@ Objects in View HIVESCH0071.VH11
HIVE.HIVESCH0071.H1
HIVE.HIVESCH0071.VH1
+=======================
+ 2 row(s) returned
+
--- SQL operation complete.
>>
>>get hive registered tables in catalog trafodion, match '%hivesch0071%';
@@ -785,6 +830,9 @@ Hive Registered Tables in Catalog TRAFODION
hive.hivesch0071.h1
+=======================
+ 1 row(s) returned
+
--- SQL operation complete.
>>get hive registered views in catalog trafodion, match '%hivesch0071%';
@@ -794,6 +842,9 @@ Hive Registered Views in Catalog TRAFODION
hive.hivesch0071.vh1
hive.hivesch0071.vh11
+=======================
+ 2 row(s) returned
+
--- SQL operation complete.
>>get hive registered objects in catalog trafodion, match '%hivesch0071%';
@@ -804,6 +855,9 @@ hive.hivesch0071.h1
hive.hivesch0071.vh1
hive.hivesch0071.vh11
+=======================
+ 3 row(s) returned
+
--- SQL operation complete.
>>
>>select object_name from trafodion."_MD_".objects where schema_name = 'HIVESCH0071';
@@ -884,6 +938,9 @@ Hive Registered Schemas in Catalog TRAFODION
hive.hivesch0078
+=======================
+ 1 row(s) returned
+
--- SQL operation complete.
>>unregister hive schema hive.hivesch0078;
@@ -1017,6 +1074,9 @@ Privileges for User SQL_USER3
S------ HIVE.HIVESCH007.THIVE9
+=======================
+ 1 row(s) returned
+
--- SQL operation complete.
>>insert into hive.hivesch007.thive9 values (1), (2), (3), (4), (5), (6);
http://git-wip-us.apache.org/repos/asf/trafodion/blob/833f8206/core/sql/regress/hive/EXPECTED009
----------------------------------------------------------------------
diff --git a/core/sql/regress/hive/EXPECTED009 b/core/sql/regress/hive/EXPECTED009
index 29f6d75..26f220f 100644
--- a/core/sql/regress/hive/EXPECTED009
+++ b/core/sql/regress/hive/EXPECTED009
@@ -431,9 +431,7 @@ T009T1
T009T2
=======================
-Summary info of get:
-Get 2 rows.
-
+ 2 row(s) returned
--- SQL operation complete.
>>invoke hive.sch_t009.t009t1;
http://git-wip-us.apache.org/repos/asf/trafodion/blob/833f8206/core/sql/regress/privs1/EXPECTED132
----------------------------------------------------------------------
diff --git a/core/sql/regress/privs1/EXPECTED132 b/core/sql/regress/privs1/EXPECTED132
index 0c9f2fe..7a60061 100644
--- a/core/sql/regress/privs1/EXPECTED132
+++ b/core/sql/regress/privs1/EXPECTED132
@@ -21,6 +21,9 @@ Privilege information on Component SQL_OPERATIONS for PUBLIC
CREATE_SCHEMA
SHOW
+=======================
+ 2 row(s) returned
+
--- SQL operation complete.
>>
>>-- succeed: DB__ROOT can create a library
@@ -42,6 +45,9 @@ Libraries in Schema TRAFODION.T132SCH
T132_L1
+=======================
+ 1 row(s) returned
+
--- SQL operation complete.
>>drop library t132_l1;
@@ -103,6 +109,9 @@ Libraries in Schema TRAFODION.T132SCH
T132_L1
+=======================
+ 1 row(s) returned
+
--- SQL operation complete.
>>drop library t132_l1;
@@ -171,6 +180,9 @@ Libraries in Schema TRAFODION.T132SCH
T132_L1
+=======================
+ 1 row(s) returned
+
--- SQL operation complete.
>>drop library t132_l1;
@@ -199,6 +211,9 @@ Privilege information on Component SQL_OPERATIONS for PUBLIC
CREATE_SCHEMA
SHOW
+=======================
+ 2 row(s) returned
+
--- SQL operation complete.
>>
>>obey TEST132(test_popindex);
@@ -249,6 +264,9 @@ Tables in Schema TRAFODION.T132SCH
T132T1
T132T2
+=======================
+ 2 row(s) returned
+
--- SQL operation complete.
>>cqd SHOWDDL_DISPLAY_PRIVILEGE_GRANTS 'ON';
@@ -649,6 +667,9 @@ Privilege information on Component SQL_OPERATIONS for PUBLIC
CREATE_SCHEMA
SHOW
+=======================
+ 2 row(s) returned
+
--- SQL operation complete.
>>revoke component privilege "SHOW" on sql_operations from "PUBLIC";
@@ -660,6 +681,9 @@ Privilege information on Component SQL_OPERATIONS for PUBLIC
CREATE_SCHEMA
+=======================
+ 1 row(s) returned
+
--- SQL operation complete.
>>
>>-- DB__ROOT has all privileges
@@ -1265,6 +1289,9 @@ Privilege information on Component SQL_OPERATIONS for PUBLIC
CREATE_SCHEMA
+=======================
+ 1 row(s) returned
+
--- SQL operation complete.
>>grant component privilege "SHOW" on sql_operations to "PUBLIC";
@@ -1277,6 +1304,9 @@ Privilege information on Component SQL_OPERATIONS for PUBLIC
CREATE_SCHEMA
SHOW
+=======================
+ 2 row(s) returned
+
--- SQL operation complete.
>>changeuser sql_user1;
>>obey TEST132(show_objects);
@@ -1494,6 +1524,9 @@ Tables in Schema TRAFODION.T132SCH
T132T1
T132T2
+=======================
+ 2 row(s) returned
+
--- SQL operation complete.
>>select count(*) from t132t1;
@@ -1636,6 +1669,9 @@ Privilege information on Component SQL_OPERATIONS for PUBLIC
CREATE_SCHEMA
SHOW
+=======================
+ 2 row(s) returned
+
--- SQL operation complete.
>>revoke component privilege "SHOW" on sql_operations from "PUBLIC";
@@ -1647,6 +1683,9 @@ Privilege information on Component SQL_OPERATIONS for PUBLIC
CREATE_SCHEMA
+=======================
+ 1 row(s) returned
+
--- SQL operation complete.
>>
>>-- Run with MANAGE_STATISTICS and no SHOW
@@ -1709,6 +1748,9 @@ Privilege information on Component SQL_OPERATIONS for SQL_USER3
MANAGE_STATISTICS
+=======================
+ 1 row(s) returned
+
--- SQL operation complete.
>>changeuser sql_user3;
>>obey TEST132(show_update_stats);
@@ -1889,6 +1931,9 @@ Privilege information on Component SQL_OPERATIONS for SQL_USER3
MANAGE_STATISTICS
+=======================
+ 1 row(s) returned
+
--- SQL operation complete.
>>changeuser sql_user3;
>>obey TEST132(update_stats1);
@@ -1928,6 +1973,9 @@ Privilege information on Component SQL_OPERATIONS for PUBLIC
CREATE_SCHEMA
SHOW
+=======================
+ 2 row(s) returned
+
--- SQL operation complete.
>>
>>drop table t132t1;
http://git-wip-us.apache.org/repos/asf/trafodion/blob/833f8206/core/sql/regress/seabase/EXPECTED011
----------------------------------------------------------------------
diff --git a/core/sql/regress/seabase/EXPECTED011 b/core/sql/regress/seabase/EXPECTED011
index b69abc2..b4c1608 100644
--- a/core/sql/regress/seabase/EXPECTED011
+++ b/core/sql/regress/seabase/EXPECTED011
@@ -1296,9 +1296,7 @@ METRIC_SESSION_TABLE
METRIC_TEXT_TABLE
=======================
-Summary info of get:
-Get 4 rows.
-
+ 4 row(s) returned
--- SQL operation complete.
>>invoke trafodion."_REPOS_".metric_query_table;
http://git-wip-us.apache.org/repos/asf/trafodion/blob/833f8206/core/sql/regress/seabase/EXPECTED022
----------------------------------------------------------------------
diff --git a/core/sql/regress/seabase/EXPECTED022 b/core/sql/regress/seabase/EXPECTED022
index 1a30599..d6af35f 100644
--- a/core/sql/regress/seabase/EXPECTED022
+++ b/core/sql/regress/seabase/EXPECTED022
@@ -1266,9 +1266,7 @@ HBase Registered Tables in Catalog TRAFODION
"_ROW_".T022HBM2
=======================
-Summary info of get:
-Get 2 rows.
-
+ 2 row(s) returned
--- SQL operation complete.
>>unregister hbase table t022hbm2;
@@ -1286,9 +1284,7 @@ HBase Registered Tables in Catalog TRAFODION
"_ROW_".T022HBM2
=======================
-Summary info of get:
-Get 2 rows.
-
+ 2 row(s) returned
--- SQL operation complete.
>>showddl hbase."_CELL_".t022hbm2;
@@ -1401,9 +1397,7 @@ HBase Registered Tables in Catalog TRAFODION
"_CELL_".T022HBM2
=======================
-Summary info of get:
-Get 1 rows.
-
+ 1 row(s) returned
--- SQL operation complete.
>>showddl hbase."_CELL_".t022hbm2;
@@ -1471,9 +1465,7 @@ HBase Registered Tables in Catalog TRAFODION
"_CELL_".T022HBM2
=======================
-Summary info of get:
-Get 1 rows.
-
+ 1 row(s) returned
--- SQL operation complete.
>>showddl hbase."_CELL_".t022hbm2;
http://git-wip-us.apache.org/repos/asf/trafodion/blob/833f8206/core/sql/regress/seabase/EXPECTED031
----------------------------------------------------------------------
diff --git a/core/sql/regress/seabase/EXPECTED031 b/core/sql/regress/seabase/EXPECTED031
index c6e3562..fdb9f48 100644
--- a/core/sql/regress/seabase/EXPECTED031
+++ b/core/sql/regress/seabase/EXPECTED031
@@ -1073,9 +1073,7 @@ TRAFODION
HIVE
=======================
-Summary info of get:
-Get 2 rows.
-
+ 2 row(s) returned
--- SQL operation complete.
>>
[2/9] trafodion git commit: fix sql regressions
Posted by li...@apache.org.
fix sql regressions
Project: http://git-wip-us.apache.org/repos/asf/trafodion/repo
Commit: http://git-wip-us.apache.org/repos/asf/trafodion/commit/e18bab4d
Tree: http://git-wip-us.apache.org/repos/asf/trafodion/tree/e18bab4d
Diff: http://git-wip-us.apache.org/repos/asf/trafodion/diff/e18bab4d
Branch: refs/heads/master
Commit: e18bab4d79c7eb6059bebbb78be7ddeeb05bfd1f
Parents: 591e0fa
Author: Liu Ming <ov...@sina.com>
Authored: Mon Jun 25 02:47:42 2018 -0400
Committer: Liu Ming <ov...@sina.com>
Committed: Mon Jun 25 02:47:42 2018 -0400
----------------------------------------------------------------------
core/sql/executor/ExExeUtilGet.cpp | 1 -
core/sql/regress/core/EXPECTED116 | 5 +++++
core/sql/regress/hive/EXPECTED009 | 5 +++++
core/sql/regress/seabase/EXPECTED011 | 1 +
core/sql/regress/seabase/EXPECTED022 | 9 +++++++++
core/sql/regress/seabase/EXPECTED031 | 1 +
6 files changed, 21 insertions(+), 1 deletion(-)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/trafodion/blob/e18bab4d/core/sql/executor/ExExeUtilGet.cpp
----------------------------------------------------------------------
diff --git a/core/sql/executor/ExExeUtilGet.cpp b/core/sql/executor/ExExeUtilGet.cpp
index 5bb4793..27064e2 100644
--- a/core/sql/executor/ExExeUtilGet.cpp
+++ b/core/sql/executor/ExExeUtilGet.cpp
@@ -949,7 +949,6 @@ short ExExeUtilGetMetadataInfoTcb::displayHeading()
{
if (getMItdb().noHeader())
{
-printf("LMDBG noheader is true\n");
return 0;
}
// make sure there is enough space to move header
http://git-wip-us.apache.org/repos/asf/trafodion/blob/e18bab4d/core/sql/regress/core/EXPECTED116
----------------------------------------------------------------------
diff --git a/core/sql/regress/core/EXPECTED116 b/core/sql/regress/core/EXPECTED116
index fcce935..fed4995 100644
--- a/core/sql/regress/core/EXPECTED116
+++ b/core/sql/regress/core/EXPECTED116
@@ -739,6 +739,7 @@ T116T1
Summary info of get:
Get 1 rows.
+
--- SQL operation complete.
>>drop table t116t1;
@@ -756,6 +757,7 @@ SB_PERSISTENT_SAMPLES
Summary info of get:
Get 3 rows.
+
--- SQL operation complete.
>>create table t116t2 (a int);
@@ -774,6 +776,7 @@ T116T2
Summary info of get:
Get 4 rows.
+
--- SQL operation complete.
>>drop schema t116sch1 cascade;
@@ -785,6 +788,7 @@ Get 4 rows.
Summary info of get:
Get 0 rows.
+
--- SQL operation complete.
>>select count(*) from "_MD_".objects where schema_name = 'T116SCH1'
+> for read uncommitted access;
@@ -812,6 +816,7 @@ T116T1
Summary info of get:
Get 4 rows.
+
--- SQL operation complete.
>>
>>set schema sch;
http://git-wip-us.apache.org/repos/asf/trafodion/blob/e18bab4d/core/sql/regress/hive/EXPECTED009
----------------------------------------------------------------------
diff --git a/core/sql/regress/hive/EXPECTED009 b/core/sql/regress/hive/EXPECTED009
index fad737c..29f6d75 100644
--- a/core/sql/regress/hive/EXPECTED009
+++ b/core/sql/regress/hive/EXPECTED009
@@ -430,6 +430,11 @@ Tables in Schema TRAFODION._HV_SCH_T009_
T009T1
T009T2
+=======================
+Summary info of get:
+Get 2 rows.
+
+
--- SQL operation complete.
>>invoke hive.sch_t009.t009t1;
http://git-wip-us.apache.org/repos/asf/trafodion/blob/e18bab4d/core/sql/regress/seabase/EXPECTED011
----------------------------------------------------------------------
diff --git a/core/sql/regress/seabase/EXPECTED011 b/core/sql/regress/seabase/EXPECTED011
index b09633a..b69abc2 100644
--- a/core/sql/regress/seabase/EXPECTED011
+++ b/core/sql/regress/seabase/EXPECTED011
@@ -1299,6 +1299,7 @@ METRIC_TEXT_TABLE
Summary info of get:
Get 4 rows.
+
--- SQL operation complete.
>>invoke trafodion."_REPOS_".metric_query_table;
http://git-wip-us.apache.org/repos/asf/trafodion/blob/e18bab4d/core/sql/regress/seabase/EXPECTED022
----------------------------------------------------------------------
diff --git a/core/sql/regress/seabase/EXPECTED022 b/core/sql/regress/seabase/EXPECTED022
index c89b2bd..1a30599 100644
--- a/core/sql/regress/seabase/EXPECTED022
+++ b/core/sql/regress/seabase/EXPECTED022
@@ -1268,6 +1268,8 @@ HBase Registered Tables in Catalog TRAFODION
=======================
Summary info of get:
Get 2 rows.
+
+
--- SQL operation complete.
>>unregister hbase table t022hbm2;
@@ -1286,6 +1288,8 @@ HBase Registered Tables in Catalog TRAFODION
=======================
Summary info of get:
Get 2 rows.
+
+
--- SQL operation complete.
>>showddl hbase."_CELL_".t022hbm2;
@@ -1344,6 +1348,7 @@ REGISTER HBASE TABLE T022HBM2;
Summary info of get:
Get 0 rows.
+
--- SQL operation complete.
>>showddl hbase."_CELL_".t022hbm2;
@@ -1398,6 +1403,8 @@ HBase Registered Tables in Catalog TRAFODION
=======================
Summary info of get:
Get 1 rows.
+
+
--- SQL operation complete.
>>showddl hbase."_CELL_".t022hbm2;
@@ -1466,6 +1473,8 @@ HBase Registered Tables in Catalog TRAFODION
=======================
Summary info of get:
Get 1 rows.
+
+
--- SQL operation complete.
>>showddl hbase."_CELL_".t022hbm2;
http://git-wip-us.apache.org/repos/asf/trafodion/blob/e18bab4d/core/sql/regress/seabase/EXPECTED031
----------------------------------------------------------------------
diff --git a/core/sql/regress/seabase/EXPECTED031 b/core/sql/regress/seabase/EXPECTED031
index ea7a11c..c6e3562 100644
--- a/core/sql/regress/seabase/EXPECTED031
+++ b/core/sql/regress/seabase/EXPECTED031
@@ -1076,6 +1076,7 @@ HIVE
Summary info of get:
Get 2 rows.
+
--- SQL operation complete.
>>
>>-- external and hive table mismatch on hive 'string' datatype
[8/9] trafodion git commit: fix hive 009
Posted by li...@apache.org.
fix hive 009
Project: http://git-wip-us.apache.org/repos/asf/trafodion/repo
Commit: http://git-wip-us.apache.org/repos/asf/trafodion/commit/d5d8f0ed
Tree: http://git-wip-us.apache.org/repos/asf/trafodion/tree/d5d8f0ed
Diff: http://git-wip-us.apache.org/repos/asf/trafodion/diff/d5d8f0ed
Branch: refs/heads/master
Commit: d5d8f0ed05959df01e38c5bac613b15c81756aeb
Parents: 5146272
Author: Liu Ming <ov...@sina.com>
Authored: Mon Jul 16 21:29:27 2018 -0400
Committer: Liu Ming <ov...@sina.com>
Committed: Mon Jul 16 21:29:27 2018 -0400
----------------------------------------------------------------------
core/sql/regress/hive/DIFF009.KNOWN | 2 +-
core/sql/regress/hive/EXPECTED009 | 2 +-
2 files changed, 2 insertions(+), 2 deletions(-)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/trafodion/blob/d5d8f0ed/core/sql/regress/hive/DIFF009.KNOWN
----------------------------------------------------------------------
diff --git a/core/sql/regress/hive/DIFF009.KNOWN b/core/sql/regress/hive/DIFF009.KNOWN
index 1d1cb73..6bcba59 100644
--- a/core/sql/regress/hive/DIFF009.KNOWN
+++ b/core/sql/regress/hive/DIFF009.KNOWN
@@ -1,3 +1,3 @@
-1071a1072,1073
+1074a1075,1076
> *** WARNING[6008] Statistics for column (D_DATE) from table HIVE.HIVE.DATE_DIM were not available. As a result, the access path chosen might not be the best possible.
>
http://git-wip-us.apache.org/repos/asf/trafodion/blob/d5d8f0ed/core/sql/regress/hive/EXPECTED009
----------------------------------------------------------------------
diff --git a/core/sql/regress/hive/EXPECTED009 b/core/sql/regress/hive/EXPECTED009
index 26f220f..d819195 100644
--- a/core/sql/regress/hive/EXPECTED009
+++ b/core/sql/regress/hive/EXPECTED009
@@ -432,7 +432,7 @@ T009T2
=======================
2 row(s) returned
-
+
--- SQL operation complete.
>>invoke hive.sch_t009.t009t1;
[4/9] trafodion git commit: fix regression failures
Posted by li...@apache.org.
fix regression failures
Project: http://git-wip-us.apache.org/repos/asf/trafodion/repo
Commit: http://git-wip-us.apache.org/repos/asf/trafodion/commit/00e9d5b5
Tree: http://git-wip-us.apache.org/repos/asf/trafodion/tree/00e9d5b5
Diff: http://git-wip-us.apache.org/repos/asf/trafodion/diff/00e9d5b5
Branch: refs/heads/master
Commit: 00e9d5b5852d03da801892f5bb3633274d5bb540
Parents: 14f57ea
Author: Liu Ming <ov...@sina.com>
Authored: Sat Jul 14 16:55:08 2018 -0400
Committer: Liu Ming <ov...@sina.com>
Committed: Sat Jul 14 16:55:08 2018 -0400
----------------------------------------------------------------------
core/sql/executor/ExExeUtilGet.cpp | 10 +-
core/sql/regress/compGeneral/EXPECTED023 | 42 +--
core/sql/regress/privs1/EXPECTED123 | 318 +++++++++++++++++++++
core/sql/regress/privs1/EXPECTED125 | 390 ++++++++++++++++++++++++++
core/sql/regress/privs1/EXPECTED136 | 3 +
core/sql/regress/privs1/EXPECTED141 | 30 ++
core/sql/regress/privs2/EXPECTED135 | 18 ++
core/sql/regress/privs2/EXPECTED138 | 105 +++++++
core/sql/regress/privs2/EXPECTED140 | 3 +
core/sql/regress/privs2/EXPECTED143 | 12 +
core/sql/regress/privs2/EXPECTED144 | 45 +++
core/sql/regress/privs2/EXPECTED146 | 36 +++
core/sql/regress/udr/EXPECTED001 | 6 +
core/sql/regress/udr/EXPECTED102 | 30 ++
core/sql/regress/udr/EXPECTED103 | 6 +
core/sql/regress/udr/EXPECTED107.SB | 3 +
16 files changed, 1023 insertions(+), 34 deletions(-)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/trafodion/blob/00e9d5b5/core/sql/executor/ExExeUtilGet.cpp
----------------------------------------------------------------------
diff --git a/core/sql/executor/ExExeUtilGet.cpp b/core/sql/executor/ExExeUtilGet.cpp
index dbc5097..60486de 100644
--- a/core/sql/executor/ExExeUtilGet.cpp
+++ b/core/sql/executor/ExExeUtilGet.cpp
@@ -3346,14 +3346,13 @@ short ExExeUtilGetMetadataInfoTcb::work()
case DONE_:
{
- if (NOT getMItdb().noHeader())
+ if (NOT getMItdb().noHeader() && getReturnRowCount() > 0)
{
short rc = 0;
char returnMsg[256];
memset(returnMsg, 0, 256);
- sprintf(returnMsg, "\n=======================\nSummary info of get:\nGet %d rows.", getReturnRowCount());
+ sprintf(returnMsg, "\n=======================\n %d row(s) returned", getReturnRowCount());
moveRowToUpQueue(returnMsg, strlen(returnMsg), &rc);
- moveRowToUpQueue(" ");
}
retcode = handleDone();
@@ -3907,14 +3906,13 @@ short ExExeUtilGetMetadataInfoComplexTcb::work()
case DONE_:
{
- if (NOT getMItdb().noHeader())
+ if (NOT getMItdb().noHeader() && getReturnRowCount() > 0)
{
short rc = 0;
char returnMsg[256];
memset(returnMsg, 0, 256);
- sprintf(returnMsg, "\n=======================\nSummary info of get:\nGet %d rows.", getReturnRowCount());
+ sprintf(returnMsg, "\n=======================\n %d row(s) returned", getReturnRowCount());
moveRowToUpQueue(returnMsg, strlen(returnMsg), &rc);
- moveRowToUpQueue(" ");
}
retcode = handleDone();
if (retcode == 1)
http://git-wip-us.apache.org/repos/asf/trafodion/blob/00e9d5b5/core/sql/regress/compGeneral/EXPECTED023
----------------------------------------------------------------------
diff --git a/core/sql/regress/compGeneral/EXPECTED023 b/core/sql/regress/compGeneral/EXPECTED023
index 2f1f012..0ea3503 100644
--- a/core/sql/regress/compGeneral/EXPECTED023
+++ b/core/sql/regress/compGeneral/EXPECTED023
@@ -24,8 +24,7 @@ SB_HISTOGRAM_INTERVALS
SB_PERSISTENT_SAMPLES
=======================
-Summary info of get:
-Get 3 rows.
+ 3 row(s) returned
--- SQL operation complete.
>>
@@ -111,8 +110,7 @@ STESTC
STEST_EMPTY
=======================
-Summary info of get:
-Get 6 rows.
+ 6 row(s) returned
--- SQL operation complete.
>> -- should be just stest, stest_empty, stestc, and the sb_* tables
@@ -158,8 +156,7 @@ STEST_EMPTY
TRAF_SAMPLE_07158060726899021395_1517441663_444545
=======================
-Summary info of get:
-Get 7 rows.
+ 7 row(s) returned
--- SQL operation complete.
>> -- should be stest, stest_empty, stestc, sb_* tables + a sample table
@@ -186,8 +183,7 @@ STEST_EMPTY
TRAF_SAMPLE_07158060726899021395_1517441711_141471
=======================
-Summary info of get:
-Get 7 rows.
+ 7 row(s) returned
--- SQL operation complete.
>> -- should be stest, stest_empty, stestc, sb_* tables + a different sample table
@@ -220,8 +216,7 @@ STESTC
STEST_EMPTY
=======================
-Summary info of get:
-Get 6 rows.
+ 6 row(s) returned
--- SQL operation complete.
>> -- should be stest, stest_empty, stestc, sb_* tables only
@@ -251,8 +246,7 @@ STEST_EMPTY
TRAF_SAMPLE_07158060726899021395_1517441748_979037
=======================
-Summary info of get:
-Get 7 rows.
+ 7 row(s) returned
--- SQL operation complete.
>> -- should be stest, stest_empty, stestc, sb_* tables + another sample table
@@ -289,8 +283,7 @@ STEST_EMPTY
TRAF_SAMPLE_07158060726899021395_1517441802_045572
=======================
-Summary info of get:
-Get 7 rows.
+ 7 row(s) returned
--- SQL operation complete.
>> -- should be stest, stest_empty, stestc, sb_* tables + another sample table
@@ -422,8 +415,7 @@ TRAF_SAMPLE_07158060726899021395_1517441802_045572
TRAF_SAMPLE_07158060726899023220_1517441862_582002
=======================
-Summary info of get:
-Get 8 rows.
+ 8 row(s) returned
--- SQL operation complete.
>>
@@ -461,8 +453,7 @@ TRAF_SAMPLE_07158060726899021395_1517441802_045572
TRAF_SAMPLE_07158060726899023220_1517441862_582002
=======================
-Summary info of get:
-Get 8 rows.
+ 8 row(s) returned
--- SQL operation complete.
>> -- should be the same as previous "get tables"
@@ -493,8 +484,7 @@ TRAF_SAMPLE_07158060726899021395_1517441802_045572
TRAF_SAMPLE_07158060726899023220_1517441862_582002
=======================
-Summary info of get:
-Get 8 rows.
+ 8 row(s) returned
--- SQL operation complete.
>> -- should be the same as previous "get tables"
@@ -526,8 +516,7 @@ TRAF_SAMPLE_07158060726899021395_1517441802_045572
TRAF_SAMPLE_07158060726899023220_1517441862_582002
=======================
-Summary info of get:
-Get 8 rows.
+ 8 row(s) returned
--- SQL operation complete.
>> -- should be the same as previous "get tables"
@@ -561,8 +550,7 @@ TRAF_SAMPLE_07158060726899021395_1517441802_045572
TRAF_SAMPLE_07158060726899023220_1517441862_582002
=======================
-Summary info of get:
-Get 8 rows.
+ 8 row(s) returned
--- SQL operation complete.
>> -- should be the same as previous "get tables"
@@ -616,8 +604,7 @@ STEST_EMPTY
TRAF_SAMPLE_07158060726899021395_1517441802_045572
=======================
-Summary info of get:
-Get 7 rows.
+ 7 row(s) returned
--- SQL operation complete.
>> -- should be the same as previous "get tables" except only one sample table
@@ -645,8 +632,7 @@ SB_HISTOGRAM_INTERVALS
SB_PERSISTENT_SAMPLES
=======================
-Summary info of get:
-Get 3 rows.
+ 3 row(s) returned
--- SQL operation complete.
>> -- sample tables should be gone too
http://git-wip-us.apache.org/repos/asf/trafodion/blob/00e9d5b5/core/sql/regress/privs1/EXPECTED123
----------------------------------------------------------------------
diff --git a/core/sql/regress/privs1/EXPECTED123 b/core/sql/regress/privs1/EXPECTED123
index 45d5db9..dd8211b 100644
--- a/core/sql/regress/privs1/EXPECTED123
+++ b/core/sql/regress/privs1/EXPECTED123
@@ -17,6 +17,9 @@ SQL_USER7
SQL_USER8
SQL_USER9
+=======================
+ 11 row(s) returned
+
--- SQL operation complete.
>>get roles;
@@ -29,6 +32,9 @@ DB__LIBMGRROLE
DB__ROOTROLE
PUBLIC
+=======================
+ 5 row(s) returned
+
--- SQL operation complete.
>>
>>get privileges on component sql_operations for "PUBLIC";
@@ -39,6 +45,9 @@ Privilege information on Component SQL_OPERATIONS for PUBLIC
CREATE_SCHEMA
SHOW
+=======================
+ 2 row(s) returned
+
--- SQL operation complete.
>>
>>create role t123_adminrole;
@@ -195,6 +204,9 @@ SQL_USER7
SQL_USER8
SQL_USER9
+=======================
+ 11 row(s) returned
+
--- SQL operation complete.
>>get roles;
@@ -211,6 +223,9 @@ T123_DUMMYROLE
T123_OWNERROLE
T123_PLANNERROLE
+=======================
+ 9 row(s) returned
+
--- SQL operation complete.
>>get roles for user sql_user1;
@@ -221,6 +236,9 @@ PUBLIC
T123_ADMINROLE
T123_PLANNERROLE
+=======================
+ 3 row(s) returned
+
--- SQL operation complete.
>>get roles for user sql_user2;
@@ -230,6 +248,9 @@ Roles for User SQL_USER2
PUBLIC
T123_PLANNERROLE
+=======================
+ 2 row(s) returned
+
--- SQL operation complete.
>>get roles for user sql_user3;
@@ -238,6 +259,9 @@ Roles for User SQL_USER3
PUBLIC
+=======================
+ 1 row(s) returned
+
--- SQL operation complete.
>>get roles for user sql_user4;
@@ -246,6 +270,9 @@ Roles for User SQL_USER4
PUBLIC
+=======================
+ 1 row(s) returned
+
--- SQL operation complete.
>>get roles for user sql_user5;
@@ -255,6 +282,9 @@ Roles for User SQL_USER5
PUBLIC
T123_OWNERROLE
+=======================
+ 2 row(s) returned
+
--- SQL operation complete.
>>
>>get users for role t123_adminrole;
@@ -264,6 +294,9 @@ Users granted Role T123_ADMINROLE
SQL_USER1
+=======================
+ 1 row(s) returned
+
--- SQL operation complete.
>>get users for role t123_plannerrole;
@@ -273,6 +306,9 @@ Users granted Role T123_PLANNERROLE
SQL_USER1
SQL_USER2
+=======================
+ 2 row(s) returned
+
--- SQL operation complete.
>>get users for role t123_dummyrole;
@@ -284,6 +320,9 @@ Users granted Role T123_OWNERROLE
SQL_USER5
+=======================
+ 1 row(s) returned
+
--- SQL operation complete.
>>
>>get privileges for user sql_user1;
@@ -305,6 +344,9 @@ S------ TRAFODION.T123SCH.PLAYERS <Column> PLAYER_TEAM_NUMBER
S------ TRAFODION.T123SCH.TEAMS <Column> TEAM_NAME
S------ TRAFODION.T123SCH.TEAMS <Column> TEAM_NUMBER
+=======================
+ 13 row(s) returned
+
--- SQL operation complete.
>>get privileges for user sql_user2;
@@ -322,6 +364,9 @@ S------ TRAFODION.T123SCH.PLAYERS <Column> PLAYER_TEAM_NUMBER
S------ TRAFODION.T123SCH.TEAMS <Column> TEAM_NAME
S------ TRAFODION.T123SCH.TEAMS <Column> TEAM_NUMBER
+=======================
+ 10 row(s) returned
+
--- SQL operation complete.
>>get privileges for user sql_user3;
@@ -336,6 +381,9 @@ S------ TRAFODION.T123SCH.PLAYERS <Column> PLAYER_TEAM_NUMBER
S------ TRAFODION.T123SCH.TEAMS <Column> TEAM_NAME
S------ TRAFODION.T123SCH.TEAMS <Column> TEAM_NUMBER
+=======================
+ 7 row(s) returned
+
--- SQL operation complete.
>>get privileges for user sql_user4;
@@ -352,6 +400,9 @@ S------ TRAFODION.T123SCH.TEAMS
S------ TRAFODION.T123SCH.TEAMS <Column> TEAM_NAME
S------ TRAFODION.T123SCH.TEAMS <Column> TEAM_NUMBER
+=======================
+ 9 row(s) returned
+
--- SQL operation complete.
>>get privileges for user sql_user5;
@@ -376,6 +427,9 @@ SIDU-R- TRAFODION.T123SCH.TEAMS
S------ TRAFODION.T123SCH.TEAMS <Column> TEAM_NAME
S------ TRAFODION.T123SCH.TEAMS <Column> TEAM_NUMBER
+=======================
+ 17 row(s) returned
+
--- SQL operation complete.
>>
>>get privileges for role t123_adminrole;
@@ -386,6 +440,9 @@ Privileges for Role T123_ADMINROLE
--DU--- TRAFODION.T123SCH.GAMES
--DU--- TRAFODION.T123SCH.TEAMS
+=======================
+ 2 row(s) returned
+
--- SQL operation complete.
>>get privileges for role t123_plannerrole;
@@ -396,6 +453,9 @@ Privileges for Role T123_PLANNERROLE
----G-- TRAFODION.T123SCH.PLAYERS_SEQUENCE
-I----- TRAFODION.T123SCH.TEAMS
+=======================
+ 3 row(s) returned
+
--- SQL operation complete.
>>get privileges for role t123_dummyrole;
@@ -416,6 +476,9 @@ SIDU-R- TRAFODION.T123SCH.SB_HISTOGRAM_INTERVALS
SIDU-R- TRAFODION.T123SCH.SB_PERSISTENT_SAMPLES
SIDU-R- TRAFODION.T123SCH.TEAMS
+=======================
+ 10 row(s) returned
+
--- SQL operation complete.
>>get privileges for role "PUBLIC";
@@ -430,6 +493,9 @@ S------ TRAFODION.T123SCH.PLAYERS <Column> PLAYER_TEAM_NUMBER
S------ TRAFODION.T123SCH.TEAMS <Column> TEAM_NAME
S------ TRAFODION.T123SCH.TEAMS <Column> TEAM_NUMBER
+=======================
+ 7 row(s) returned
+
--- SQL operation complete.
>>
>>get tables for user sql_user1;
@@ -441,6 +507,9 @@ TRAFODION."T123SCH".GAMES
TRAFODION."T123SCH".PLAYERS
TRAFODION."T123SCH".TEAMS
+=======================
+ 3 row(s) returned
+
--- SQL operation complete.
>>get tables for user sql_user2;
@@ -451,6 +520,9 @@ TRAFODION."T123SCH".GAMES
TRAFODION."T123SCH".PLAYERS
TRAFODION."T123SCH".TEAMS
+=======================
+ 3 row(s) returned
+
--- SQL operation complete.
>>get tables for user sql_user3;
@@ -460,6 +532,9 @@ Tables for User SQL_USER3
TRAFODION."T123SCH".PLAYERS
TRAFODION."T123SCH".TEAMS
+=======================
+ 2 row(s) returned
+
--- SQL operation complete.
>>get tables for user sql_user4;
@@ -470,6 +545,9 @@ TRAFODION."T123SCH".GAMES
TRAFODION."T123SCH".PLAYERS
TRAFODION."T123SCH".TEAMS
+=======================
+ 3 row(s) returned
+
--- SQL operation complete.
>>get tables for user sql_user5;
@@ -483,6 +561,9 @@ TRAFODION."T123SCH".SB_HISTOGRAM_INTERVALS
TRAFODION."T123SCH".SB_PERSISTENT_SAMPLES
TRAFODION."T123SCH".TEAMS
+=======================
+ 6 row(s) returned
+
--- SQL operation complete.
>>
>>get indexes for user sql_user1;
@@ -492,6 +573,9 @@ Indexes for User SQL_USER1
TRAFODION."T123SCH".GAMES_VISITOR
+=======================
+ 1 row(s) returned
+
--- SQL operation complete.
>>get indexes for user sql_user2;
@@ -500,6 +584,9 @@ Indexes for User SQL_USER2
TRAFODION."T123SCH".GAMES_VISITOR
+=======================
+ 1 row(s) returned
+
--- SQL operation complete.
>>get indexes for user sql_user3;
@@ -511,6 +598,9 @@ Indexes for User SQL_USER4
TRAFODION."T123SCH".GAMES_VISITOR
+=======================
+ 1 row(s) returned
+
--- SQL operation complete.
>>get indexes for user sql_user5;
@@ -519,6 +609,9 @@ Indexes for User SQL_USER5
TRAFODION."T123SCH".GAMES_VISITOR
+=======================
+ 1 row(s) returned
+
--- SQL operation complete.
>>
>>get views for user sql_user1;
@@ -542,6 +635,9 @@ TRAFODION."T123SCH".GAMES_BY_PLAYER
TRAFODION."T123SCH".HOME_TEAMS_GAMES
TRAFODION."T123SCH".PLAYERS_ON_TEAM
+=======================
+ 3 row(s) returned
+
--- SQL operation complete.
>>
>>get libraries for user sql_user1;
@@ -552,6 +648,9 @@ Libraries for User SQL_USER1
DB__LIBMGRNAME
DB__LIBMGR_LIB_CPP
+=======================
+ 2 row(s) returned
+
--- SQL operation complete.
>>get libraries for user sql_user2;
@@ -561,6 +660,9 @@ Libraries for User SQL_USER2
DB__LIBMGRNAME
DB__LIBMGR_LIB_CPP
+=======================
+ 2 row(s) returned
+
--- SQL operation complete.
>>get libraries for user sql_user3;
@@ -570,6 +672,9 @@ Libraries for User SQL_USER3
DB__LIBMGRNAME
DB__LIBMGR_LIB_CPP
+=======================
+ 2 row(s) returned
+
--- SQL operation complete.
>>get libraries for user sql_user4;
@@ -579,6 +684,9 @@ Libraries for User SQL_USER4
DB__LIBMGRNAME
DB__LIBMGR_LIB_CPP
+=======================
+ 2 row(s) returned
+
--- SQL operation complete.
>>get libraries for user sql_user5;
@@ -588,6 +696,9 @@ Libraries for User SQL_USER5
DB__LIBMGRNAME
DB__LIBMGR_LIB_CPP
+=======================
+ 2 row(s) returned
+
--- SQL operation complete.
>>
>>
@@ -611,6 +722,9 @@ Users
SQL_USER1
+=======================
+ 1 row(s) returned
+
--- SQL operation complete.
>>get roles;
@@ -621,6 +735,9 @@ PUBLIC
T123_ADMINROLE
T123_PLANNERROLE
+=======================
+ 3 row(s) returned
+
--- SQL operation complete.
>>get roles for user sql_user1;
@@ -631,6 +748,9 @@ PUBLIC
T123_ADMINROLE
T123_PLANNERROLE
+=======================
+ 3 row(s) returned
+
--- SQL operation complete.
>>get roles for user sql_user2;
@@ -639,6 +759,9 @@ Roles for User SQL_USER2
PUBLIC
+=======================
+ 1 row(s) returned
+
--- SQL operation complete.
>>get roles for user sql_user3;
@@ -647,6 +770,9 @@ Roles for User SQL_USER3
PUBLIC
+=======================
+ 1 row(s) returned
+
--- SQL operation complete.
>>get roles for user sql_user4;
@@ -655,6 +781,9 @@ Roles for User SQL_USER4
PUBLIC
+=======================
+ 1 row(s) returned
+
--- SQL operation complete.
>>get roles for user sql_user5;
@@ -663,6 +792,9 @@ Roles for User SQL_USER5
PUBLIC
+=======================
+ 1 row(s) returned
+
--- SQL operation complete.
>>
>>get users for role t123_adminrole;
@@ -672,6 +804,9 @@ Users granted Role T123_ADMINROLE
SQL_USER1
+=======================
+ 1 row(s) returned
+
--- SQL operation complete.
>>get users for role t123_plannerrole;
@@ -680,6 +815,9 @@ Users granted Role T123_PLANNERROLE
SQL_USER1
+=======================
+ 1 row(s) returned
+
--- SQL operation complete.
>>get users for role t123_dummyrole;
@@ -707,6 +845,9 @@ S------ TRAFODION.T123SCH.PLAYERS <Column> PLAYER_TEAM_NUMBER
S------ TRAFODION.T123SCH.TEAMS <Column> TEAM_NAME
S------ TRAFODION.T123SCH.TEAMS <Column> TEAM_NUMBER
+=======================
+ 13 row(s) returned
+
--- SQL operation complete.
>>get privileges for user sql_user2;
@@ -729,6 +870,9 @@ Privileges for Role T123_ADMINROLE
--DU--- TRAFODION.T123SCH.GAMES
--DU--- TRAFODION.T123SCH.TEAMS
+=======================
+ 2 row(s) returned
+
--- SQL operation complete.
>>get privileges for role t123_plannerrole;
@@ -739,6 +883,9 @@ Privileges for Role T123_PLANNERROLE
----G-- TRAFODION.T123SCH.PLAYERS_SEQUENCE
-I----- TRAFODION.T123SCH.TEAMS
+=======================
+ 3 row(s) returned
+
--- SQL operation complete.
>>get privileges for role t123_dummyrole;
@@ -759,6 +906,9 @@ S------ TRAFODION.T123SCH.PLAYERS <Column> PLAYER_TEAM_NUMBER
S------ TRAFODION.T123SCH.TEAMS <Column> TEAM_NAME
S------ TRAFODION.T123SCH.TEAMS <Column> TEAM_NUMBER
+=======================
+ 7 row(s) returned
+
--- SQL operation complete.
>>
>>get tables for user sql_user1;
@@ -770,6 +920,9 @@ TRAFODION."T123SCH".GAMES
TRAFODION."T123SCH".PLAYERS
TRAFODION."T123SCH".TEAMS
+=======================
+ 3 row(s) returned
+
--- SQL operation complete.
>>get tables for user sql_user2;
@@ -799,6 +952,9 @@ Indexes for User SQL_USER1
TRAFODION."T123SCH".GAMES_VISITOR
+=======================
+ 1 row(s) returned
+
--- SQL operation complete.
>>get indexes for user sql_user2;
@@ -853,6 +1009,9 @@ Libraries for User SQL_USER1
DB__LIBMGRNAME
DB__LIBMGR_LIB_CPP
+=======================
+ 2 row(s) returned
+
--- SQL operation complete.
>>get libraries for user sql_user2;
@@ -900,6 +1059,9 @@ Users
SQL_USER2
+=======================
+ 1 row(s) returned
+
--- SQL operation complete.
>>get roles;
@@ -909,6 +1071,9 @@ Roles
PUBLIC
T123_PLANNERROLE
+=======================
+ 2 row(s) returned
+
--- SQL operation complete.
>>get roles for user sql_user1;
@@ -917,6 +1082,9 @@ Roles for User SQL_USER1
PUBLIC
+=======================
+ 1 row(s) returned
+
--- SQL operation complete.
>>get roles for user sql_user2;
@@ -926,6 +1094,9 @@ Roles for User SQL_USER2
PUBLIC
T123_PLANNERROLE
+=======================
+ 2 row(s) returned
+
--- SQL operation complete.
>>get roles for user sql_user3;
@@ -934,6 +1105,9 @@ Roles for User SQL_USER3
PUBLIC
+=======================
+ 1 row(s) returned
+
--- SQL operation complete.
>>get roles for user sql_user4;
@@ -942,6 +1116,9 @@ Roles for User SQL_USER4
PUBLIC
+=======================
+ 1 row(s) returned
+
--- SQL operation complete.
>>get roles for user sql_user5;
@@ -950,6 +1127,9 @@ Roles for User SQL_USER5
PUBLIC
+=======================
+ 1 row(s) returned
+
--- SQL operation complete.
>>
>>get users for role t123_adminrole;
@@ -962,6 +1142,9 @@ Users granted Role T123_PLANNERROLE
SQL_USER2
+=======================
+ 1 row(s) returned
+
--- SQL operation complete.
>>get users for role t123_dummyrole;
@@ -989,6 +1172,9 @@ S------ TRAFODION.T123SCH.PLAYERS <Column> PLAYER_TEAM_NUMBER
S------ TRAFODION.T123SCH.TEAMS <Column> TEAM_NAME
S------ TRAFODION.T123SCH.TEAMS <Column> TEAM_NUMBER
+=======================
+ 10 row(s) returned
+
--- SQL operation complete.
>>get privileges for user sql_user3;
@@ -1012,6 +1198,9 @@ Privileges for Role T123_PLANNERROLE
----G-- TRAFODION.T123SCH.PLAYERS_SEQUENCE
-I----- TRAFODION.T123SCH.TEAMS
+=======================
+ 3 row(s) returned
+
--- SQL operation complete.
>>get privileges for role t123_dummyrole;
@@ -1032,6 +1221,9 @@ S------ TRAFODION.T123SCH.PLAYERS <Column> PLAYER_TEAM_NUMBER
S------ TRAFODION.T123SCH.TEAMS <Column> TEAM_NAME
S------ TRAFODION.T123SCH.TEAMS <Column> TEAM_NUMBER
+=======================
+ 7 row(s) returned
+
--- SQL operation complete.
>>
>>get tables for user sql_user1;
@@ -1048,6 +1240,9 @@ TRAFODION."T123SCH".GAMES
TRAFODION."T123SCH".PLAYERS
TRAFODION."T123SCH".TEAMS
+=======================
+ 3 row(s) returned
+
--- SQL operation complete.
>>get tables for user sql_user3;
@@ -1077,6 +1272,9 @@ Indexes for User SQL_USER2
TRAFODION."T123SCH".GAMES_VISITOR
+=======================
+ 1 row(s) returned
+
--- SQL operation complete.
>>get indexes for user sql_user3;
@@ -1131,6 +1329,9 @@ Libraries for User SQL_USER2
DB__LIBMGRNAME
DB__LIBMGR_LIB_CPP
+=======================
+ 2 row(s) returned
+
--- SQL operation complete.
>>get libraries for user sql_user3;
@@ -1173,6 +1374,9 @@ Users
SQL_USER3
+=======================
+ 1 row(s) returned
+
--- SQL operation complete.
>>get roles;
@@ -1181,6 +1385,9 @@ Roles
PUBLIC
+=======================
+ 1 row(s) returned
+
--- SQL operation complete.
>>get roles for user sql_user1;
@@ -1189,6 +1396,9 @@ Roles for User SQL_USER1
PUBLIC
+=======================
+ 1 row(s) returned
+
--- SQL operation complete.
>>get roles for user sql_user2;
@@ -1197,6 +1407,9 @@ Roles for User SQL_USER2
PUBLIC
+=======================
+ 1 row(s) returned
+
--- SQL operation complete.
>>get roles for user sql_user3;
@@ -1205,6 +1418,9 @@ Roles for User SQL_USER3
PUBLIC
+=======================
+ 1 row(s) returned
+
--- SQL operation complete.
>>get roles for user sql_user4;
@@ -1213,6 +1429,9 @@ Roles for User SQL_USER4
PUBLIC
+=======================
+ 1 row(s) returned
+
--- SQL operation complete.
>>get roles for user sql_user5;
@@ -1221,6 +1440,9 @@ Roles for User SQL_USER5
PUBLIC
+=======================
+ 1 row(s) returned
+
--- SQL operation complete.
>>
>>get users for role t123_adminrole;
@@ -1255,6 +1477,9 @@ S------ TRAFODION.T123SCH.PLAYERS <Column> PLAYER_TEAM_NUMBER
S------ TRAFODION.T123SCH.TEAMS <Column> TEAM_NAME
S------ TRAFODION.T123SCH.TEAMS <Column> TEAM_NUMBER
+=======================
+ 7 row(s) returned
+
--- SQL operation complete.
>>get privileges for user sql_user4;
@@ -1288,6 +1513,9 @@ S------ TRAFODION.T123SCH.PLAYERS <Column> PLAYER_TEAM_NUMBER
S------ TRAFODION.T123SCH.TEAMS <Column> TEAM_NAME
S------ TRAFODION.T123SCH.TEAMS <Column> TEAM_NUMBER
+=======================
+ 7 row(s) returned
+
--- SQL operation complete.
>>
>>get tables for user sql_user1;
@@ -1308,6 +1536,9 @@ Tables for User SQL_USER3
TRAFODION."T123SCH".PLAYERS
TRAFODION."T123SCH".TEAMS
+=======================
+ 2 row(s) returned
+
--- SQL operation complete.
>>get tables for user sql_user4;
@@ -1386,6 +1617,9 @@ Libraries for User SQL_USER3
DB__LIBMGRNAME
DB__LIBMGR_LIB_CPP
+=======================
+ 2 row(s) returned
+
--- SQL operation complete.
>>get libraries for user sql_user4;
@@ -1423,6 +1657,9 @@ Users
SQL_USER4
+=======================
+ 1 row(s) returned
+
--- SQL operation complete.
>>get roles;
@@ -1431,6 +1668,9 @@ Roles
PUBLIC
+=======================
+ 1 row(s) returned
+
--- SQL operation complete.
>>get roles for user sql_user1;
@@ -1439,6 +1679,9 @@ Roles for User SQL_USER1
PUBLIC
+=======================
+ 1 row(s) returned
+
--- SQL operation complete.
>>get roles for user sql_user2;
@@ -1447,6 +1690,9 @@ Roles for User SQL_USER2
PUBLIC
+=======================
+ 1 row(s) returned
+
--- SQL operation complete.
>>get roles for user sql_user3;
@@ -1455,6 +1701,9 @@ Roles for User SQL_USER3
PUBLIC
+=======================
+ 1 row(s) returned
+
--- SQL operation complete.
>>get roles for user sql_user4;
@@ -1463,6 +1712,9 @@ Roles for User SQL_USER4
PUBLIC
+=======================
+ 1 row(s) returned
+
--- SQL operation complete.
>>get roles for user sql_user5;
@@ -1471,6 +1723,9 @@ Roles for User SQL_USER5
PUBLIC
+=======================
+ 1 row(s) returned
+
--- SQL operation complete.
>>
>>get users for role t123_adminrole;
@@ -1510,6 +1765,9 @@ S------ TRAFODION.T123SCH.TEAMS
S------ TRAFODION.T123SCH.TEAMS <Column> TEAM_NAME
S------ TRAFODION.T123SCH.TEAMS <Column> TEAM_NUMBER
+=======================
+ 9 row(s) returned
+
--- SQL operation complete.
>>get privileges for user sql_user5;
@@ -1540,6 +1798,9 @@ S------ TRAFODION.T123SCH.PLAYERS <Column> PLAYER_TEAM_NUMBER
S------ TRAFODION.T123SCH.TEAMS <Column> TEAM_NAME
S------ TRAFODION.T123SCH.TEAMS <Column> TEAM_NUMBER
+=======================
+ 7 row(s) returned
+
--- SQL operation complete.
>>
>>get tables for user sql_user1;
@@ -1566,6 +1827,9 @@ TRAFODION."T123SCH".GAMES
TRAFODION."T123SCH".PLAYERS
TRAFODION."T123SCH".TEAMS
+=======================
+ 3 row(s) returned
+
--- SQL operation complete.
>>get tables for user sql_user5;
@@ -1595,6 +1859,9 @@ Indexes for User SQL_USER4
TRAFODION."T123SCH".GAMES_VISITOR
+=======================
+ 1 row(s) returned
+
--- SQL operation complete.
>>get indexes for user sql_user5;
@@ -1649,6 +1916,9 @@ Libraries for User SQL_USER4
DB__LIBMGRNAME
DB__LIBMGR_LIB_CPP
+=======================
+ 2 row(s) returned
+
--- SQL operation complete.
>>get libraries for user sql_user5;
@@ -1681,6 +1951,9 @@ Users
SQL_USER5
+=======================
+ 1 row(s) returned
+
--- SQL operation complete.
>>get roles;
@@ -1690,6 +1963,9 @@ Roles
PUBLIC
T123_OWNERROLE
+=======================
+ 2 row(s) returned
+
--- SQL operation complete.
>>get roles for user sql_user1;
@@ -1698,6 +1974,9 @@ Roles for User SQL_USER1
PUBLIC
+=======================
+ 1 row(s) returned
+
--- SQL operation complete.
>>get roles for user sql_user2;
@@ -1706,6 +1985,9 @@ Roles for User SQL_USER2
PUBLIC
+=======================
+ 1 row(s) returned
+
--- SQL operation complete.
>>get roles for user sql_user3;
@@ -1714,6 +1996,9 @@ Roles for User SQL_USER3
PUBLIC
+=======================
+ 1 row(s) returned
+
--- SQL operation complete.
>>get roles for user sql_user4;
@@ -1722,6 +2007,9 @@ Roles for User SQL_USER4
PUBLIC
+=======================
+ 1 row(s) returned
+
--- SQL operation complete.
>>get roles for user sql_user5;
@@ -1731,6 +2019,9 @@ Roles for User SQL_USER5
PUBLIC
T123_OWNERROLE
+=======================
+ 2 row(s) returned
+
--- SQL operation complete.
>>
>>get users for role t123_adminrole;
@@ -1749,6 +2040,9 @@ Users granted Role T123_OWNERROLE
SQL_USER5
+=======================
+ 1 row(s) returned
+
--- SQL operation complete.
>>
>>get privileges for user sql_user1;
@@ -1786,6 +2080,9 @@ SIDU-R- TRAFODION.T123SCH.TEAMS
S------ TRAFODION.T123SCH.TEAMS <Column> TEAM_NAME
S------ TRAFODION.T123SCH.TEAMS <Column> TEAM_NUMBER
+=======================
+ 17 row(s) returned
+
--- SQL operation complete.
>>
>>get privileges for role t123_adminrole;
@@ -1813,6 +2110,9 @@ SIDU-R- TRAFODION.T123SCH.SB_HISTOGRAM_INTERVALS
SIDU-R- TRAFODION.T123SCH.SB_PERSISTENT_SAMPLES
SIDU-R- TRAFODION.T123SCH.TEAMS
+=======================
+ 10 row(s) returned
+
--- SQL operation complete.
>>get privileges for role "PUBLIC";
@@ -1827,6 +2127,9 @@ S------ TRAFODION.T123SCH.PLAYERS <Column> PLAYER_TEAM_NUMBER
S------ TRAFODION.T123SCH.TEAMS <Column> TEAM_NAME
S------ TRAFODION.T123SCH.TEAMS <Column> TEAM_NUMBER
+=======================
+ 7 row(s) returned
+
--- SQL operation complete.
>>
>>get tables for user sql_user1;
@@ -1861,6 +2164,9 @@ TRAFODION."T123SCH".SB_HISTOGRAM_INTERVALS
TRAFODION."T123SCH".SB_PERSISTENT_SAMPLES
TRAFODION."T123SCH".TEAMS
+=======================
+ 6 row(s) returned
+
--- SQL operation complete.
>>
>>get indexes for user sql_user1;
@@ -1890,6 +2196,9 @@ Indexes for User SQL_USER5
TRAFODION."T123SCH".GAMES_VISITOR
+=======================
+ 1 row(s) returned
+
--- SQL operation complete.
>>
>>get views for user sql_user1;
@@ -1921,6 +2230,9 @@ TRAFODION."T123SCH".GAMES_BY_PLAYER
TRAFODION."T123SCH".HOME_TEAMS_GAMES
TRAFODION."T123SCH".PLAYERS_ON_TEAM
+=======================
+ 3 row(s) returned
+
--- SQL operation complete.
>>
>>get libraries for user sql_user1;
@@ -1951,6 +2263,9 @@ Libraries for User SQL_USER5
DB__LIBMGRNAME
DB__LIBMGR_LIB_CPP
+=======================
+ 2 row(s) returned
+
--- SQL operation complete.
>>
>>
@@ -1982,6 +2297,9 @@ Roles for User UNKNOWN_USER
PUBLIC
+=======================
+ 1 row(s) returned
+
--- SQL operation complete.
>>get users for role unknown_role;
http://git-wip-us.apache.org/repos/asf/trafodion/blob/00e9d5b5/core/sql/regress/privs1/EXPECTED125
----------------------------------------------------------------------
diff --git a/core/sql/regress/privs1/EXPECTED125 b/core/sql/regress/privs1/EXPECTED125
index d464042..47a5921 100644
--- a/core/sql/regress/privs1/EXPECTED125
+++ b/core/sql/regress/privs1/EXPECTED125
@@ -497,6 +497,9 @@ SIDU-R- TRAFODION.T125SCH3.PLAYERS
----G-- TRAFODION.T125SCH3.T125_L1
------E TRAFODION.T125SCH3.TRANSLATEBITMAP
+=======================
+ 7 row(s) returned
+
--- SQL operation complete.
>>get privileges for user sql_user1;
@@ -511,6 +514,9 @@ Privileges for User SQL_USER1
S------ TRAFODION.T125SCH3.GAMES_BY_PLAYER
S------ TRAFODION.T125SCH3.GAMES_BY_PLAYER <Column> PLAYER_NAME
+=======================
+ 7 row(s) returned
+
--- SQL operation complete.
>>get privileges for user sql_user2;
@@ -533,6 +539,9 @@ SIDU-R- TRAFODION.T125SCH3.PLAYERS
----G-- TRAFODION.T125SCH3.T125_L1
------E TRAFODION.T125SCH3.TRANSLATEBITMAP
+=======================
+ 15 row(s) returned
+
--- SQL operation complete.
>>get privileges for user sql_user7;
@@ -549,6 +558,9 @@ SIDU-R- TRAFODION.T125SCH3.PLAYERS
----G-- TRAFODION.T125SCH3.T125_L1
------E TRAFODION.T125SCH3.TRANSLATEBITMAP
+=======================
+ 9 row(s) returned
+
--- SQL operation complete.
>>get privileges for user sql_user8;
@@ -574,6 +586,9 @@ SIDU-R- TRAFODION.T125SCH3.TEAMS
------E TRAFODION.T125SCH3.TESTHIVE
------E TRAFODION.T125SCH3.TRANSLATEBITMAP
+=======================
+ 18 row(s) returned
+
--- SQL operation complete.
>>
>>set schema t125sch1;
@@ -588,6 +603,9 @@ Privileges on Table T125SCH1.GAMES
SIDU-R- DB__ROOT
SIDU-R- SQL_USER2
+=======================
+ 2 row(s) returned
+
--- SQL operation complete.
>>get privileges on table games for sql_user1;
@@ -599,6 +617,9 @@ Privileges on Table T125SCH1.GAMES
SIDU-R- SQL_USER2
+=======================
+ 1 row(s) returned
+
--- SQL operation complete.
>>get privileges on table games for sql_user7;
@@ -620,6 +641,9 @@ Privileges on View T125SCH1.GAMES_BY_PLAYER
S----R- DB__ROOT
S------ SQL_USER2
+=======================
+ 2 row(s) returned
+
--- SQL operation complete.
>>get privileges on view games_by_player for sql_user1;
@@ -631,6 +655,9 @@ Privileges on View T125SCH1.GAMES_BY_PLAYER
S------ SQL_USER2
+=======================
+ 1 row(s) returned
+
--- SQL operation complete.
>>get privileges on view games_by_player for sql_user7;
@@ -652,6 +679,9 @@ Privileges on Sequence T125SCH1.T125_L1
---UG-- DB__ROOT
----G-- T125_ROLE1
+=======================
+ 2 row(s) returned
+
--- SQL operation complete.
>>get privileges on library t125_l1 for sql_user1;
@@ -663,6 +693,9 @@ Privileges on Sequence T125SCH1.T125_L1
----G-- T125_ROLE1
+=======================
+ 1 row(s) returned
+
--- SQL operation complete.
>>get privileges on library t125_l1 for sql_user7;
@@ -671,6 +704,9 @@ Privileges on Sequence T125SCH1.T125_L1
----G-- T125_ROLE1
+=======================
+ 1 row(s) returned
+
--- SQL operation complete.
>>get privileges on library t125_l1 for sql_user8;
@@ -682,6 +718,9 @@ Privileges on Sequence T125SCH1.T125_L1
----G-- T125_ROLE1
+=======================
+ 1 row(s) returned
+
--- SQL operation complete.
>>get privileges on library t125_l1 for t125_adminrole;
@@ -693,6 +732,9 @@ Privileges on Sequence T125SCH1.PLAYERS_SEQUENCE
----G-- DB__ROOT
+=======================
+ 1 row(s) returned
+
--- SQL operation complete.
>>get privileges on sequence players_sequence for sql_user1;
@@ -726,6 +768,9 @@ SIDU-R- DB__ROOT
SIDU-R- SQL_USER2
S------ T125_ROLE1
+=======================
+ 3 row(s) returned
+
--- SQL operation complete.
>>get privileges on table games for sql_user1;
@@ -738,6 +783,9 @@ Privileges on Table T125SCH2.GAMES
SIDU-R- SQL_USER2
S------ T125_ROLE1
+=======================
+ 2 row(s) returned
+
--- SQL operation complete.
>>get privileges on table games for sql_user7;
@@ -746,6 +794,9 @@ Privileges on Table T125SCH2.GAMES
S------ T125_ROLE1
+=======================
+ 1 row(s) returned
+
--- SQL operation complete.
>>get privileges on table games for sql_user8;
@@ -757,6 +808,9 @@ Privileges on Table T125SCH2.GAMES
S------ T125_ROLE1
+=======================
+ 1 row(s) returned
+
--- SQL operation complete.
>>get privileges on table games for t125_adminrole;
@@ -769,6 +823,9 @@ Privileges on View T125SCH2.GAMES_BY_PLAYER
S----R- DB__ROOT
S------ SQL_USER2
+=======================
+ 2 row(s) returned
+
--- SQL operation complete.
>>get privileges on view games_by_player for sql_user1;
@@ -780,6 +837,9 @@ Privileges on View T125SCH2.GAMES_BY_PLAYER
S------ SQL_USER2
+=======================
+ 1 row(s) returned
+
--- SQL operation complete.
>>get privileges on view games_by_player for sql_user7;
@@ -801,6 +861,9 @@ Privileges on Sequence T125SCH2.T125_L1
---UG-- DB__ROOT
----G-- T125_ROLE1
+=======================
+ 2 row(s) returned
+
--- SQL operation complete.
>>get privileges on library t125_l1 for sql_user1;
@@ -812,6 +875,9 @@ Privileges on Sequence T125SCH2.T125_L1
----G-- T125_ROLE1
+=======================
+ 1 row(s) returned
+
--- SQL operation complete.
>>get privileges on library t125_l1 for sql_user7;
@@ -820,6 +886,9 @@ Privileges on Sequence T125SCH2.T125_L1
----G-- T125_ROLE1
+=======================
+ 1 row(s) returned
+
--- SQL operation complete.
>>get privileges on library t125_l1 for sql_user8;
@@ -831,6 +900,9 @@ Privileges on Sequence T125SCH2.T125_L1
----G-- T125_ROLE1
+=======================
+ 1 row(s) returned
+
--- SQL operation complete.
>>get privileges on library t125_l1 for t125_adminrole;
@@ -843,6 +915,9 @@ Privileges on Sequence T125SCH2.PLAYERS_SEQUENCE
----G-- DB__ROOT
----G-- SQL_USER1
+=======================
+ 2 row(s) returned
+
--- SQL operation complete.
>>get privileges on sequence players_sequence for sql_user1;
@@ -851,6 +926,9 @@ Privileges on Sequence T125SCH2.PLAYERS_SEQUENCE
----G-- SQL_USER1
+=======================
+ 1 row(s) returned
+
--- SQL operation complete.
>>get privileges on sequence players_sequence for sql_user2;
@@ -881,6 +959,9 @@ Privileges on Table T125SCH3.GAMES
SIDU-R- SQL_USER2
SIDU-R- T125_ADMINROLE
+=======================
+ 3 row(s) returned
+
--- SQL operation complete.
>>get privileges on table games for sql_user1;
@@ -889,6 +970,9 @@ Privileges on Table T125SCH3.GAMES
-I----- SQL_USER1
+=======================
+ 1 row(s) returned
+
--- SQL operation complete.
>>get privileges on table games for sql_user2;
@@ -897,6 +981,9 @@ Privileges on Table T125SCH3.GAMES
SIDU-R- SQL_USER2
+=======================
+ 1 row(s) returned
+
--- SQL operation complete.
>>get privileges on table games for sql_user7;
@@ -908,6 +995,9 @@ Privileges on Table T125SCH3.GAMES
SIDU-R- T125_ADMINROLE
+=======================
+ 1 row(s) returned
+
--- SQL operation complete.
>>get privileges on table games for t125_role1;
@@ -919,6 +1009,9 @@ Privileges on Table T125SCH3.GAMES
SIDU-R- T125_ADMINROLE
+=======================
+ 1 row(s) returned
+
--- SQL operation complete.
>>get privileges on view games_by_player;
@@ -929,6 +1022,9 @@ S------ SQL_USER1
S------ SQL_USER2
S----R- T125_ADMINROLE
+=======================
+ 3 row(s) returned
+
--- SQL operation complete.
>>get privileges on view games_by_player for sql_user1;
@@ -937,6 +1033,9 @@ Privileges on View T125SCH3.GAMES_BY_PLAYER
S------ SQL_USER1
+=======================
+ 1 row(s) returned
+
--- SQL operation complete.
>>get privileges on view games_by_player for sql_user2;
@@ -945,6 +1044,9 @@ Privileges on View T125SCH3.GAMES_BY_PLAYER
S------ SQL_USER2
+=======================
+ 1 row(s) returned
+
--- SQL operation complete.
>>get privileges on view games_by_player for sql_user7;
@@ -956,6 +1058,9 @@ Privileges on View T125SCH3.GAMES_BY_PLAYER
S----R- T125_ADMINROLE
+=======================
+ 1 row(s) returned
+
--- SQL operation complete.
>>get privileges on view games_by_player for t125_role1;
@@ -967,6 +1072,9 @@ Privileges on View T125SCH3.GAMES_BY_PLAYER
S----R- T125_ADMINROLE
+=======================
+ 1 row(s) returned
+
--- SQL operation complete.
>>get privileges on library t125_l1;
@@ -976,6 +1084,9 @@ Privileges on Sequence T125SCH3.T125_L1
---UG-- T125_ADMINROLE
----G-- T125_ROLE1
+=======================
+ 2 row(s) returned
+
--- SQL operation complete.
>>get privileges on library t125_l1 for sql_user1;
@@ -987,6 +1098,9 @@ Privileges on Sequence T125SCH3.T125_L1
----G-- T125_ROLE1
+=======================
+ 1 row(s) returned
+
--- SQL operation complete.
>>get privileges on library t125_l1 for sql_user7;
@@ -995,6 +1109,9 @@ Privileges on Sequence T125SCH3.T125_L1
----G-- T125_ROLE1
+=======================
+ 1 row(s) returned
+
--- SQL operation complete.
>>get privileges on library t125_l1 for sql_user8;
@@ -1003,6 +1120,9 @@ Privileges on Sequence T125SCH3.T125_L1
---UG-- T125_ADMINROLE
+=======================
+ 1 row(s) returned
+
--- SQL operation complete.
>>get privileges on library t125_l1 for t125_role1;
@@ -1011,6 +1131,9 @@ Privileges on Sequence T125SCH3.T125_L1
----G-- T125_ROLE1
+=======================
+ 1 row(s) returned
+
--- SQL operation complete.
>>get privileges on library t125_l1 for t125_adminrole;
@@ -1019,6 +1142,9 @@ Privileges on Sequence T125SCH3.T125_L1
---UG-- T125_ADMINROLE
+=======================
+ 1 row(s) returned
+
--- SQL operation complete.
>>get privileges on sequence players_sequence;
@@ -1027,6 +1153,9 @@ Privileges on Sequence T125SCH3.PLAYERS_SEQUENCE
----G-- T125_ADMINROLE
+=======================
+ 1 row(s) returned
+
--- SQL operation complete.
>>get privileges on sequence players_sequence for sql_user1;
@@ -1044,6 +1173,9 @@ Privileges on Sequence T125SCH3.PLAYERS_SEQUENCE
----G-- T125_ADMINROLE
+=======================
+ 1 row(s) returned
+
--- SQL operation complete.
>>get privileges on sequence players_sequence for t125_role1;
@@ -1055,6 +1187,9 @@ Privileges on Sequence T125SCH3.PLAYERS_SEQUENCE
----G-- T125_ADMINROLE
+=======================
+ 1 row(s) returned
+
--- SQL operation complete.
>>
>>
@@ -1081,6 +1216,9 @@ T125SCH1
T125SCH2
T125SCH3
+=======================
+ 3 row(s) returned
+
--- SQL operation complete.
>>
>>set schema t125sch1;
@@ -1098,6 +1236,9 @@ SB_HISTOGRAM_INTERVALS
SB_PERSISTENT_SAMPLES
TEAMS
+=======================
+ 6 row(s) returned
+
--- SQL operation complete.
>>get views;
@@ -1108,6 +1249,9 @@ GAMES_BY_PLAYER
HOME_TEAMS_GAMES
PLAYERS_ON_TEAM
+=======================
+ 3 row(s) returned
+
--- SQL operation complete.
>>get indexes;
@@ -1116,6 +1260,9 @@ Indexes in Schema TRAFODION.T125SCH1
PLAYERS_TEAMS
+=======================
+ 1 row(s) returned
+
--- SQL operation complete.
>>get sequences, match 'T125SCH%';
@@ -1126,6 +1273,9 @@ T125SCH1.PLAYERS_SEQUENCE
T125SCH2.PLAYERS_SEQUENCE
T125SCH3.PLAYERS_SEQUENCE
+=======================
+ 3 row(s) returned
+
--- SQL operation complete.
>>get libraries, match 'T125%';
@@ -1135,6 +1285,9 @@ Libraries in Schema TRAFODION.T125SCH1
T125_L1
T125_L2
+=======================
+ 2 row(s) returned
+
--- SQL operation complete.
>>get functions;
@@ -1143,6 +1296,9 @@ Functions in Schema TRAFODION.T125SCH1
TRANSLATEBITMAP
+=======================
+ 1 row(s) returned
+
--- SQL operation complete.
>>get procedures;
@@ -1151,6 +1307,9 @@ Procedures in Schema TRAFODION.T125SCH1
TESTHIVE
+=======================
+ 1 row(s) returned
+
--- SQL operation complete.
>>
>>get indexes on table players;
@@ -1160,6 +1319,9 @@ Indexes on Table T125SCH1.PLAYERS
PLAYERS_TEAMS
+=======================
+ 1 row(s) returned
+
--- SQL operation complete.
>>get views on table players;
@@ -1168,6 +1330,9 @@ Views on Table T125SCH1.PLAYERS
TRAFODION.T125SCH1.PLAYERS_ON_TEAM
+=======================
+ 1 row(s) returned
+
--- SQL operation complete.
>>get views on view players_on_team;
@@ -1176,6 +1341,9 @@ Views ON View T125SCH1.PLAYERS_ON_TEAM
TRAFODION.T125SCH1.GAMES_BY_PLAYER
+=======================
+ 1 row(s) returned
+
--- SQL operation complete.
>>
>>get tables in view games_by_player;
@@ -1186,6 +1354,9 @@ Tables in View T125SCH1.GAMES_BY_PLAYER
TRAFODION.T125SCH1.GAMES
TRAFODION.T125SCH1.TEAMS
+=======================
+ 2 row(s) returned
+
--- SQL operation complete.
>>get views in view games_by_player;
@@ -1194,6 +1365,9 @@ Views in View T125SCH1.GAMES_BY_PLAYER
TRAFODION.T125SCH1.PLAYERS_ON_TEAM
+=======================
+ 1 row(s) returned
+
--- SQL operation complete.
>>get objects in view games_by_player;
@@ -1204,6 +1378,9 @@ TRAFODION.T125SCH1.GAMES
TRAFODION.T125SCH1.PLAYERS_ON_TEAM
TRAFODION.T125SCH1.TEAMS
+=======================
+ 3 row(s) returned
+
--- SQL operation complete.
>>
>>set schema t125sch2;
@@ -1221,6 +1398,9 @@ SB_HISTOGRAM_INTERVALS
SB_PERSISTENT_SAMPLES
TEAMS
+=======================
+ 6 row(s) returned
+
--- SQL operation complete.
>>get views in schema t125sch2;
@@ -1231,6 +1411,9 @@ GAMES_BY_PLAYER
HOME_TEAMS_GAMES
PLAYERS_ON_TEAM
+=======================
+ 3 row(s) returned
+
--- SQL operation complete.
>>get indexes in schema t125sch2;
@@ -1239,6 +1422,9 @@ Indexes in Schema TRAFODION.T125SCH2
PLAYERS_TEAMS
+=======================
+ 1 row(s) returned
+
--- SQL operation complete.
>>get sequences in schema t125sch2;
@@ -1247,6 +1433,9 @@ Sequences in schema TRAFODION.T125SCH2
PLAYERS_SEQUENCE
+=======================
+ 1 row(s) returned
+
--- SQL operation complete.
>>get libraries in schema t125sch2;
@@ -1256,6 +1445,9 @@ Libraries in Schema TRAFODION.T125SCH2
T125_L1
T125_L2
+=======================
+ 2 row(s) returned
+
--- SQL operation complete.
>>get functions in schema t125sch2;
@@ -1264,6 +1456,9 @@ Functions in Schema TRAFODION.T125SCH2
TRANSLATEBITMAP
+=======================
+ 1 row(s) returned
+
--- SQL operation complete.
>>get procedures in schema t125sch2;
@@ -1272,6 +1467,9 @@ Procedures in Schema TRAFODION.T125SCH2
TESTHIVE
+=======================
+ 1 row(s) returned
+
--- SQL operation complete.
>>
>>set schema t125sch3;
@@ -1289,6 +1487,9 @@ SB_HISTOGRAM_INTERVALS
SB_PERSISTENT_SAMPLES
TEAMS
+=======================
+ 6 row(s) returned
+
--- SQL operation complete.
>>get privileges on table games;
@@ -1299,6 +1500,9 @@ Privileges on Table T125SCH3.GAMES
SIDU-R- SQL_USER2
SIDU-R- T125_ADMINROLE
+=======================
+ 3 row(s) returned
+
--- SQL operation complete.
>>get privileges on table games for t125_role1;
@@ -1318,6 +1522,9 @@ T125SCH3.GAMES_BY_PLAYER
T125SCH3.HOME_TEAMS_GAMES
T125SCH3.PLAYERS_ON_TEAM
+=======================
+ 9 row(s) returned
+
--- SQL operation complete.
>>get privileges on view games_by_player;
@@ -1328,6 +1535,9 @@ S------ SQL_USER1
S------ SQL_USER2
S----R- T125_ADMINROLE
+=======================
+ 3 row(s) returned
+
--- SQL operation complete.
>>get privileges on view games_by_player for user sql_user8;
@@ -1336,6 +1546,9 @@ Privileges on View T125SCH3.GAMES_BY_PLAYER
S----R- T125_ADMINROLE
+=======================
+ 1 row(s) returned
+
--- SQL operation complete.
>>get indexes in schema t125sch3;
@@ -1344,6 +1557,9 @@ Indexes in Schema TRAFODION.T125SCH3
PLAYERS_TEAMS
+=======================
+ 1 row(s) returned
+
--- SQL operation complete.
>>get sequences in catalog trafodion, match 'T125SCH%';
@@ -1354,6 +1570,9 @@ T125SCH1.PLAYERS_SEQUENCE
T125SCH2.PLAYERS_SEQUENCE
T125SCH3.PLAYERS_SEQUENCE
+=======================
+ 3 row(s) returned
+
--- SQL operation complete.
>>get privileges on sequence players_sequence;
@@ -1362,6 +1581,9 @@ Privileges on Sequence T125SCH3.PLAYERS_SEQUENCE
----G-- T125_ADMINROLE
+=======================
+ 1 row(s) returned
+
--- SQL operation complete.
>>get privileges on sequence players_sequence for t125_role1;
@@ -1374,6 +1596,9 @@ Libraries in Schema TRAFODION.T125SCH3
T125_L1
T125_L2
+=======================
+ 2 row(s) returned
+
--- SQL operation complete.
>>get privileges on library t125_l1;
@@ -1383,6 +1608,9 @@ Privileges on Sequence T125SCH3.T125_L1
---UG-- T125_ADMINROLE
----G-- T125_ROLE1
+=======================
+ 2 row(s) returned
+
--- SQL operation complete.
>>get privileges on library t125_l1 for user sql_user8;
@@ -1391,6 +1619,9 @@ Privileges on Sequence T125SCH3.T125_L1
---UG-- T125_ADMINROLE
+=======================
+ 1 row(s) returned
+
--- SQL operation complete.
>>get functions in schema t125sch3;
@@ -1399,6 +1630,9 @@ Functions in Schema TRAFODION.T125SCH3
TRANSLATEBITMAP
+=======================
+ 1 row(s) returned
+
--- SQL operation complete.
>>get procedures;
@@ -1407,6 +1641,9 @@ Procedures in Schema TRAFODION.T125SCH3
TESTHIVE
+=======================
+ 1 row(s) returned
+
--- SQL operation complete.
>>
>>get functions for library t125_l1;
@@ -1416,6 +1653,9 @@ Functions for Library T125SCH3.T125_L1
T125SCH3.TRANSLATEBITMAP
+=======================
+ 1 row(s) returned
+
--- SQL operation complete.
>>get procedures for library t125_l2;
@@ -1424,6 +1664,9 @@ Procedures for Library T125SCH3.T125_L2
T125SCH3.TESTHIVE
+=======================
+ 1 row(s) returned
+
--- SQL operation complete.
>>
>>
@@ -1454,6 +1697,9 @@ T125SCH1
T125SCH2
T125SCH3
+=======================
+ 3 row(s) returned
+
--- SQL operation complete.
>>
>>set schema t125sch1;
@@ -1475,6 +1721,9 @@ Sequences in catalog TRAFODION
T125SCH3.PLAYERS_SEQUENCE
+=======================
+ 1 row(s) returned
+
--- SQL operation complete.
>>get libraries, match 'T125%';
@@ -1546,6 +1795,9 @@ SB_HISTOGRAM_INTERVALS
SB_PERSISTENT_SAMPLES
TEAMS
+=======================
+ 6 row(s) returned
+
--- SQL operation complete.
>>get privileges on table games;
@@ -1554,6 +1806,9 @@ Privileges on Table T125SCH3.GAMES
SIDU-R- T125_ADMINROLE
+=======================
+ 1 row(s) returned
+
--- SQL operation complete.
>>get privileges on table games for t125_role1;
@@ -1567,6 +1822,9 @@ T125SCH3.GAMES_BY_PLAYER
T125SCH3.HOME_TEAMS_GAMES
T125SCH3.PLAYERS_ON_TEAM
+=======================
+ 3 row(s) returned
+
--- SQL operation complete.
>>get privileges on view games_by_player;
@@ -1575,6 +1833,9 @@ Privileges on View T125SCH3.GAMES_BY_PLAYER
S----R- T125_ADMINROLE
+=======================
+ 1 row(s) returned
+
--- SQL operation complete.
>>get privileges on view games_by_player for user sql_user8;
@@ -1583,6 +1844,9 @@ Privileges on View T125SCH3.GAMES_BY_PLAYER
S----R- T125_ADMINROLE
+=======================
+ 1 row(s) returned
+
--- SQL operation complete.
>>get indexes in schema t125sch3;
@@ -1594,6 +1858,9 @@ Sequences in catalog TRAFODION
T125SCH3.PLAYERS_SEQUENCE
+=======================
+ 1 row(s) returned
+
--- SQL operation complete.
>>get privileges on sequence players_sequence;
@@ -1602,6 +1869,9 @@ Privileges on Sequence T125SCH3.PLAYERS_SEQUENCE
----G-- T125_ADMINROLE
+=======================
+ 1 row(s) returned
+
--- SQL operation complete.
>>get privileges on sequence players_sequence for t125_role1;
@@ -1614,6 +1884,9 @@ Libraries in Schema TRAFODION.T125SCH3
T125_L1
T125_L2
+=======================
+ 2 row(s) returned
+
--- SQL operation complete.
>>get privileges on library t125_l1;
@@ -1622,6 +1895,9 @@ Privileges on Sequence T125SCH3.T125_L1
---UG-- T125_ADMINROLE
+=======================
+ 1 row(s) returned
+
--- SQL operation complete.
>>get privileges on library t125_l1 for user sql_user8;
@@ -1630,6 +1906,9 @@ Privileges on Sequence T125SCH3.T125_L1
---UG-- T125_ADMINROLE
+=======================
+ 1 row(s) returned
+
--- SQL operation complete.
>>get functions in schema t125sch3;
@@ -1638,6 +1917,9 @@ Functions in Schema TRAFODION.T125SCH3
TRANSLATEBITMAP
+=======================
+ 1 row(s) returned
+
--- SQL operation complete.
>>get procedures;
@@ -1646,6 +1928,9 @@ Procedures in Schema TRAFODION.T125SCH3
TESTHIVE
+=======================
+ 1 row(s) returned
+
--- SQL operation complete.
>>
>>get functions for library t125_l1;
@@ -1655,6 +1940,9 @@ Functions for Library T125SCH3.T125_L1
T125SCH3.TRANSLATEBITMAP
+=======================
+ 1 row(s) returned
+
--- SQL operation complete.
>>get procedures for library t125_l2;
@@ -1663,6 +1951,9 @@ Procedures for Library T125SCH3.T125_L2
T125SCH3.TESTHIVE
+=======================
+ 1 row(s) returned
+
--- SQL operation complete.
>>
>>
@@ -1692,6 +1983,9 @@ Schemas in Catalog TRAFODION
T125SCH2
T125SCH3
+=======================
+ 2 row(s) returned
+
--- SQL operation complete.
>>
>>set schema t125sch1;
@@ -1713,6 +2007,9 @@ Sequences in catalog TRAFODION
T125SCH2.PLAYERS_SEQUENCE
+=======================
+ 1 row(s) returned
+
--- SQL operation complete.
>>get libraries, match 'T125%';
@@ -1763,6 +2060,9 @@ Sequences in schema TRAFODION.T125SCH2
PLAYERS_SEQUENCE
+=======================
+ 1 row(s) returned
+
--- SQL operation complete.
>>get libraries in schema t125sch2;
@@ -1771,6 +2071,9 @@ Libraries in Schema TRAFODION.T125SCH2
T125_L2
+=======================
+ 1 row(s) returned
+
--- SQL operation complete.
>>get functions in schema t125sch2;
@@ -1782,6 +2085,9 @@ Procedures in Schema TRAFODION.T125SCH2
TESTHIVE
+=======================
+ 1 row(s) returned
+
--- SQL operation complete.
>>
>>set schema t125sch3;
@@ -1794,6 +2100,9 @@ Tables in Schema TRAFODION.T125SCH3
GAMES
+=======================
+ 1 row(s) returned
+
--- SQL operation complete.
>>get privileges on table games;
@@ -1802,6 +2111,9 @@ Privileges on Table T125SCH3.GAMES
-I----- SQL_USER1
+=======================
+ 1 row(s) returned
+
--- SQL operation complete.
>>get privileges on table games for t125_role1;
@@ -1813,6 +2125,9 @@ Views in Catalog TRAFODION
T125SCH3.GAMES_BY_PLAYER
+=======================
+ 1 row(s) returned
+
--- SQL operation complete.
>>get privileges on view games_by_player;
@@ -1821,6 +2136,9 @@ Privileges on View T125SCH3.GAMES_BY_PLAYER
S------ SQL_USER1
+=======================
+ 1 row(s) returned
+
--- SQL operation complete.
>>get privileges on view games_by_player for user sql_user8;
@@ -1835,6 +2153,9 @@ Sequences in catalog TRAFODION
T125SCH2.PLAYERS_SEQUENCE
+=======================
+ 1 row(s) returned
+
--- SQL operation complete.
>>get privileges on sequence players_sequence;
@@ -1893,6 +2214,9 @@ T125SCH1
T125SCH2
T125SCH3
+=======================
+ 3 row(s) returned
+
--- SQL operation complete.
>>
>>set schema t125sch1;
@@ -1905,6 +2229,9 @@ Tables in Schema TRAFODION.T125SCH1
GAMES
+=======================
+ 1 row(s) returned
+
--- SQL operation complete.
>>get views;
@@ -1913,6 +2240,9 @@ Views in Schema TRAFODION.T125SCH1
GAMES_BY_PLAYER
+=======================
+ 1 row(s) returned
+
--- SQL operation complete.
>>get indexes;
@@ -1948,6 +2278,9 @@ Tables in View T125SCH1.GAMES_BY_PLAYER
TRAFODION.T125SCH1.GAMES
TRAFODION.T125SCH1.TEAMS
+=======================
+ 2 row(s) returned
+
--- SQL operation complete.
>>get views in view games_by_player;
@@ -1956,6 +2289,9 @@ Views in View T125SCH1.GAMES_BY_PLAYER
TRAFODION.T125SCH1.PLAYERS_ON_TEAM
+=======================
+ 1 row(s) returned
+
--- SQL operation complete.
>>get objects in view games_by_player;
@@ -1966,6 +2302,9 @@ TRAFODION.T125SCH1.GAMES
TRAFODION.T125SCH1.PLAYERS_ON_TEAM
TRAFODION.T125SCH1.TEAMS
+=======================
+ 3 row(s) returned
+
--- SQL operation complete.
>>
>>set schema t125sch2;
@@ -1979,6 +2318,9 @@ Tables in Schema TRAFODION.T125SCH2
GAMES
TEAMS
+=======================
+ 2 row(s) returned
+
--- SQL operation complete.
>>get views in schema t125sch2;
@@ -1987,6 +2329,9 @@ Views in Schema TRAFODION.T125SCH2
GAMES_BY_PLAYER
+=======================
+ 1 row(s) returned
+
--- SQL operation complete.
>>get indexes in schema t125sch2;
@@ -2015,6 +2360,9 @@ Tables in Schema TRAFODION.T125SCH3
GAMES
PLAYERS
+=======================
+ 2 row(s) returned
+
--- SQL operation complete.
>>get privileges on table games;
@@ -2023,6 +2371,9 @@ Privileges on Table T125SCH3.GAMES
SIDU-R- SQL_USER2
+=======================
+ 1 row(s) returned
+
--- SQL operation complete.
>>get privileges on table games for t125_role1;
@@ -2036,6 +2387,9 @@ T125SCH1.GAMES_BY_PLAYER
T125SCH2.GAMES_BY_PLAYER
T125SCH3.GAMES_BY_PLAYER
+=======================
+ 3 row(s) returned
+
--- SQL operation complete.
>>get privileges on view games_by_player;
@@ -2044,6 +2398,9 @@ Privileges on View T125SCH3.GAMES_BY_PLAYER
S------ SQL_USER2
+=======================
+ 1 row(s) returned
+
--- SQL operation complete.
>>get privileges on view games_by_player for user sql_user8;
@@ -2067,6 +2424,9 @@ Libraries in Schema TRAFODION.T125SCH3
T125_L1
+=======================
+ 1 row(s) returned
+
--- SQL operation complete.
>>get privileges on library t125_l1;
@@ -2075,6 +2435,9 @@ Privileges on Sequence T125SCH3.T125_L1
----G-- T125_ROLE1
+=======================
+ 1 row(s) returned
+
--- SQL operation complete.
>>get privileges on library t125_l1 for user sql_user8;
@@ -2086,6 +2449,9 @@ Functions in Schema TRAFODION.T125SCH3
TRANSLATEBITMAP
+=======================
+ 1 row(s) returned
+
--- SQL operation complete.
>>get procedures;
@@ -2098,6 +2464,9 @@ Functions for Library T125SCH3.T125_L1
T125SCH3.TRANSLATEBITMAP
+=======================
+ 1 row(s) returned
+
--- SQL operation complete.
>>get procedures for library t125_l2;
@@ -2132,6 +2501,9 @@ T125SCH1
T125SCH2
T125SCH3
+=======================
+ 3 row(s) returned
+
--- SQL operation complete.
>>
>>set schema t125sch1;
@@ -2190,6 +2562,9 @@ Tables in Schema TRAFODION.T125SCH2
GAMES
TEAMS
+=======================
+ 2 row(s) returned
+
--- SQL operation complete.
>>get views in schema t125sch2;
@@ -2220,6 +2595,9 @@ Tables in Schema TRAFODION.T125SCH3
PLAYERS
+=======================
+ 1 row(s) returned
+
--- SQL operation complete.
>>get privileges on table games;
@@ -2255,6 +2633,9 @@ Libraries in Schema TRAFODION.T125SCH3
T125_L1
+=======================
+ 1 row(s) returned
+
--- SQL operation complete.
>>get privileges on library t125_l1;
@@ -2263,6 +2644,9 @@ Privileges on Sequence T125SCH3.T125_L1
----G-- T125_ROLE1
+=======================
+ 1 row(s) returned
+
--- SQL operation complete.
>>get privileges on library t125_l1 for user sql_user8;
@@ -2274,6 +2658,9 @@ Functions in Schema TRAFODION.T125SCH3
TRANSLATEBITMAP
+=======================
+ 1 row(s) returned
+
--- SQL operation complete.
>>get procedures;
@@ -2286,6 +2673,9 @@ Functions for Library T125SCH3.T125_L1
T125SCH3.TRANSLATEBITMAP
+=======================
+ 1 row(s) returned
+
--- SQL operation complete.
>>get procedures for library t125_l2;
http://git-wip-us.apache.org/repos/asf/trafodion/blob/00e9d5b5/core/sql/regress/privs1/EXPECTED136
----------------------------------------------------------------------
diff --git a/core/sql/regress/privs1/EXPECTED136 b/core/sql/regress/privs1/EXPECTED136
index ccd9fb2..b34e572 100755
--- a/core/sql/regress/privs1/EXPECTED136
+++ b/core/sql/regress/privs1/EXPECTED136
@@ -249,6 +249,9 @@ SQL_USER7
SQL_USER8
SQL_USER9
+=======================
+ 11 row(s) returned
+
--- SQL operation complete.
>>
>>-- succeed: test unreserved words
http://git-wip-us.apache.org/repos/asf/trafodion/blob/00e9d5b5/core/sql/regress/privs1/EXPECTED141
----------------------------------------------------------------------
diff --git a/core/sql/regress/privs1/EXPECTED141 b/core/sql/regress/privs1/EXPECTED141
index 07da30d..598dc8e 100644
--- a/core/sql/regress/privs1/EXPECTED141
+++ b/core/sql/regress/privs1/EXPECTED141
@@ -234,6 +234,9 @@ U1T2
U1T3
U1T4
+=======================
+ 4 row(s) returned
+
--- SQL operation complete.
>>
>>set schema t141_user2;
@@ -259,6 +262,9 @@ Tables in Schema TRAFODION.T141_USER2
U2T1
U2T2
+=======================
+ 2 row(s) returned
+
--- SQL operation complete.
>>
>>set schema t141_user3;
@@ -277,6 +283,9 @@ Tables in Schema TRAFODION.T141_USER3
U3T1
+=======================
+ 1 row(s) returned
+
--- SQL operation complete.
>>
>>
@@ -344,6 +353,9 @@ Tables in Schema TRAFODION.T141_USER1
U2T1
U2T2
+=======================
+ 2 row(s) returned
+
--- SQL operation complete.
>>
>>-- create a view on user1's table
@@ -538,6 +550,9 @@ U1T2
U1T3
U1T4
+=======================
+ 4 row(s) returned
+
--- SQL operation complete.
>>
>>set schema t141_user2;
@@ -563,6 +578,9 @@ Tables in Schema TRAFODION.T141_USER2
U2T1
U2T2
+=======================
+ 2 row(s) returned
+
--- SQL operation complete.
>>
>>set schema t141_user3;
@@ -581,6 +599,9 @@ Tables in Schema TRAFODION.T141_USER3
U3T1
+=======================
+ 1 row(s) returned
+
--- SQL operation complete.
>>
>>
@@ -676,6 +697,9 @@ Tables in Schema TRAFODION.T141_USER1
U2T1
U2T2
+=======================
+ 2 row(s) returned
+
--- SQL operation complete.
>>
>>-- create a view on user1's table
@@ -1011,6 +1035,9 @@ Tables in Schema TRAFODION.T141_USER3
U3T1
+=======================
+ 1 row(s) returned
+
--- SQL operation complete.
>>get views;
@@ -1022,6 +1049,9 @@ U3V2
U3V3
U3V4
+=======================
+ 4 row(s) returned
+
--- SQL operation complete.
>>
>>-- ============================================================================
http://git-wip-us.apache.org/repos/asf/trafodion/blob/00e9d5b5/core/sql/regress/privs2/EXPECTED135
----------------------------------------------------------------------
diff --git a/core/sql/regress/privs2/EXPECTED135 b/core/sql/regress/privs2/EXPECTED135
index 5bf3c18..744b645 100644
--- a/core/sql/regress/privs2/EXPECTED135
+++ b/core/sql/regress/privs2/EXPECTED135
@@ -26,6 +26,9 @@ OBJECT_PRIVILEGES
ROLE_USAGE
SCHEMA_PRIVILEGES
+=======================
+ 7 row(s) returned
+
--- SQL operation complete.
>>
>>-- Prepare metadata queries
@@ -902,6 +905,9 @@ DB__ROOTROLE
PUBLIC
T135_ROLE1
+=======================
+ 6 row(s) returned
+
--- SQL operation complete.
>>
>>grant component privilege MANAGE_LIBRARY on sql_operations to t135_role1;
@@ -917,6 +923,9 @@ Privilege information on Component SQL_OPERATIONS for T135_ROLE1
MANAGE_LIBRARY
+=======================
+ 1 row(s) returned
+
--- SQL operation complete.
>>get privileges on component sql_operations for "PUBLIC";
@@ -927,6 +936,9 @@ CREATE_ROUTINE
CREATE_SCHEMA
SHOW
+=======================
+ 3 row(s) returned
+
--- SQL operation complete.
>>
>>
@@ -1300,6 +1312,9 @@ Privilege information on Component SQL_OPERATIONS for PUBLIC
CREATE_SCHEMA
SHOW
+=======================
+ 2 row(s) returned
+
--- SQL operation complete.
>>
>>revoke role t135_role1 from sql_user1;
@@ -1319,6 +1334,9 @@ DB__LIBMGRROLE
DB__ROOTROLE
PUBLIC
+=======================
+ 5 row(s) returned
+
--- SQL operation complete.
>>
>>drop schema t135sch_user3 cascade;
http://git-wip-us.apache.org/repos/asf/trafodion/blob/00e9d5b5/core/sql/regress/privs2/EXPECTED138
----------------------------------------------------------------------
diff --git a/core/sql/regress/privs2/EXPECTED138 b/core/sql/regress/privs2/EXPECTED138
index f8dad07..b42fc78 100644
--- a/core/sql/regress/privs2/EXPECTED138
+++ b/core/sql/regress/privs2/EXPECTED138
@@ -21,6 +21,9 @@ SB_HISTOGRAMS
SB_HISTOGRAM_INTERVALS
SB_PERSISTENT_SAMPLES
+=======================
+ 3 row(s) returned
+
--- SQL operation complete.
>>
>>-- Verify sql_user1 does not have CREATE or CREATE_TABLE privilege
@@ -37,6 +40,9 @@ SB_HISTOGRAMS
SB_HISTOGRAM_INTERVALS
SB_PERSISTENT_SAMPLES
+=======================
+ 3 row(s) returned
+
--- SQL operation complete.
>>create table user1_t1 (c1 int not null primary key, c2 int);
@@ -113,6 +119,9 @@ Privilege information on Component SQL_OPERATIONS for SQL_USER1
CREATE_TABLE
+=======================
+ 1 row(s) returned
+
--- SQL operation complete.
>>sh sqlci -i "TEST138(create_tbl)" -u sql_user1;
>>get tables;
@@ -124,6 +133,9 @@ SB_HISTOGRAMS
SB_HISTOGRAM_INTERVALS
SB_PERSISTENT_SAMPLES
+=======================
+ 3 row(s) returned
+
--- SQL operation complete.
>>create table user1_t1 (c1 int not null primary key, c2 int);
@@ -209,6 +221,9 @@ SB_PERSISTENT_SAMPLES
USER1_T1
USER1_T2
+=======================
+ 5 row(s) returned
+
--- SQL operation complete.
>>
>>-- add columns, constraints, and indexes
@@ -402,6 +417,9 @@ SB_PERSISTENT_SAMPLES
USER1_T1
USER1_T2
+=======================
+ 5 row(s) returned
+
--- SQL operation complete.
>>drop table user1_t1 cascade;
@@ -424,6 +442,9 @@ SB_PERSISTENT_SAMPLES
USER1_T1
USER1_T2
+=======================
+ 5 row(s) returned
+
--- SQL operation complete.
>>
>>exit;
@@ -442,6 +463,9 @@ SB_PERSISTENT_SAMPLES
USER1_T1
USER1_T2
+=======================
+ 5 row(s) returned
+
--- SQL operation complete.
>>
>>obey TEST138(drop_tbl);
@@ -463,6 +487,9 @@ SB_PERSISTENT_SAMPLES
USER1_T1
USER1_T2
+=======================
+ 5 row(s) returned
+
--- SQL operation complete.
>>drop table user1_t1 cascade;
@@ -479,6 +506,9 @@ SB_HISTOGRAMS
SB_HISTOGRAM_INTERVALS
SB_PERSISTENT_SAMPLES
+=======================
+ 3 row(s) returned
+
--- SQL operation complete.
>>
>>
@@ -491,6 +521,9 @@ SB_HISTOGRAMS
SB_HISTOGRAM_INTERVALS
SB_PERSISTENT_SAMPLES
+=======================
+ 3 row(s) returned
+
--- SQL operation complete.
>>
>>obey TEST138(test_alter);
@@ -513,6 +546,9 @@ SB_HISTOGRAMS
SB_HISTOGRAM_INTERVALS
SB_PERSISTENT_SAMPLES
+=======================
+ 3 row(s) returned
+
--- SQL operation complete.
>>
>>-- Verify sql_user2 does not have ALTER or ALTER_TABLE privilege
@@ -534,6 +570,9 @@ SB_HISTOGRAMS
SB_HISTOGRAM_INTERVALS
SB_PERSISTENT_SAMPLES
+=======================
+ 3 row(s) returned
+
--- SQL operation complete.
>>create table user1_t1 (c1 int not null primary key, c2 int);
@@ -623,6 +662,9 @@ SB_PERSISTENT_SAMPLES
USER1_T1
USER1_T2
+=======================
+ 5 row(s) returned
+
--- SQL operation complete.
>>
>>-- add columns, constraints, and indexes
@@ -821,6 +863,9 @@ SB_PERSISTENT_SAMPLES
USER1_T1
USER1_T2
+=======================
+ 5 row(s) returned
+
--- SQL operation complete.
>>
>>-- add columns, constraints, and indexes
@@ -1022,6 +1067,9 @@ ALTER_ROUTINE
ALTER_SEQUENCE
ALTER_VIEW
+=======================
+ 4 row(s) returned
+
--- SQL operation complete.
>>sh sqlci -i "TEST138(alter_tbl)" -u sql_user2;
>>get tables;
@@ -1035,6 +1083,9 @@ SB_PERSISTENT_SAMPLES
USER1_T1
USER1_T2
+=======================
+ 5 row(s) returned
+
--- SQL operation complete.
>>
>>-- add columns, constraints, and indexes
@@ -1242,6 +1293,9 @@ SB_PERSISTENT_SAMPLES
USER1_T1
USER1_T2
+=======================
+ 5 row(s) returned
+
--- SQL operation complete.
>>drop table user1_t1 cascade;
@@ -1258,6 +1312,9 @@ SB_HISTOGRAMS
SB_HISTOGRAM_INTERVALS
SB_PERSISTENT_SAMPLES
+=======================
+ 3 row(s) returned
+
--- SQL operation complete.
>>
>>
@@ -1275,6 +1332,9 @@ Privilege information on Component SQL_OPERATIONS for PUBLIC
CREATE_SCHEMA
SHOW
+=======================
+ 2 row(s) returned
+
--- SQL operation complete.
>>get privileges on component sql_operations for sql_user1;
@@ -1313,6 +1373,9 @@ SB_HISTOGRAMS
SB_HISTOGRAM_INTERVALS
SB_PERSISTENT_SAMPLES
+=======================
+ 3 row(s) returned
+
--- SQL operation complete.
>>create table user1_t1 (c1 int not null primary key, c2 int);
@@ -1425,6 +1488,9 @@ Privilege information on Component SQL_OPERATIONS for SQL_USER1
CREATE_VIEW
+=======================
+ 1 row(s) returned
+
--- SQL operation complete.
>>sh sqlci -i "TEST138(create_view)" -u sql_user1;
>>get views;
@@ -1445,6 +1511,9 @@ Views in Schema TRAFODION.T138SCH
USER1_V1
USER1_V2
+=======================
+ 2 row(s) returned
+
--- SQL operation complete.
>>
>>exit;
@@ -1462,6 +1531,9 @@ Views in Schema TRAFODION.T138SCH
USER1_V1
USER1_V2
+=======================
+ 2 row(s) returned
+
--- SQL operation complete.
>>drop view user1_v1;
@@ -1481,6 +1553,9 @@ Views in Schema TRAFODION.T138SCH
USER1_V1
USER1_V2
+=======================
+ 2 row(s) returned
+
--- SQL operation complete.
>>
>>exit;
@@ -1499,6 +1574,9 @@ Privilege information on Component SQL_OPERATIONS for SQL_USER2
DROP_VIEW
+=======================
+ 1 row(s) returned
+
--- SQL operation complete.
>>sh sqlci -i "TEST138(drop_view)" -u sql_user2;
>>get views;
@@ -1509,6 +1587,9 @@ Views in Schema TRAFODION.T138SCH
USER1_V1
USER1_V2
+=======================
+ 2 row(s) returned
+
--- SQL operation complete.
>>drop view user1_v1;
@@ -1557,6 +1638,9 @@ SB_PERSISTENT_SAMPLES
USER1_T1
USER1_T2
+=======================
+ 5 row(s) returned
+
--- SQL operation complete.
>>drop table user1_t1 cascade;
@@ -1573,6 +1657,9 @@ SB_HISTOGRAMS
SB_HISTOGRAM_INTERVALS
SB_PERSISTENT_SAMPLES
+=======================
+ 3 row(s) returned
+
--- SQL operation complete.
>>
>>
@@ -1630,6 +1717,9 @@ Privilege information on Component SQL_OPERATIONS for SQL_USER1
CREATE_SEQUENCE
+=======================
+ 1 row(s) returned
+
--- SQL operation complete.
>>sh sqlci -i "TEST138(create_sequence)" -u sql_user1;
>>get sequences in schema t138sch;
@@ -1649,6 +1739,9 @@ Sequences in schema TRAFODION.T138SCH
USER1_SEQ1
USER1_SEQ2
+=======================
+ 2 row(s) returned
+
--- SQL operation complete.
>>
>>exit;
@@ -1666,6 +1759,9 @@ Sequences in schema TRAFODION.T138SCH
USER1_SEQ1
USER1_SEQ2
+=======================
+ 2 row(s) returned
+
--- SQL operation complete.
>>drop sequence user1_seq1;
@@ -1685,6 +1781,9 @@ Sequences in schema TRAFODION.T138SCH
USER1_SEQ1
USER1_SEQ2
+=======================
+ 2 row(s) returned
+
--- SQL operation complete.
>>
>>exit;
@@ -1703,6 +1802,9 @@ Privilege information on Component SQL_OPERATIONS for SQL_USER2
DROP_SEQUENCE
+=======================
+ 1 row(s) returned
+
--- SQL operation complete.
>>sh sqlci -i "TEST138(drop_sequence)" -u sql_user2;
>>get sequences in schema t138sch;
@@ -1713,6 +1815,9 @@ Sequences in schema TRAFODION.T138SCH
USER1_SEQ1
USER1_SEQ2
+=======================
+ 2 row(s) returned
+
--- SQL operation complete.
>>drop sequence user1_seq1;
http://git-wip-us.apache.org/repos/asf/trafodion/blob/00e9d5b5/core/sql/regress/privs2/EXPECTED140
----------------------------------------------------------------------
diff --git a/core/sql/regress/privs2/EXPECTED140 b/core/sql/regress/privs2/EXPECTED140
index 81c3fbc..fa6eb18 100644
--- a/core/sql/regress/privs2/EXPECTED140
+++ b/core/sql/regress/privs2/EXPECTED140
@@ -209,6 +209,9 @@ SB_HISTOGRAM_INTERVALS
SB_PERSISTENT_SAMPLES
TEAMS
+=======================
+ 6 row(s) returned
+
--- SQL operation complete.
>>
>>
http://git-wip-us.apache.org/repos/asf/trafodion/blob/00e9d5b5/core/sql/regress/privs2/EXPECTED143
----------------------------------------------------------------------
diff --git a/core/sql/regress/privs2/EXPECTED143 b/core/sql/regress/privs2/EXPECTED143
index 35a3a1d..863d74f 100644
--- a/core/sql/regress/privs2/EXPECTED143
+++ b/core/sql/regress/privs2/EXPECTED143
@@ -442,6 +442,9 @@ SB_HISTOGRAMS
SB_HISTOGRAM_INTERVALS
SB_PERSISTENT_SAMPLES
+=======================
+ 3 row(s) returned
+
--- SQL operation complete.
>>get views;
@@ -453,6 +456,9 @@ U3V2
U3V3
U3V4
+=======================
+ 4 row(s) returned
+
--- SQL operation complete.
>>
>>exit;
@@ -800,6 +806,9 @@ SB_HISTOGRAMS
SB_HISTOGRAM_INTERVALS
SB_PERSISTENT_SAMPLES
+=======================
+ 3 row(s) returned
+
--- SQL operation complete.
>>get views;
@@ -811,6 +820,9 @@ U3V2
U3V3
U3V4
+=======================
+ 4 row(s) returned
+
--- SQL operation complete.
>>
>>exit;
http://git-wip-us.apache.org/repos/asf/trafodion/blob/00e9d5b5/core/sql/regress/privs2/EXPECTED144
----------------------------------------------------------------------
diff --git a/core/sql/regress/privs2/EXPECTED144 b/core/sql/regress/privs2/EXPECTED144
index d25b4a8..f9e0d8e 100644
--- a/core/sql/regress/privs2/EXPECTED144
+++ b/core/sql/regress/privs2/EXPECTED144
@@ -140,6 +140,9 @@ Privilege information on Component SQL_OPERATIONS for PUBLIC
CREATE_SCHEMA
+=======================
+ 1 row(s) returned
+
--- SQL operation complete.
>>
>>obey TEST144(set_up);
@@ -195,6 +198,9 @@ Privileges on Routine T144USER1.GEN_PHONE
------E SQL_USER1
+=======================
+ 1 row(s) returned
+
--- SQL operation complete.
>>get privileges on function gen_random;
@@ -203,6 +209,9 @@ Privileges on Routine T144USER1.GEN_RANDOM
------E SQL_USER1
+=======================
+ 1 row(s) returned
+
--- SQL operation complete.
>>get privileges on function gen_time;
@@ -211,6 +220,9 @@ Privileges on Routine T144USER1.GEN_TIME
------E SQL_USER1
+=======================
+ 1 row(s) returned
+
--- SQL operation complete.
>>get privileges on procedure "_LIBMGR_".help;
@@ -220,6 +232,9 @@ Privileges on Routine _LIBMGR_.HELP
------E DB__LIBMGRROLE
------E DB__ROOT
+=======================
+ 2 row(s) returned
+
--- SQL operation complete.
>>get privileges on table_mapping function "_LIBMGR_".event_log_reader;
@@ -229,6 +244,9 @@ Privileges on Routine _LIBMGR_.EVENT_LOG_READER
------E DB__ROOT
------E PUBLIC
+=======================
+ 2 row(s) returned
+
--- SQL operation complete.
>>
>>-- user1 can execute udfs (as owner), but cannot execute procedure help,
@@ -240,6 +258,9 @@ Privileges on Routine T144USER1.GEN_PHONE
------E SQL_USER1
+=======================
+ 1 row(s) returned
+
--- SQL operation complete.
>>get privileges on procedure "_LIBMGR_".help for sql_user1;
@@ -251,6 +272,9 @@ Privileges on Routine _LIBMGR_.EVENT_LOG_READER
------E PUBLIC
+=======================
+ 1 row(s) returned
+
--- SQL operation complete.
>>sh sqlci -i "TEST144(cmds)" -u sql_user1;
>>values (user);
@@ -272,6 +296,9 @@ Privileges on Routine T144USER1.GEN_TIME
------E SQL_USER1
+=======================
+ 1 row(s) returned
+
--- SQL operation complete.
>>-- should return no rows for users other than sql_user1
>>get privileges on function gen_random for sql_user1;
@@ -281,6 +308,9 @@ Privileges on Routine T144USER1.GEN_RANDOM
------E SQL_USER1
+=======================
+ 1 row(s) returned
+
--- SQL operation complete.
>>select customer_id,
+> 'PHONE: ' || gen_phone(customer_id, customer_areacode) as phone,
@@ -579,6 +609,9 @@ Privileges on Routine T144USER1.GEN_PHONE
------E SQL_USER2
+=======================
+ 1 row(s) returned
+
--- SQL operation complete.
>>get privileges on function gen_random for sql_user2;
@@ -587,6 +620,9 @@ Privileges on Routine T144USER1.GEN_RANDOM
------E SQL_USER2
+=======================
+ 1 row(s) returned
+
--- SQL operation complete.
>>get privileges on function gen_time for user sql_user2;
@@ -595,6 +631,9 @@ Privileges on Routine T144USER1.GEN_TIME
------E SQL_USER2
+=======================
+ 1 row(s) returned
+
--- SQL operation complete.
>>get privileges on procedure "_LIBMGR_".help for user sql_user2;
@@ -647,6 +686,9 @@ Privileges on Routine T144USER1.GEN_TIME
------E SQL_USER2
+=======================
+ 1 row(s) returned
+
--- SQL operation complete.
>>-- should return no rows for users other than sql_user1
>>get privileges on function gen_random for sql_user1;
@@ -817,6 +859,9 @@ Privileges on Routine T144USER1.GEN_PHONE
------E SQL_USER3
+=======================
+ 1 row(s) returned
+
--- SQL operation complete.
>>get privileges on function gen_random for user sql_user3;
http://git-wip-us.apache.org/repos/asf/trafodion/blob/00e9d5b5/core/sql/regress/privs2/EXPECTED146
----------------------------------------------------------------------
diff --git a/core/sql/regress/privs2/EXPECTED146 b/core/sql/regress/privs2/EXPECTED146
index 7bf43b0..66c4fd3 100644
--- a/core/sql/regress/privs2/EXPECTED146
+++ b/core/sql/regress/privs2/EXPECTED146
@@ -146,6 +146,9 @@ HBase Registered Tables in Catalog TRAFODION
"_ROW_".T146T1
"_ROW_".T146T3
+=======================
+ 4 row(s) returned
+
--- SQL operation complete.
>>
>>create role t146_role1;
@@ -168,6 +171,9 @@ Privilege information on Component SQL_OPERATIONS for PUBLIC
CREATE_SCHEMA
+=======================
+ 1 row(s) returned
+
--- SQL operation complete.
>>get external hbase objects, match '%T146%';
@@ -518,6 +524,9 @@ HBase Registered Tables in Catalog TRAFODION
"_CELL_".T146T1
"_ROW_".T146T1
+=======================
+ 2 row(s) returned
+
--- SQL operation complete.
>>exit;
@@ -668,6 +677,9 @@ HBase Registered Tables in Catalog TRAFODION
"_CELL_".T146T1
"_ROW_".T146T1
+=======================
+ 2 row(s) returned
+
--- SQL operation complete.
>>exit;
@@ -823,6 +835,9 @@ HBase Registered Tables in Catalog TRAFODION
"_CELL_".T146T1
"_ROW_".T146T1
+=======================
+ 2 row(s) returned
+
--- SQL operation complete.
>>exit;
@@ -1094,6 +1109,9 @@ HBase Registered Tables in Catalog TRAFODION
"_ROW_".T146T1
"_ROW_".T146T3
+=======================
+ 4 row(s) returned
+
--- SQL operation complete.
>>exit;
@@ -1260,6 +1278,9 @@ HBase Registered Tables in Catalog TRAFODION
"_CELL_".T146T1
"_ROW_".T146T1
+=======================
+ 2 row(s) returned
+
--- SQL operation complete.
>>exit;
@@ -1524,6 +1545,9 @@ HBase Registered Tables in Catalog TRAFODION
"_CELL_".T146T1
+=======================
+ 1 row(s) returned
+
--- SQL operation complete.
>>exit;
@@ -1586,6 +1610,9 @@ SIDU-R- HBASE._ROW_.T146T3
SIDU-R- TRAFODION._HB_MAP_.T146T1
SIDU-R- TRAFODION._HB_MAP_.T146T2
+=======================
+ 6 row(s) returned
+
--- SQL operation complete.
>>
>>drop hbase table t146t2;
@@ -1602,6 +1629,9 @@ SIDU-R- HBASE._ROW_.T146T1
SIDU-R- HBASE._ROW_.T146T3
SIDU-R- TRAFODION._HB_MAP_.T146T1
+=======================
+ 5 row(s) returned
+
--- SQL operation complete.
>>
>>
@@ -1722,6 +1752,9 @@ SIDU-R- HBASE._ROW_.T146T3
SIDU-R- TRAFODION._HB_MAP_.T146T1
SIDU-R- TRAFODION._HB_MAP_.T146T2
+=======================
+ 6 row(s) returned
+
--- SQL operation complete.
>>
>>drop hbase table t146t2;
@@ -1738,6 +1771,9 @@ SIDU-R- HBASE._ROW_.T146T1
SIDU-R- HBASE._ROW_.T146T3
SIDU-R- TRAFODION._HB_MAP_.T146T1
+=======================
+ 4 row(s) returned
+
--- SQL operation complete.
>>
>>exit;
http://git-wip-us.apache.org/repos/asf/trafodion/blob/00e9d5b5/core/sql/regress/udr/EXPECTED001
----------------------------------------------------------------------
diff --git a/core/sql/regress/udr/EXPECTED001 b/core/sql/regress/udr/EXPECTED001
index 66c21f7..adcf75e 100644
--- a/core/sql/regress/udr/EXPECTED001
+++ b/core/sql/regress/udr/EXPECTED001
@@ -231,6 +231,9 @@ SCH.Fibonacci
SCH.SESSIONIZE_DYNAMIC
SCH.SESSIONIZE_DYNAMIC_SHARED
+=======================
+ 3 row(s) returned
+
--- SQL operation complete.
>>
>>showddl table_mapping function sessionize_dynamic;
@@ -258,6 +261,9 @@ Table_mapping Functions for Library SCH.TEST001_JAVA
SCH.FIBONACCI_JAVA
SCH.SESSIONIZE_JAVA
+=======================
+ 2 row(s) returned
+
--- SQL operation complete.
>>
>>showddl table_mapping function sessionize_java;
http://git-wip-us.apache.org/repos/asf/trafodion/blob/00e9d5b5/core/sql/regress/udr/EXPECTED102
----------------------------------------------------------------------
diff --git a/core/sql/regress/udr/EXPECTED102 b/core/sql/regress/udr/EXPECTED102
index 79263aa..b0c44ae 100644
--- a/core/sql/regress/udr/EXPECTED102
+++ b/core/sql/regress/udr/EXPECTED102
@@ -53,6 +53,9 @@ Libraries in Schema TRAFODION._LIBMGR_
DB__LIBMGRNAME
DB__LIBMGR_LIB_CPP
+=======================
+ 2 row(s) returned
+
--- SQL operation complete.
>>get procedures;
@@ -71,6 +74,9 @@ PUTFILE
RM
RMREX
+=======================
+ 11 row(s) returned
+
--- SQL operation complete.
>>showddl procedure rm;
@@ -127,6 +133,9 @@ DB__LIBMGRROLE
DB__ROOTROLE
PUBLIC
+=======================
+ 5 row(s) returned
+
--- SQL operation complete.
>>showddl procedure rm;
@@ -178,6 +187,9 @@ Roles
PUBLIC
+=======================
+ 1 row(s) returned
+
--- SQL operation complete.
>>
>>-- ****************************************************************************
@@ -210,6 +222,9 @@ DB__LIBMGRROLE
DB__ROOTROLE
PUBLIC
+=======================
+ 5 row(s) returned
+
--- SQL operation complete.
>>
>>-- enable library management
@@ -236,6 +251,9 @@ Libraries in Schema TRAFODION._LIBMGR_
DB__LIBMGRNAME
DB__LIBMGR_LIB_CPP
+=======================
+ 2 row(s) returned
+
--- SQL operation complete.
>>get procedures;
@@ -254,6 +272,9 @@ PUTFILE
RM
RMREX
+=======================
+ 11 row(s) returned
+
--- SQL operation complete.
>>showddl procedure rm;
@@ -319,6 +340,9 @@ PUTFILE
RM
RMREX
+=======================
+ 9 row(s) returned
+
--- SQL operation complete.
>>call ls(?);
@@ -347,6 +371,9 @@ PUTFILE
RM
RMREX
+=======================
+ 11 row(s) returned
+
--- SQL operation complete.
>>showddl procedure put;
@@ -419,6 +446,9 @@ PUTFILE
RM
RMREX
+=======================
+ 11 row(s) returned
+
--- SQL operation complete.
>>
>>
http://git-wip-us.apache.org/repos/asf/trafodion/blob/00e9d5b5/core/sql/regress/udr/EXPECTED103
----------------------------------------------------------------------
diff --git a/core/sql/regress/udr/EXPECTED103 b/core/sql/regress/udr/EXPECTED103
index aab044c..0d471f6 100644
--- a/core/sql/regress/udr/EXPECTED103
+++ b/core/sql/regress/udr/EXPECTED103
@@ -553,6 +553,9 @@ GENERATEPHONENUMBER
GENERATERANDOMNUMBER
NONDETERMINISTICRANDOM
+=======================
+ 4 row(s) returned
+
--- SQL operation complete.
>>get procedures in schema udr103sch;
@@ -561,6 +564,9 @@ Procedures in Schema TRAFODION.UDR103SCH
UPDATESUBSCRIPTIONS
+=======================
+ 1 row(s) returned
+
--- SQL operation complete.
>>showddl function generatePhoneNumber;
http://git-wip-us.apache.org/repos/asf/trafodion/blob/00e9d5b5/core/sql/regress/udr/EXPECTED107.SB
----------------------------------------------------------------------
diff --git a/core/sql/regress/udr/EXPECTED107.SB b/core/sql/regress/udr/EXPECTED107.SB
index 03f5851..9956203 100644
--- a/core/sql/regress/udr/EXPECTED107.SB
+++ b/core/sql/regress/udr/EXPECTED107.SB
@@ -482,6 +482,9 @@ SCH.VALIDATE_CURRENT_ROLE_NAME
SCH.VALIDATE_CURRENT_USER_NAME
SCH.VALIDATE_SESSION_USER_NAME
+=======================
+ 37 row(s) returned
+
--- SQL operation complete.
>>
>>showddl function errorwarn ;
[7/9] trafodion git commit: fix regression failuer
Posted by li...@apache.org.
fix regression failuer
Project: http://git-wip-us.apache.org/repos/asf/trafodion/repo
Commit: http://git-wip-us.apache.org/repos/asf/trafodion/commit/5146272c
Tree: http://git-wip-us.apache.org/repos/asf/trafodion/tree/5146272c
Diff: http://git-wip-us.apache.org/repos/asf/trafodion/diff/5146272c
Branch: refs/heads/master
Commit: 5146272c41fc411458a903e4c6e3e52a37513588
Parents: ea5b8b7
Author: Liu Ming <ov...@sina.com>
Authored: Mon Jul 16 03:04:25 2018 -0400
Committer: Liu Ming <ov...@sina.com>
Committed: Mon Jul 16 03:04:25 2018 -0400
----------------------------------------------------------------------
core/sql/regress/core/EXPECTED116 | 6 ------
1 file changed, 6 deletions(-)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/trafodion/blob/5146272c/core/sql/regress/core/EXPECTED116
----------------------------------------------------------------------
diff --git a/core/sql/regress/core/EXPECTED116 b/core/sql/regress/core/EXPECTED116
index f85703d..c423f1a 100644
--- a/core/sql/regress/core/EXPECTED116
+++ b/core/sql/regress/core/EXPECTED116
@@ -777,12 +777,6 @@ T116T2
--- SQL operation complete.
>>get tables in schema t116sch1;
-
-=======================
-Summary info of get:
-Get 0 rows.
-
-
--- SQL operation complete.
>>select count(*) from "_MD_".objects where schema_name = 'T116SCH1'
+> for read uncommitted access;