Skip to content
Merged
Changes from 1 commit
Commits
Show all changes
29 commits
Select commit Hold shift + click to select a range
86d4d0a
Initial check-in.
lwasylow Mar 18, 2022
f1f6d71
Tidy up code to make sure we got distinct set of expanded tests.
lwasylow Mar 19, 2022
1454221
Adding extra fields.
lwasylow Mar 23, 2022
ce4df28
Stage 3. Fixing error calls.
lwasylow Mar 29, 2022
273962b
Fixing issue with a non visible tests.
lwasylow Mar 29, 2022
a753e66
Fixing ORA-600
lwasylow Mar 30, 2022
0d8d34d
Cleanup Phase1.
lwasylow Mar 30, 2022
95ddec1
Adding tests.
lwasylow Mar 31, 2022
83dbdaa
Updating documentation.
lwasylow Mar 31, 2022
52c0307
Addresing sonar issues
lwasylow Mar 31, 2022
8f8d257
Extra tests and cleanup of old code.
lwasylow Apr 1, 2022
12be123
Adding extra tests
lwasylow Apr 1, 2022
d5ee6ca
Updating SQL to expand paths and extract suites.
lwasylow Apr 1, 2022
2db8d63
Addressing issue with reconstruct_cache knocking off other levels.
lwasylow Apr 6, 2022
d3396fe
Update tests for random order
lwasylow Apr 7, 2022
02d41a6
Removing a hash function from api into utils package which is more su…
lwasylow Apr 7, 2022
274d80a
Fixing ordering
lwasylow Apr 7, 2022
3937737
Fixing a documentation
lwasylow Apr 7, 2022
9296f38
Fixing indent
lwasylow Apr 7, 2022
6ff7f38
Peer review changes
lwasylow Apr 12, 2022
ee7a98b
Moving a SQL to be more readable.
lwasylow Apr 12, 2022
a53cefa
Apply suggestions from code review
jgebal Apr 13, 2022
011970f
Apply suggestions from code review
jgebal Apr 13, 2022
71e07f9
Merge remote-tracking branch 'origin/develop' into feature/call_tests…
jgebal Apr 15, 2022
221c2de
Address issue of not recognizing a correct nested level of suitepath.
lwasylow Apr 16, 2022
870cfe4
Merge branch 'feature/call_tests_by_part_of_name' of https://github.c…
lwasylow Apr 16, 2022
51439d8
Update documentation
lwasylow Apr 16, 2022
0fc7ff6
Fixing issue where parition by only path caused a duplicate level 1 a…
lwasylow Apr 16, 2022
647b830
Fixed issue with suites getting duplicated when running tests across …
jgebal Apr 17, 2022
File filter

Filter by extension

Filter by extension

Conversations
Failed to load comments.
Loading
Jump to
Jump to file
Failed to load files.
Loading
Diff view
Diff view
Prev Previous commit
Next Next commit
Tidy up code to make sure we got distinct set of expanded tests.
Addressing issue of WITH error ORA-32036: unsupported case for inlining of query name in WITH clause
  • Loading branch information
lwasylow committed Mar 19, 2022
commit f1f6d71db4728e89413b5ab52a0e973cd3ff5f58
18 changes: 9 additions & 9 deletions source/core/ut_suite_cache_manager.pkb
Original file line number Diff line number Diff line change
Expand Up @@ -85,15 +85,11 @@ create or replace package body ut_suite_cache_manager is


gc_get_bulk_cache_suite_sql constant varchar2(32767) :=
q'[with
suite_paths_tabs as (
select schema_name,object_name,procedure_name,suite_path
from table(:l_schema_paths)
),
q'[with
suite_items as (
select /*+ cardinality(c 500) */ value(c) as obj
from ut_suite_cache c,
suite_paths_tabs sp
table(:l_schema_paths) sp
where c.object_owner = upper(sp.schema_name)
and sp.suite_path is not null
and (
Expand All @@ -108,7 +104,7 @@ create or replace package body ut_suite_cache_manager is
union all
select /*+ cardinality(c 500) */ value(c) as obj
from ut_suite_cache c,
suite_paths_tabs sp
table(:l_schema_paths) sp
where c.object_owner = upper(sp.schema_name)
and sp.suite_path is null
and c.object_name like nvl(upper(replace(sp.object_name,'*','%')),c.object_name)
Expand Down Expand Up @@ -388,7 +384,11 @@ create or replace package body ut_suite_cache_manager is
)
select ut_path_item(schema_name,object_name,procedure_name,suite_path)
bulk collect into l_schema_paths
from paths_to_expand;
from
(select schema_name,object_name,procedure_name,suite_path,
row_number() over ( partition by schema_name,object_name,procedure_name,suite_path order by 1) r_num
from paths_to_expand)
where r_num = 1 ;
return l_schema_paths;
end;

Expand Down Expand Up @@ -429,7 +429,7 @@ create or replace package body ut_suite_cache_manager is

execute immediate l_sql
bulk collect into l_results
using l_schema_paths, l_include_tags, l_include_tags, l_exclude_tags, a_random_seed;
using l_schema_paths, l_schema_paths, l_include_tags, l_include_tags, l_exclude_tags, a_random_seed;
return l_results;
end;

Expand Down