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 — Empty Annotation Cache After Installing utPLSQL · Issue #975 · utPLSQL/utPLSQL

Empty Annotation Cache After Installing utPLSQL  #975

New issue
Copy link
New issue
Copy link
Closed
#986
Closed
Empty Annotation Cache After Installing utPLSQL #975
#986
Copy link
Assignees
jgebal
Labels
bug
Milestone
v3.1.10

Description

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

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).

Activity

  1. PhilippSalvisberg
    added
    bug
    on Jul 15, 2019
  2. jgebal
    added this to the v3.1.8 milestone on Aug 5, 2019
  3. jgebal
    added a commit that references this issue on Aug 5, 2019

    Cleanup and refactoring of annotation cache.

    This issue will close once commit f332430 is merged into the 'develop' branch.
    f332430
  4. PhilippSalvisberg
    removed this from the v3.1.8 milestone on Sep 6, 2019
  5. jgebal
    added 2 commits that reference this issue on Nov 10, 2019

    Cleanup and refactoring of annotation cache.

    This issue will close once commit 3b401ce is merged into the 'develop' branch.
    3b401ce

    Cleanup and refactoring of annotation cache.

    This issue will close once commit 07250a3 is merged into the 'develop' branch.
    07250a3
  6. jgebal
    added a commit that references this issue on Dec 29, 2019

    Cleanup and refactoring of annotation cache.

    This issue will close once commit 31dd2a3 is merged into the 'develop' branch.
    31dd2a3
  7. jgebal
    added 2 commits that reference this issue on Feb 15, 2020

    Cleanup and refactoring of annotation cache.

    This issue will close once commit 43de646 is merged into the 'develop' branch.
    43de646

    Cleanup and refactoring of annotation cache.

    This issue will close once commit ba90abf is merged into the 'develop' branch.
    ba90abf
  8. jgebal
    added this to the 3.1.10 milestone on Feb 23, 2020
  9. jgebal
    self-assigned this
    on Feb 23, 2020
  10. jgebal
    closed this as completedin #986on Feb 23, 2020
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

  • @jgebal
    jgebal

Labels

bug

Type

No type

Projects

No projects

    Milestone

    • v3.1.10

    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.