trafodion-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From rmar...@apache.org
Subject [3/5] incubator-trafodion git commit: Privs2 - TEST140
Date Tue, 26 Jan 2016 21:19:09 GMT
Privs2 - TEST140

Fixed regression issue with TEST140.  TEST140 assumes standard
schema "sch" exists.  In this case it does not.  So changed requests
to use a different schema


Project: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/repo
Commit: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/commit/5af07d67
Tree: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/tree/5af07d67
Diff: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/diff/5af07d67

Branch: refs/heads/master
Commit: 5af07d67b5301be0cf0c59f15345056496253f80
Parents: 8652aeb
Author: Roberta Marton <roberta.marton@apache.org>
Authored: Mon Jan 25 20:01:55 2016 +0000
Committer: Roberta Marton <roberta.marton@apache.org>
Committed: Mon Jan 25 20:01:55 2016 +0000

----------------------------------------------------------------------
 core/sql/regress/privs2/EXPECTED140 | 56 +++++++++++++++++++++-----------
 core/sql/regress/privs2/TEST140     | 13 ++++----
 2 files changed, 44 insertions(+), 25 deletions(-)
----------------------------------------------------------------------


http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/5af07d67/core/sql/regress/privs2/EXPECTED140
----------------------------------------------------------------------
diff --git a/core/sql/regress/privs2/EXPECTED140 b/core/sql/regress/privs2/EXPECTED140
index 052709f..dc4a445 100644
--- a/core/sql/regress/privs2/EXPECTED140
+++ b/core/sql/regress/privs2/EXPECTED140
@@ -11,7 +11,7 @@ MESSAGEFILE        /mnt/rmarton/gitws/incubator-trafodion/core/sqf/export/
...
 MESSAGEFILE LANG   US English
 MESSAGEFILE VRSN   {2016-01-21 17:33 LINUX:EDEV05/rmarton} 
 SQL CATALOG        TRAFODION
-SQL SCHEMA         SCH
+SQL SCHEMA         T140_SHARED_VIEWS
 SQL USER CONNECTED user not connected
 SQL USER DB NAME   DB__ROOT
 SQL USER ID        33333
@@ -57,6 +57,9 @@ WARNINGS           on
 >>create shared schema t140_shared_views;
 
 --- SQL operation complete.
+>>set schema t140_shared_views;
+
+--- SQL operation complete.
 >>
 >>-- compile cpp program for function
 >>sh rm -f ./etest140.dll;
@@ -66,9 +69,6 @@ WARNINGS           on
 >>set pattern $$QUOTE$$ '''';
 >>
 >>-- create the library and udf
->>set schema sch;
-
---- SQL operation complete.
 >>create library t140_l1 file $$QUOTE$$ $$REGRRUNDIR$$/$$DLL$$ $$QUOTE$$ ;
 
 --- SQL operation complete.
@@ -78,7 +78,7 @@ WARNINGS           on
 +>deterministic no sql final call allow any parallelism state area size 1024 ;
 
 --- SQL operation complete.
->>grant execute on function sch.t140_translatePrivsBitmap to "PUBLIC";
+>>grant execute on function t140_translatePrivsBitmap to "PUBLIC";
 
 --- SQL operation complete.
 >>
@@ -234,8 +234,8 @@ TEAMS
 +>   object_type as type,
 +>   substring(authname(grantor_id),1,10) as grantor,
 +>   substring(authname(grantee_id),1,10) as grantee,
-+>   sch.t140_translatePrivsBitmap(privileges_bitmap) as granted_privs,
-+>   sch.t140_translatePrivsBitmap(grantable_bitmap) as grantable_privs
++>   t140_shared_views.t140_translatePrivsBitmap(privileges_bitmap) as granted_privs,
++>   t140_shared_views.t140_translatePrivsBitmap(grantable_bitmap) as grantable_privs
 +>from "_PRIVMGR_MD_".object_privileges 
 +>where object_uid in 
 +>     (select object_uid
@@ -294,8 +294,8 @@ SQL_USER1
 +>   object_type as type,
 +>   substring(authname(grantor_id),1,10) as grantor,
 +>   substring(authname(grantee_id),1,10) as grantee,
-+>   sch.t140_translatePrivsBitmap(privileges_bitmap) as granted_privs,
-+>   sch.t140_translatePrivsBitmap(grantable_bitmap) as grantable_privs
++>   t140_shared_views.t140_translatePrivsBitmap(privileges_bitmap) as granted_privs,
++>   t140_shared_views.t140_translatePrivsBitmap(grantable_bitmap) as grantable_privs
 +>from "_PRIVMGR_MD_".object_privileges 
 +>where object_uid in 
 +>     (select object_uid
@@ -314,6 +314,9 @@ OBJECT_NAME
 TRAFODION.T140_SHARED_VIEWS.HOME_TEAM_GA                                                
                                                                         VI    -2        
 DB__ROOT    S----R-
Mime
View raw message