Repository: trafodion Updated Branches: refs/heads/master 360427c20 -> 17a6a5cfa
[TRAFODION-2974] Update expected files New privileges granted to public caused several tests to fail. Project: http://git-wip-us.apache.org/repos/asf/trafodion/repo Commit: http://git-wip-us.apache.org/repos/asf/trafodion/commit/d505aee7 Tree: http://git-wip-us.apache.org/repos/asf/trafodion/tree/d505aee7 Diff: http://git-wip-us.apache.org/repos/asf/trafodion/diff/d505aee7 Branch: refs/heads/master Commit: d505aee7a0939fc0f50454fdd2491b0a6cc5e84a Parents: 0f0e0c9 Author: Hans Zeller <hzel...@apache.org> Authored: Tue Mar 6 19:32:03 2018 +0000 Committer: Hans Zeller <hzel...@apache.org> Committed: Tue Mar 6 19:32:03 2018 +0000 ---------------------------------------------------------------------- core/sql/regress/privs1/EXPECTED123 | 32 ++++++++++++++++++++++++++++++++ core/sql/regress/privs1/EXPECTED125 | 8 ++++++++ core/sql/regress/udr/EXPECTED102 | 2 ++ 3 files changed, 42 insertions(+) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/trafodion/blob/d505aee7/core/sql/regress/privs1/EXPECTED123 ---------------------------------------------------------------------- diff --git a/core/sql/regress/privs1/EXPECTED123 b/core/sql/regress/privs1/EXPECTED123 index bf848b4..0251bda 100644 --- a/core/sql/regress/privs1/EXPECTED123 +++ b/core/sql/regress/privs1/EXPECTED123 @@ -262,6 +262,8 @@ SQL_USER5 Privileges for User SQL_USER1 ============================= +------E TRAFODION."_LIBMGR_".EVENT_LOG_READER +------E TRAFODION."_LIBMGR_".JDBC --DU--- TRAFODION.T123SCH.GAMES -I----- TRAFODION.T123SCH.GAMES SIDU-R- TRAFODION.T123SCH.PLAYERS @@ -280,6 +282,8 @@ S------ TRAFODION.T123SCH.TEAMS <Column> TEAM_NUMBER Privileges for User SQL_USER2 ============================= +------E TRAFODION."_LIBMGR_".EVENT_LOG_READER +------E TRAFODION."_LIBMGR_".JDBC -I----- TRAFODION.T123SCH.GAMES S------ TRAFODION.T123SCH.PLAYERS <Column> PLAYER_NAME S------ TRAFODION.T123SCH.PLAYERS <Column> PLAYER_NUMBER @@ -295,6 +299,8 @@ S------ TRAFODION.T123SCH.TEAMS <Column> TEAM_NUMBER Privileges for User SQL_USER3 ============================= +------E TRAFODION."_LIBMGR_".EVENT_LOG_READER +------E TRAFODION."_LIBMGR_".JDBC S------ TRAFODION.T123SCH.PLAYERS <Column> PLAYER_NAME S------ TRAFODION.T123SCH.PLAYERS <Column> PLAYER_NUMBER S------ TRAFODION.T123SCH.PLAYERS <Column> PLAYER_TEAM_NUMBER @@ -307,6 +313,8 @@ S------ TRAFODION.T123SCH.TEAMS <Column> TEAM_NUMBER Privileges for User SQL_USER4 ============================= +------E TRAFODION."_LIBMGR_".EVENT_LOG_READER +------E TRAFODION."_LIBMGR_".JDBC S------ TRAFODION.T123SCH.GAMES S------ TRAFODION.T123SCH.PLAYERS <Column> PLAYER_NAME S------ TRAFODION.T123SCH.PLAYERS <Column> PLAYER_NUMBER @@ -321,6 +329,8 @@ S------ TRAFODION.T123SCH.TEAMS <Column> TEAM_NUMBER Privileges for User SQL_USER5 ============================= +------E TRAFODION."_LIBMGR_".EVENT_LOG_READER +------E TRAFODION."_LIBMGR_".JDBC SIDU-R- TRAFODION.T123SCH.GAMES SIDU-R- TRAFODION.T123SCH.PLAYERS S------ TRAFODION.T123SCH.PLAYERS <Column> PLAYER_NAME @@ -377,6 +387,8 @@ SIDU-R- TRAFODION.T123SCH.TEAMS Privileges for Role PUBLIC ========================== +------E TRAFODION."_LIBMGR_".EVENT_LOG_READER +------E TRAFODION."_LIBMGR_".JDBC S------ TRAFODION.T123SCH.PLAYERS <Column> PLAYER_NAME S------ TRAFODION.T123SCH.PLAYERS <Column> PLAYER_NUMBER S------ TRAFODION.T123SCH.PLAYERS <Column> PLAYER_TEAM_NUMBER @@ -488,6 +500,8 @@ SQL_USER1 Privileges for User SQL_USER1 ============================= +------E TRAFODION."_LIBMGR_".EVENT_LOG_READER +------E TRAFODION."_LIBMGR_".JDBC --DU--- TRAFODION.T123SCH.GAMES -I----- TRAFODION.T123SCH.GAMES SIDU-R- TRAFODION.T123SCH.PLAYERS @@ -544,6 +558,8 @@ Privileges for Role T123_PLANNERROLE Privileges for Role PUBLIC ========================== +------E TRAFODION."_LIBMGR_".EVENT_LOG_READER +------E TRAFODION."_LIBMGR_".JDBC S------ TRAFODION.T123SCH.PLAYERS <Column> PLAYER_NAME S------ TRAFODION.T123SCH.PLAYERS <Column> PLAYER_NUMBER S------ TRAFODION.T123SCH.PLAYERS <Column> PLAYER_TEAM_NUMBER @@ -655,6 +671,8 @@ SQL_USER2 Privileges for User SQL_USER2 ============================= +------E TRAFODION."_LIBMGR_".EVENT_LOG_READER +------E TRAFODION."_LIBMGR_".JDBC -I----- TRAFODION.T123SCH.GAMES S------ TRAFODION.T123SCH.PLAYERS <Column> PLAYER_NAME S------ TRAFODION.T123SCH.PLAYERS <Column> PLAYER_NUMBER @@ -699,6 +717,8 @@ Privileges for Role T123_PLANNERROLE Privileges for Role PUBLIC ========================== +------E TRAFODION."_LIBMGR_".EVENT_LOG_READER +------E TRAFODION."_LIBMGR_".JDBC S------ TRAFODION.T123SCH.PLAYERS <Column> PLAYER_NAME S------ TRAFODION.T123SCH.PLAYERS <Column> PLAYER_NUMBER S------ TRAFODION.T123SCH.PLAYERS <Column> PLAYER_TEAM_NUMBER @@ -806,6 +826,8 @@ PUBLIC Privileges for User SQL_USER3 ============================= +------E TRAFODION."_LIBMGR_".EVENT_LOG_READER +------E TRAFODION."_LIBMGR_".JDBC S------ TRAFODION.T123SCH.PLAYERS <Column> PLAYER_NAME S------ TRAFODION.T123SCH.PLAYERS <Column> PLAYER_NUMBER S------ TRAFODION.T123SCH.PLAYERS <Column> PLAYER_TEAM_NUMBER @@ -837,6 +859,8 @@ S------ TRAFODION.T123SCH.TEAMS <Column> TEAM_NUMBER Privileges for Role PUBLIC ========================== +------E TRAFODION."_LIBMGR_".EVENT_LOG_READER +------E TRAFODION."_LIBMGR_".JDBC S------ TRAFODION.T123SCH.PLAYERS <Column> PLAYER_NAME S------ TRAFODION.T123SCH.PLAYERS <Column> PLAYER_NUMBER S------ TRAFODION.T123SCH.PLAYERS <Column> PLAYER_TEAM_NUMBER @@ -947,6 +971,8 @@ PUBLIC Privileges for User SQL_USER4 ============================= +------E TRAFODION."_LIBMGR_".EVENT_LOG_READER +------E TRAFODION."_LIBMGR_".JDBC S------ TRAFODION.T123SCH.GAMES S------ TRAFODION.T123SCH.PLAYERS <Column> PLAYER_NAME S------ TRAFODION.T123SCH.PLAYERS <Column> PLAYER_NUMBER @@ -977,6 +1003,8 @@ S------ TRAFODION.T123SCH.TEAMS <Column> TEAM_NUMBER Privileges for Role PUBLIC ========================== +------E TRAFODION."_LIBMGR_".EVENT_LOG_READER +------E TRAFODION."_LIBMGR_".JDBC S------ TRAFODION.T123SCH.PLAYERS <Column> PLAYER_NAME S------ TRAFODION.T123SCH.PLAYERS <Column> PLAYER_NUMBER S------ TRAFODION.T123SCH.PLAYERS <Column> PLAYER_TEAM_NUMBER @@ -1097,6 +1125,8 @@ SQL_USER5 Privileges for User SQL_USER5 ============================= +------E TRAFODION."_LIBMGR_".EVENT_LOG_READER +------E TRAFODION."_LIBMGR_".JDBC SIDU-R- TRAFODION.T123SCH.GAMES SIDU-R- TRAFODION.T123SCH.PLAYERS S------ TRAFODION.T123SCH.PLAYERS <Column> PLAYER_NAME @@ -1140,6 +1170,8 @@ SIDU-R- TRAFODION.T123SCH.TEAMS Privileges for Role PUBLIC ========================== +------E TRAFODION."_LIBMGR_".EVENT_LOG_READER +------E TRAFODION."_LIBMGR_".JDBC S------ TRAFODION.T123SCH.PLAYERS <Column> PLAYER_NAME S------ TRAFODION.T123SCH.PLAYERS <Column> PLAYER_NUMBER S------ TRAFODION.T123SCH.PLAYERS <Column> PLAYER_TEAM_NUMBER http://git-wip-us.apache.org/repos/asf/trafodion/blob/d505aee7/core/sql/regress/privs1/EXPECTED125 ---------------------------------------------------------------------- diff --git a/core/sql/regress/privs1/EXPECTED125 b/core/sql/regress/privs1/EXPECTED125 index 1984bb0..73f0d59 100644 --- a/core/sql/regress/privs1/EXPECTED125 +++ b/core/sql/regress/privs1/EXPECTED125 @@ -482,6 +482,8 @@ SIDU-R- TRAFODION.T125SCH3.PLAYERS Privileges for User SQL_USER1 ============================= +------E TRAFODION."_LIBMGR_".EVENT_LOG_READER +------E TRAFODION."_LIBMGR_".JDBC ----G-- TRAFODION.T125SCH2.PLAYERS_SEQUENCE ------E TRAFODION.T125SCH2.TESTHIVE -I----- TRAFODION.T125SCH3.GAMES @@ -494,6 +496,8 @@ S------ TRAFODION.T125SCH3.GAMES_BY_PLAYER <Column> PLAYER_NAME Privileges for User SQL_USER2 ============================= +------E TRAFODION."_LIBMGR_".EVENT_LOG_READER +------E TRAFODION."_LIBMGR_".JDBC SIDU-R- TRAFODION.T125SCH1.GAMES S------ TRAFODION.T125SCH1.GAMES_BY_PLAYER SIDU-R- TRAFODION.T125SCH2.GAMES @@ -511,6 +515,8 @@ SIDU-R- TRAFODION.T125SCH3.PLAYERS Privileges for User SQL_USER7 ============================= +------E TRAFODION."_LIBMGR_".EVENT_LOG_READER +------E TRAFODION."_LIBMGR_".JDBC S------ TRAFODION.T125SCH2.GAMES <Column> GAME_NUMBER S------ TRAFODION.T125SCH2.TEAMS <Column> TEAM_NUMBER SIDU-R- TRAFODION.T125SCH3.PLAYERS @@ -522,6 +528,8 @@ SIDU-R- TRAFODION.T125SCH3.PLAYERS Privileges for User SQL_USER8 ============================= +------E TRAFODION."_LIBMGR_".EVENT_LOG_READER +------E TRAFODION."_LIBMGR_".JDBC SIDU-R- TRAFODION.T125SCH3.GAMES S----R- TRAFODION.T125SCH3.GAMES_BY_PLAYER S----R- TRAFODION.T125SCH3.HOME_TEAMS_GAMES http://git-wip-us.apache.org/repos/asf/trafodion/blob/d505aee7/core/sql/regress/udr/EXPECTED102 ---------------------------------------------------------------------- diff --git a/core/sql/regress/udr/EXPECTED102 b/core/sql/regress/udr/EXPECTED102 index f0de120..79263aa 100644 --- a/core/sql/regress/udr/EXPECTED102 +++ b/core/sql/regress/udr/EXPECTED102 @@ -51,6 +51,7 @@ Libraries in Schema TRAFODION._LIBMGR_ ====================================== DB__LIBMGRNAME +DB__LIBMGR_LIB_CPP --- SQL operation complete. >>get procedures; @@ -233,6 +234,7 @@ Libraries in Schema TRAFODION._LIBMGR_ ====================================== DB__LIBMGRNAME +DB__LIBMGR_LIB_CPP --- SQL operation complete. >>get procedures;