Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Wrong result for get_suites_info when passing package name #977

Closed
PhilippSalvisberg opened this issue Jul 16, 2019 · 2 comments · Fixed by #978

Comments

@PhilippSalvisberg
Copy link
Member

commented Jul 16, 2019

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.

@PhilippSalvisberg

This comment has been minimized.

Copy link
Member Author

commented Jul 16, 2019

This worked in v3.1.7.

@jgebal

This comment has been minimized.

Copy link
Member

commented Jul 16, 2019

Duplicate of #974

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
2 participants
You can’t perform that action at this time.