GV

GeezerVison

The World Wide Web, restored to 800 pixels of glory.

Home|About|Gaming cabinet|Archives|How it works|Starter sites

On this site

  • Sign in
  • ActionsCI/CD and automation
  • CodespacesCloud development environments
  • All Features
  • Documentation
  • Training
  • Certifications
  • Build with Copilot
  • Customize Copilot
  • Integrations
  • Trending repos
  • GitHub Sponsors
  • Developer articles
  • Enterprises

This view

  • Original page
  • New address

GeezerVison is showing github.com — Wrong result for get_suites_info when passing package name · Issue #977 · utPLSQL/utPLSQL

Wrong result for get_suites_info when passing package name #977

New issue
Copy link
New issue
Copy link
Closed
#978
Closed
Wrong result for get_suites_info when passing package name#977
#978
Copy link
Labels
bug

Description

@PhilippSalvisberg
PhilippSalvisberg
opened on Jul 16, 2019
Issue body actions

Describe the bug

No result is returned when passing a package name to the ut_runner.get_suites_info function.

Provide version info
Information about utPLSQL and Database version,

SQL> declare
  2    l_version varchar2(255);
  3    l_compatibility varchar2(255);
  4  begin
  5    dbms_utility.db_version( l_version, l_compatibility );
  6    dbms_output.put_line( l_version );
  7    dbms_output.put_line( l_compatibility );
  8  end;
  9  /
19.0.0.0.0
19.0.0


PL/SQL procedure successfully completed.

SQL> select substr(ut.version(),1,60) as ut_version from dual;

UT_VERSION                                                  
------------------------------------------------------------
v3.1.8.3161-develop                                         

SQL> select * from v$version;

BANNER
--------------------------------------------------------------------------------
BANNER_FULL
------------------------------------------------------------------------------------------------------------------------------------
BANNER_LEGACY                                                                        CON_ID
-------------------------------------------------------------------------------- ----------
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production           
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production                                                              
Version 19.2.0.0.0                                                                                                                  
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production                    0


SQL> select * from nls_session_parameters;

PARAMETER                      VALUE                                                           
------------------------------ ----------------------------------------------------------------
NLS_LANGUAGE                   AMERICAN                                                        
NLS_TERRITORY                  SWITZERLAND                                                     
NLS_CURRENCY                   SFr.                                                            
NLS_ISO_CURRENCY               SWITZERLAND                                                     
NLS_NUMERIC_CHARACTERS         .'                                                              
NLS_CALENDAR                   GREGORIAN                                                       
NLS_DATE_FORMAT                DD.MM.RR                                                        
NLS_DATE_LANGUAGE              AMERICAN                                                        
NLS_SORT                       BINARY                                                          
NLS_TIME_FORMAT                HH24:MI:SSXFF                                                   
NLS_TIMESTAMP_FORMAT           DD.MM.RR HH24:MI:SSXFF                                          
NLS_TIME_TZ_FORMAT             HH24:MI:SSXFF TZR                                               
NLS_TIMESTAMP_TZ_FORMAT        DD.MM.RR HH24:MI:SSXFF TZR                                      
NLS_DUAL_CURRENCY              SF                                                              
NLS_COMP                       BINARY                                                          
NLS_LENGTH_SEMANTICS           BYTE                                                            
NLS_NCHAR_CONV_EXCP            FALSE                                                           

17 rows selected. 

SQL> select substr(dbms_utility.port_string,1,60) as port_string from dual;

PORT_STRING                                                 
------------------------------------------------------------
x86_64/Linux 2.4.xx 

Information about client software

not relevant

To Reproduce

  1. install the current develop version

  2. run this query:

SELECT *
  FROM TABLE(ut_runner.get_suites_info(upper('UT3_TESTER'), NULL))
 WHERE OBJECT_NAME = 'TEST_ANNOTATION_MANAGER';

it returns 17 rows.

  1. run this query
SELECT *
  FROM TABLE(ut_runner.get_suites_info(upper('UT3_TESTER'), 'TEST_ANNOTATION_MANAGER'))
 WHERE OBJECT_NAME = 'TEST_ANNOTATION_MANAGER';

it returns no rows. Which is wrong. Should return 17 rows as well.

Expected behavior

The parameter a_package_name should work when passing a not null value.

Activity

  1. PhilippSalvisberg
    added
    bug
    on Jul 16, 2019
  2. PhilippSalvisberg commented on Jul 16, 2019

    @PhilippSalvisberg
    PhilippSalvisberg
    on Jul 16, 2019
    MemberAuthor
    More actions

    This worked in v3.1.7.

  3. jgebal commented on Jul 16, 2019

    @jgebal
    jgebal
    on Jul 16, 2019
    Member
    More actions

    Duplicate of #974

  4. jgebal
    marked this as a duplicate of Not all suites are found by suitepath #974 on Jul 16, 2019
  5. jgebal
    closed this as completedin #978on Jul 16, 2019
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    bug

    Type

    No type

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions

      You are visitor 01402503 — GeezerVison does not store the pages you look up.
      Best viewed with Netscape Navigator 4.7 or Internet Explorer 6 at 800×600. No cookies required.