Fixing issue where parition by only path caused a duplicate level 1 across two owners being removed.

lwasylow · lwasylow · commit 0fc7ff6d4717 · 2022-04-16T16:22:09.000+01:00
diff --git a/source/core/ut_suite_cache_manager.pkb b/source/core/ut_suite_cache_manager.pkb
@@ -203,7 +203,7 @@ create or replace package body ut_suite_cache_manager is
   begin
     select obj bulk collect into  l_suite_items
     from (
-    select  /*+ cardinality(c 500) */ value(c) as obj,row_number() over ( partition by path order by path asc) as r_num  
+    select  /*+ cardinality(c 500) */ value(c) as obj,row_number() over ( partition by path,object_owner order by path,object_owner asc) as r_num  
       from ut_suite_cache c,
       table(a_schema_paths)  sp
       where c.object_owner = upper(sp.schema_name)
