Title: Failure when comparing nested objects · Issue #1082 · utPLSQL/utPLSQL · GitHub
Open Graph Title: Failure when comparing nested objects · Issue #1082 · utPLSQL/utPLSQL
X Title: Failure when comparing nested objects · Issue #1082 · utPLSQL/utPLSQL
Description: Describe the bug When comparing nested objects the comparison fails with an exception. Provide version info utPLSQL 3.1.10 - any database Information about client software not applicable To Reproduce Run the below script create or replac...
Open Graph Description: Describe the bug When comparing nested objects the comparison fails with an exception. Provide version info utPLSQL 3.1.10 - any database Information about client software not applicable To Reprodu...
X Description: Describe the bug When comparing nested objects the comparison fails with an exception. Provide version info utPLSQL 3.1.10 - any database Information about client software not applicable To Reprodu...
Opengraph URL: https://github.com/utPLSQL/utPLSQL/issues/1082
X: @github
Domain: github.com
{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"Failure when comparing nested objects","articleBody":"**Describe the bug**\r\nWhen comparing nested objects the comparison fails with an exception.\r\n\r\n\r\n**Provide version info**\r\n`utPLSQL 3.1.10` - any database\r\n\r\n\r\n**Information about client software**\r\nnot applicable\r\n\r\n**To Reproduce**\r\n\r\nRun the below script\r\n```sql\r\ncreate or replace type some_value as object(\r\n the_value number,\r\n is_relative integer(1)\r\n);\r\n\r\ncreate or replace type some_item as object (\r\n first_value some_value,\r\n second_value some_value\r\n);\r\n\r\ndeclare\r\n l_expected some_item;\r\n l_actual some_item;\r\nbegin\r\n l_expected := some_item(some_value( 1, 0 ), some_value(2.22, 1));\r\n l_actual := some_item(some_value( 1, 0 ), some_value(2.22, 0));\r\n ut.expect(anydata.convertObject(l_actual)).to_equal(anydata.convertObject(l_expected));\r\nend;\r\n/\r\n```\r\nSee the exception:\r\n```\r\nORA-00902: invalid datatype\r\nORA-06512: at \"UT3.UT_DATA_VALUE_REFCURSOR\", line 336\r\nORA-06512: at \"UT3.UT_COMPOUND_DATA_HELPER\", line 628\r\nORA-06512: at \"UT3.UT_DATA_VALUE_REFCURSOR\", line 328\r\nORA-06512: at \"UT3.UT_DATA_VALUE_REFCURSOR\", line 384\r\nORA-06512: at \"UT3.UT_DATA_VALUE_ANYDATA\", line 129\r\nORA-06512: at \"UT3.UT_EQUAL\", line 229\r\nORA-06512: at \"UT3.UT_EXPECTATION\", line 26\r\nORA-06512: at \"UT3.UT_EXPECTATION\", line 96\r\nORA-06512: at line 7\r\n```\r\n\r\n\r\n**Expected behavior**\r\n\r\nThe expectation should report data differences.\r\n\r\n**Additional context**\r\n\r\nThe behavior seem to show up when the object contains nested objects.\r\n\r\n","author":{"url":"https://github.com/jgebal","@type":"Person","name":"jgebal"},"datePublished":"2020-06-21T22:04:58.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":0},"url":"https://github.com/1082/utPLSQL/issues/1082"}
| route-pattern | /_view_fragments/issues/show/:user_id/:repository/:id/issue_layout(.:format) |
| route-controller | voltron_issues_fragments |
| route-action | issue_layout |
| fetch-nonce | v2:8fb386f6-844c-8c80-3d8e-334995c183ca |
| current-catalog-service-hash | 81bb79d38c15960b92d99bca9288a9108c7a47b18f2423d0f6438c5b7bcd2114 |
| request-id | 9704:176919:5F3D73:86948D:6A638304 |
| html-safe-nonce | d5cc098d062b1b2b3beaee8700108ba714831c1f8e23b412a85b0572fea1b368 |
| visitor-payload | eyJyZWZlcnJlciI6IiIsInJlcXVlc3RfaWQiOiI5NzA0OjE3NjkxOTo1RjNENzM6ODY5NDhEOjZBNjM4MzA0IiwidmlzaXRvcl9pZCI6IjM2NjU4NjgyODUyOTUxNjYyMTIiLCJyZWdpb25fZWRnZSI6ImlhZCIsInJlZ2lvbl9yZW5kZXIiOiJpYWQifQ== |
| visitor-hmac | 99d80cbfa8499fe6b3b53db2c8f24f3ad2545234c868fcbbc88147e53e19cbd4 |
| hovercard-subject-tag | issue:642649539 |
| 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/_view_fragments/issues/show/utPLSQL/utPLSQL/1082/issue_layout |
| twitter:image | https://opengraph.githubassets.com/3375eee3ff6c6f40f17391fb3fa6bd0e2e42c2d1fbfb3a739122631b14eb6d46/utPLSQL/utPLSQL/issues/1082 |
| twitter:card | summary_large_image |
| og:image | https://opengraph.githubassets.com/3375eee3ff6c6f40f17391fb3fa6bd0e2e42c2d1fbfb3a739122631b14eb6d46/utPLSQL/utPLSQL/issues/1082 |
| og:image:alt | Describe the bug When comparing nested objects the comparison fails with an exception. Provide version info utPLSQL 3.1.10 - any database Information about client software not applicable To Reprodu... |
| og:image:width | 1200 |
| og:image:height | 600 |
| og:site_name | GitHub |
| og:type | object |
| og:author:username | jgebal |
| hostname | github.com |
| expected-hostname | github.com |
| None | e4fb64aef87da454ec25b158147f7f5f14aef29216e5ca1612c2e48faa599d1f |
| turbo-cache-control | no-preview |
| 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 | e839936ba5faffb9c836dda1cf4729d50c88a32e |
| ui-target | full |
| theme-color | #1e2327 |
| color-scheme | light dark |
Links:
Viewport: width=device-width