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 <ovis_p...@sina.com> Authored: Sat Jul 14 16:55:08 2018 -0400 Committer: Liu Ming <ovis_p...@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 ;
