Fixed issue with suites getting duplicated when running tests across multiple schemas

jgebal · jgebal · commit 647b830df119 · 2022-04-17T03:33:30.000+03:00
diff --git a/source/core/ut_suite_cache_manager.pkb b/source/core/ut_suite_cache_manager.pkb
@@ -287,19 +287,20 @@ create or replace package body ut_suite_cache_manager is
     with
     extract_parent_child as (
         select s.path, substr(s.path,1,instr(s.path,'.',-1,1)-1) as parent_path,s.object_owner,
-          case when a_random_seed is null then s.line_no else null end line_no,
-          case when a_random_seed is null then null else ut_utils.hash_suite_path(s.path, a_random_seed) end random_seed
+          case when a_random_seed is null then s.line_no end line_no,
+          case when a_random_seed is not null then ut_utils.hash_suite_path(s.path, a_random_seed) end random_seed
           from table(a_suite_rows) s),        
       t1(path,parent_path,object_owner,line_no,random_seed) as (
-        --Anchor memeber
+        --Anchor member
         select s.path, parent_path,s.object_owner,s.line_no,random_seed
           from extract_parent_child s
           where parent_path is null
         union all
         --Recursive member
         select t2.path, t2.parent_path,t2.object_owner,t2.line_no,t2.random_seed
           from t1,extract_parent_child t2
-          where t2.parent_path = t1.path)
+          where t2.parent_path = t1.path
+           and t2.object_owner = t1.object_owner)
       search depth first by line_no desc,random_seed desc nulls last set order1
       select  value(i) as obj  
         bulk collect into l_suite_rows 
