Title: Issue · GitHub
Open Graph Title: Issue · utPLSQL/utPLSQL
X Title: Issue · utPLSQL/utPLSQL
Description: Testing Framework for PL/SQL. Contribute to utPLSQL/utPLSQL development by creating an account on GitHub.
Open Graph Description: Testing Framework for PL/SQL. Contribute to utPLSQL/utPLSQL development by creating an account on GitHub.
X Description: Testing Framework for PL/SQL. Contribute to utPLSQL/utPLSQL development by creating an account on GitHub.
Opengraph URL: https://github.com/utPLSQL/utPLSQL
X: @github
Domain: github.com
{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"Extra information for failed tests in results output","articleBody":"**Describe the bug**\r\nIn addition to test results call stack is displayed for failed tests:\r\n\r\n```\r\nSQL\u003e exec ut.run('test_betwnstr')\r\nBetween string function\r\nReturns substring from start position to end position [.34 sec] (FAILED - 1)\r\nFailures:\r\n1) basic_usage\r\nActual: '234' (varchar2) was expected to equal: '2345' (varchar2)\r\n00007FF8267345Eat \"TEST_BETWNSTR.BASIC_USAGE\", line 0\r\n00007FF81C9685Aat \"anonymous block\", line 0\r\n00007FF8267FBFCat \"SYS.DBMS_SQL.EXECUTE\", line 8\r\n00007FF852BCFCat \"UT3.UT_EXECUTABLE.DO_EXECUTE\", line 68\r\n00007FF852BCFCat \"UT3.UT_EXECUTABLE.DO_EXECUTE\", line 68\r\n00007FF8512F9Aat \"UT3.UT_EXECUTABLE_TEST.DO_EXECUTE\", line 90\r\n00007FF8512F9Aat \"UT3.UT_EXECUTABLE_TEST.DO_EXECUTE\", line 90\r\n00007FF8231Aat \"UT3.UT_TEST.DO_EXECUTE\", line 2088\r\n00007FF81FF207Bat \"UT3.UT_SUITE_ITEM.DO_EXECUTE\", line 0\r\n00007FF852Cat \"UT3.UT_SUITE.DO_EXECUTE\", line 83270\r\n00007FF82165F3Bat \"UT3.UT_RUN.DO_EXECUTE\", line 0\r\n00007FF81FF207Bat \"UT3.UT_SUITE_ITEM.DO_EXECUTE\", line 0\r\n00007FF8266285Cat \"UT3.UT_RUNNER.RUN\", line 0\r\n00007FFat \"UT3.UT.RUN_AUTONOMOUS\", line 854710538\r\n00007FFat \"UT3.UT.RUN\", line 854710538\r\n00007FFat \"UT3.UT.RUN\", line 854710538\r\n00007FF852F8Bat \"anonymous block\", line 710\r\nFinished in .349 seconds\r\n1 tests, 1 failed, 0 errored, 0 disabled, 0 warning(s)\r\n```\r\n\r\n**Provide version info**\r\nInformation about utPLSQL and Database version, \r\n```sql\r\nl_version: 18.0.0.0.0\r\nl_compatibility: 12.2.0\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.3190\r\n\r\nSQL\u003e select banner from v$version;\r\n\r\nBANNER\r\n--------------------------------------------------------------------------------\r\nOracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production\r\n\r\nSQL\u003e select * from nls_session_parameters;\r\n\r\nPARAMETER VALUE\r\n------------------------------ ------------------------------\r\nNLS_LANGUAGE AMERICAN\r\nNLS_TERRITORY AMERICA\r\nNLS_CURRENCY $\r\nNLS_ISO_CURRENCY AMERICA\r\nNLS_NUMERIC_CHARACTERS .,\r\nNLS_CALENDAR GREGORIAN\r\nNLS_DATE_FORMAT DD-MON-RR\r\nNLS_DATE_LANGUAGE AMERICAN\r\nNLS_SORT BINARY\r\nNLS_TIME_FORMAT HH.MI.SSXFF AM\r\nNLS_TIMESTAMP_FORMAT DD-MON-RR HH.MI.SSXFF AM\r\nNLS_TIME_TZ_FORMAT HH.MI.SSXFF AM TZR\r\nNLS_TIMESTAMP_TZ_FORMAT DD-MON-RR HH.MI.SSXFF AM TZR\r\nNLS_DUAL_CURRENCY $\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\nIBMPC/WIN_NT64-9.1.0\r\n```\r\n\r\n**Information about client software**\r\nSQL*Plus\r\n\r\n**Expected behavior**\r\nExpect the output to look like in 3.1.7:\r\n\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.7.3096\r\n\r\nSQL\u003e exec ut.run('test_betwnstr')\r\nBetween string function\r\nReturns substring from start position to end position [.014 sec] (FAILED - 1)\r\nFailures:\r\n1) basic_usage\r\nActual: '234' (varchar2) was expected to equal: '2345' (varchar2)\r\nat \"TEST_BETWNSTR.BASIC_USAGE\", line 5 ut.expect( betwnstr( '1234567', 2, 5 ) ).to_equal('2345');\r\nFinished in .016 seconds\r\n1 tests, 1 failed, 0 errored, 0 disabled, 0 warning(s)\r\n```\r\n","author":{"url":"https://github.com/abasharin","@type":"Person","name":"abasharin"},"datePublished":"2019-09-27T00:36:03.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":6},"url":"https://github.com/1000/utPLSQL/issues/1000"}
| route-pattern | /:user_id/:repository/issues/:id(.:format) |
| route-controller | issues |
| route-action | show |
| fetch-nonce | v2:512ef33f-c264-9945-111d-04475f12bc6d |
| current-catalog-service-hash | 81bb79d38c15960b92d99bca9288a9108c7a47b18f2423d0f6438c5b7bcd2114 |
| request-id | D9B6:250BDC:512A15:78717D:6A634A7F |
| html-safe-nonce | 06ffc1d5a9c49ea6279940988797dde26810a6379b11c72699e106b7a2bd24b1 |
| visitor-payload | eyJyZWZlcnJlciI6IiIsInJlcXVlc3RfaWQiOiJEOUI2OjI1MEJEQzo1MTJBMTU6Nzg3MTdEOjZBNjM0QTdGIiwidmlzaXRvcl9pZCI6IjQwNDI5NzA5MTUwMDk2Nzc5NTEiLCJyZWdpb25fZWRnZSI6Indlc3R1czIiLCJyZWdpb25fcmVuZGVyIjoid2VzdHVzMiJ9 |
| visitor-hmac | f3e255c440140a5e5d67745501215bbdf4c460c2c5e10615b38803ea49d26e0f |
| hovercard-subject-tag | repository:50728220 |
| github-keyboard-shortcuts | repository,issues,copilot |
| google-site-verification | Apib7-x98H0j5cPqHWwSMm6dNU4GmODRoqxLiDzdx9I |
| octolytics-url | https://collector.github.com/github/collect |
| analytics-location | / |
| fb:app_id | 1401488693436528 |
| apple-itunes-app | app-id=1477376905, app-argument=https://github.com/utPLSQL/utPLSQL/issues/1000 |
| twitter:image | https://repository-images.githubusercontent.com/50728220/4935a380-d65f-11e9-9eb9-3536c94be03a |
| twitter:card | summary_large_image |
| og:image | https://repository-images.githubusercontent.com/50728220/4935a380-d65f-11e9-9eb9-3536c94be03a |
| og:image:alt | Testing Framework for PL/SQL. Contribute to utPLSQL/utPLSQL development by creating an account on GitHub. |
| og:site_name | GitHub |
| og:type | object |
| hostname | github.com |
| expected-hostname | github.com |
| None | 59e55daad7174ca59d63c6974d58276ccb5477442e550bebb3c035e1bef11c94 |
| turbo-cache-control | no-cache |
| go-import | github.com/utPLSQL/utPLSQL git https://github.com/utPLSQL/utPLSQL.git |
| octolytics-dimension-user_id | 15661281 |
| octolytics-dimension-user_login | utPLSQL |
| octolytics-dimension-repository_id | 50728220 |
| octolytics-dimension-repository_nwo | utPLSQL/utPLSQL |
| octolytics-dimension-repository_public | true |
| octolytics-dimension-repository_is_fork | false |
| octolytics-dimension-repository_network_root_id | 50728220 |
| octolytics-dimension-repository_network_root_nwo | utPLSQL/utPLSQL |
| turbo-body-classes | logged-out env-production page-responsive |
| disable-turbo | false |
| browser-stats-url | https://api.github.com/_private/browser/stats |
| browser-errors-url | https://api.github.com/_private/browser/errors |
| release | 990295d92a4cc7b63fbbd83a046217cd7d77d49c |
| ui-target | full |
| theme-color | #1e2327 |
| color-scheme | light dark |
Links:
Viewport: width=device-width