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

Empty Annotation Cache After Installing utPLSQL #975

Closed
PhilippSalvisberg opened this issue Jul 15, 2019 · 0 comments
Closed

Empty Annotation Cache After Installing utPLSQL #975

PhilippSalvisberg opened this issue Jul 15, 2019 · 0 comments
Assignees
Labels
bug
Milestone

Comments

@PhilippSalvisberg
Copy link
Member

@PhilippSalvisberg PhilippSalvisberg commented Jul 15, 2019

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

  1. create some utPLSQL tests in a user not installed via utPLSQL
  2. run them (they are executed)
  3. install utPLSQL as documented in CONTRIBUTING.md
  4. 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).

@jgebal jgebal added this to the v3.1.8 milestone Aug 5, 2019
jgebal added a commit that referenced this issue Aug 5, 2019
Added ability to refresh annotation cache with DDL trigger enabled if schema was not full-scanned.
Resolves: #975
@PhilippSalvisberg PhilippSalvisberg removed this from the v3.1.8 milestone Sep 6, 2019
jgebal added a commit that referenced this issue Nov 10, 2019
Added ability to refresh annotation cache with DDL trigger enabled if schema was not full-scanned.
Resolves: #975
jgebal added a commit that referenced this issue Nov 12, 2019
Added ability to refresh annotation cache with DDL trigger enabled if schema was not full-scanned.
Resolves: #975
jgebal added a commit that referenced this issue Dec 29, 2019
Added ability to refresh annotation cache with DDL trigger enabled if schema was not full-scanned.
Resolves: #975
jgebal added a commit that referenced this issue Feb 15, 2020
Added ability to refresh annotation cache with DDL trigger enabled if schema was not full-scanned.
Resolves: #975
jgebal added a commit that referenced this issue Feb 15, 2020
Added ability to refresh annotation cache with DDL trigger enabled if schema was not full-scanned.
Resolves: #975
@jgebal jgebal added this to the 3.1.10 milestone Feb 23, 2020
@jgebal jgebal self-assigned this Feb 23, 2020
@jgebal jgebal closed this in #986 Feb 23, 2020
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Linked pull requests

Successfully merging a pull request may close this issue.

2 participants
You can’t perform that action at this time.