Empty Annotation Cache After Installing utPLSQL
Describe the bug
When I install utPLSQL in the development environment via development/install.sh then the annotation cache is empty for existing tests.
Provide version info
Information about utPLSQL and Database version,
SQL> set serveroutput on 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.3148-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
- create some utPLSQL tests in a user not installed via utPLSQL
- run them (they are executed)
- install utPLSQL as documented in CONTRIBUTING.md
- re-run the tests in the schema created in step 1 (no tests executed, since the annotation cache is empty)
Expected behavior
The annotation cache is updated either during installation (when the trigger is responsible for the update) or before execution (when the trigger is not active).