René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"Wrong rollback warnings in utPLSQL Development Environment","articleBody":"**Describe the bug**\r\n\r\nWhen I refresh my utpPLSQL development environment I get the following test result:\r\n\r\n```\r\nWarnings:\r\n \r\n  1) utplsql.ut3_tester.core\r\n      Unable to perform automatic rollback after test suite. An implicit or explicit commit/rollback occurred in procedures:\r\n      \r\n      Use the \"--%rollback(manual)\" annotation or remove commit/rollback/ddl statements that are causing the issue.\r\n \r\n  2) utplsql\r\n      Unable to perform automatic rollback after test suite. An implicit or explicit commit/rollback occurred in procedures:\r\n      \r\n      Use the \"--%rollback(manual)\" annotation or remove commit/rollback/ddl statements that are causing the issue.\r\n \r\nFinished in 84.704215 seconds\r\n888 tests, 0 failed, 0 errored, 5 disabled, 2 warning(s)\r\n```\r\n\r\nBut when I rerun the tests I do not get this warnings again.\r\n\r\nWhat am I doing wrong?\r\n\r\n**Provide version info**\r\n\r\nInformation about utPLSQL and Database version, \r\n```\r\n19.0.0.0.0\r\n19.0.0\r\n\r\n\r\nPL/SQL procedure successfully completed.\r\n\r\n\r\nUT_VERSION                                                  \r\n------------------------------------------------------------\r\nv3.1.8.3169-develop\r\n\r\n\r\nBANNER                                                                           BANNER_FULL                                                                                                                                                      BANNER_LEGACY                                                                        CON_ID\r\n-------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------- ----------\r\nOracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production           Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production                                                                                           Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production                    0\r\n                                                                                 Version 19.2.0.0.0                                                                                                                                                                                                                                          \r\n\r\n\r\n\r\nPARAMETER                      VALUE                                                           \r\n------------------------------ ----------------------------------------------------------------\r\nNLS_LANGUAGE                   ENGLISH                                                         \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.YYYY HH24:MI:SS                                           \r\nNLS_DATE_LANGUAGE              ENGLISH                                                         \r\nNLS_SORT                       BINARY                                                          \r\nNLS_TIME_FORMAT                HH24:MI:SSXFF                                                   \r\nNLS_TIMESTAMP_FORMAT           DD.MM.RR HH24:MI:SSXFF                                          \r\n\r\nPARAMETER                      VALUE                                                           \r\n------------------------------ ----------------------------------------------------------------\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\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\nUTPLSQL_CLI_VERSION=\"3.1.6\" (as configured in the current develop branch)\r\n\r\n**To Reproduce**\r\n\r\n1. Refresh develop branch via git\r\n2. Run the following (excerpt of a shell script)\r\n\r\n```\r\n# local cloned utPLSQL repository, is different in your environment\r\ncd /Users/phs/github/utPLSQL\r\n\r\ngit fetch --all\r\nchmod +x development/*.sh\r\nchmod +x test/*.sh\r\nchmod +x .travis/*.sh\r\n\r\n# configuring connection for my database for utPLSQL development\r\necho \"export CONNECTION_STR=127.0.0.1:1521/odb.docker\" \u003e\u003e development/env.sh\r\n\r\n. development/env.sh\r\ndevelopment/cleanup.sh\r\ndevelopment/refresh_ut3.sh\r\ndevelopment/refresh_sources.sh\r\n\r\n# copying JARs which must not be distributed from my local SQLcl installation\r\ncp /usr/local/bin/sqlcl/lib/ojdbc8.jar utPLSQL-cli/lib\r\ncp /usr/local/bin/sqlcl/lib/orai*.jar utPLSQL-cli/lib\r\n\r\ndevelopment/install.sh\r\ntest/install_and_run_tests.sh\r\n```\r\nthen the results contains unexpected warnings:\r\n```\r\nWarnings:\r\n \r\n  1) utplsql.ut3_tester.core\r\n      Unable to perform automatic rollback after test suite. An implicit or explicit commit/rollback occurred in procedures:\r\n      \r\n      Use the \"--%rollback(manual)\" annotation or remove commit/rollback/ddl statements that are causing the issue.\r\n \r\n  2) utplsql\r\n      Unable to perform automatic rollback after test suite. An implicit or explicit commit/rollback occurred in procedures:\r\n      \r\n      Use the \"--%rollback(manual)\" annotation or remove commit/rollback/ddl statements that are causing the issue.\r\n \r\nFinished in 84.704215 seconds\r\n888 tests, 0 failed, 0 errored, 5 disabled, 2 warning(s)\r\n```\r\n\r\n3. Rerun the tests\r\n\r\n```\r\ncd test\r\ntime . ./${DIR}/run_tests.sh\r\n```\r\n\r\nthen the result is as expected:\r\n```\r\nFinished in 62.915066 seconds\r\n888 tests, 0 failed, 0 errored, 5 disabled, 0 warning(s)\r\n```\r\n\r\n**Expected behavior**\r\n\r\nI expect the results of the subsequent runs also in the first run.","author":{"url":"https://github.com/PhilippSalvisberg","@type":"Person","name":"PhilippSalvisberg"},"datePublished":"2019-07-18T07:08:15.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":9},"url":"https://github.com/982/utPLSQL/issues/982"}