Description

jgebal

opened on Jul 14, 2019

Issue body actions

Describe the bug
Current implementation of ut_runner.get_suites_info doesn't always return suites.

This is visible when trying to find one of our test suites:

SELECT *
  FROM TABLE(ut_runner.get_suites_info(upper('UT3$USER#'), upper('EXPECTATIONS')));

The query should return data but it isn't

Provide version info
3.1.8-develop

Activity

1. jgebal

   added

   bug

   on Jul 14, 2019
2. jgebal commented on Jul 14, 2019

   

   jgebal

   on Jul 14, 2019

   MemberAuthor

   More actions

   This query however provides valid output:

   SELECT *
     FROM TABLE(ut_runner.get_suites_info(upper('UT3$USER#')))
     WHERE item_type = 'UT_SUITE'
       and object_name = 'EXPECTATIONS';

   This form is however not recommended as it's much slower to process.
3. jgebal commented on Jul 14, 2019

   

   jgebal

   on Jul 14, 2019

   MemberAuthor

   More actions

   This was introduced in 3.1.8-develop
4. jgebal

   added a commit that references this issue on Jul 16, 2019

   Fixed issue with get_Cached_suite_rows syntax.

   This issue will close once commit 11b5f84 is merged into the 'develop' branch.

   11b5f84
5. jgebal

   closed this as completedin #978on Jul 16, 2019

Issue actions