René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"Empty Annotation Cache After Installing utPLSQL ","articleBody":"**Describe the bug**\r\n\r\nWhen I install utPLSQL in the development environment via `development/install.sh` then the annotation cache is empty for existing tests. \r\n\r\n**Provide version info**\r\n\r\nInformation about utPLSQL and Database version, \r\n```sql\r\nSQL\u003e set serveroutput on\r\nSQL\u003e declare\r\n  2    l_version varchar2(255);\r\n  3    l_compatibility varchar2(255);\r\n  4  begin\r\n  5    dbms_utility.db_version( l_version, l_compatibility );\r\n  6    dbms_output.put_line( l_version );\r\n  7    dbms_output.put_line( l_compatibility );\r\n  8  end;\r\n  9  /\r\n19.0.0.0.0\r\n19.0.0\r\n\r\n\r\nPL/SQL procedure successfully completed.\r\n\r\nSQL\u003e select substr(ut.version(),1,60) as ut_version from dual;\r\n\r\nUT_VERSION                                                  \r\n------------------------------------------------------------\r\nv3.1.8.3148-develop                                         \r\n\r\nSQL\u003e select * from v$version;\r\n\r\nBANNER\r\n--------------------------------------------------------------------------------\r\nBANNER_FULL\r\n------------------------------------------------------------------------------------------------------------------------------------\r\nBANNER_LEGACY                                                                        CON_ID\r\n-------------------------------------------------------------------------------- ----------\r\nOracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production           \r\nOracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production                                                              \r\nVersion 19.2.0.0.0                                                                                                                  \r\nOracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production                    0\r\n\r\n\r\nSQL\u003e select * from nls_session_parameters;\r\n\r\nPARAMETER                      VALUE                                                           \r\n------------------------------ ----------------------------------------------------------------\r\nNLS_LANGUAGE                   AMERICAN                                                        \r\nNLS_TERRITORY                  SWITZERLAND                                                     \r\nNLS_CURRENCY                   SFr.                                                            \r\nNLS_ISO_CURRENCY               SWITZERLAND                                                     \r\nNLS_NUMERIC_CHARACTERS         .'                                                              \r\nNLS_CALENDAR                   GREGORIAN                                                       \r\nNLS_DATE_FORMAT                DD.MM.RR                                                        \r\nNLS_DATE_LANGUAGE              AMERICAN                                                        \r\nNLS_SORT                       BINARY                                                          \r\nNLS_TIME_FORMAT                HH24:MI:SSXFF                                                   \r\nNLS_TIMESTAMP_FORMAT           DD.MM.RR HH24:MI:SSXFF                                          \r\nNLS_TIME_TZ_FORMAT             HH24:MI:SSXFF TZR                                               \r\nNLS_TIMESTAMP_TZ_FORMAT        DD.MM.RR HH24:MI:SSXFF TZR                                      \r\nNLS_DUAL_CURRENCY              SF                                                              \r\nNLS_COMP                       BINARY                                                          \r\nNLS_LENGTH_SEMANTICS           BYTE                                                            \r\nNLS_NCHAR_CONV_EXCP            FALSE                                                           \r\n\r\n17 rows selected. \r\n\r\nSQL\u003e select substr(dbms_utility.port_string,1,60) as port_string from dual;\r\n\r\nPORT_STRING                                                 \r\n------------------------------------------------------------\r\nx86_64/Linux 2.4.xx \r\n```\r\n\r\n**Information about client software**\r\n\r\nnot relevant\r\n\r\n**To Reproduce**\r\n\r\n1. create some utPLSQL tests in a user not installed via utPLSQL\r\n2. run them (they are executed)\r\n3. install utPLSQL as documented in [CONTRIBUTING.md](https://github.com/utPLSQL/utPLSQL/blob/develop/CONTRIBUTING.md#configuring-local-environment)\r\n4. re-run the tests in the schema created in step 1 (no tests executed, since the annotation cache is empty) \r\n\r\n**Expected behavior**\r\n\r\nThe annotation cache is updated either during installation (when the trigger is responsible for the update) or before execution (when the trigger is not active).\r\n","author":{"url":"https://github.com/PhilippSalvisberg","@type":"Person","name":"PhilippSalvisberg"},"datePublished":"2019-07-15T11:24:29.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":0},"url":"https://github.com/975/utPLSQL/issues/975"}