Title: Restricted columns in cursor compare · Issue #997 · utPLSQL/utPLSQL · GitHub
Open Graph Title: Restricted columns in cursor compare · Issue #997 · utPLSQL/utPLSQL
X Title: Restricted columns in cursor compare · Issue #997 · utPLSQL/utPLSQL
Description: Describe the bug Due to the nature of cursor comparison implementation, when comparing cursor containing one of column names: ITEM_DATA DATA_ID ITEM_NO DUP_NO POSITION The cursor comparison fails. Provide version info utPLSQL v3.1.8 To R...
Open Graph Description: Describe the bug Due to the nature of cursor comparison implementation, when comparing cursor containing one of column names: ITEM_DATA DATA_ID ITEM_NO DUP_NO POSITION The cursor comparison fails. ...
X Description: Describe the bug Due to the nature of cursor comparison implementation, when comparing cursor containing one of column names: ITEM_DATA DATA_ID ITEM_NO DUP_NO POSITION The cursor comparison fails. ...
Opengraph URL: https://github.com/utPLSQL/utPLSQL/issues/997
X: @github
Domain: github.com
{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"Restricted columns in cursor compare","articleBody":"**Describe the bug**\r\nDue to the nature of cursor comparison implementation, when comparing cursor containing one of column names:\r\n- ITEM_DATA\r\n- DATA_ID\r\n- ITEM_NO\r\n- DUP_NO\r\n- POSITION\r\n\r\nThe cursor comparison fails.\r\n\r\n**Provide version info**\r\nutPLSQL v3.1.8\r\n\r\n\r\n**To Reproduce**\r\nThis can be observed on 3.1.8 with following block:\r\n```sql\r\nset serverout on\r\ndeclare\r\n l_actual sys_refcursor;\r\n l_expected sys_refcursor;\r\nbegin\r\n open l_actual for select * from all_arguments where rownum = 1;\r\n open l_expected for select * from all_arguments where rownum = 1;\r\n ut.expect(l_actual).to_equal(l_expected);\r\nend;\r\n/\r\n```\r\n\r\n**Expected behavior**\r\n\r\nutPLSQL should not prevent column names that are commonly used / possible to use.\r\n\r\nOne idea would be to use quoted and more unusual names for internal columns in cursor compare: `\"UT3$_Item#Data\"`\r\n\r\n","author":{"url":"https://github.com/jgebal","@type":"Person","name":"jgebal"},"datePublished":"2019-09-22T01:32:43.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":1},"url":"https://github.com/997/utPLSQL/issues/997"}
| 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:274ac768-b2f1-6810-4e44-a88b02298fd7 |
| current-catalog-service-hash | 81bb79d38c15960b92d99bca9288a9108c7a47b18f2423d0f6438c5b7bcd2114 |
| request-id | 8312:11F254:13ADA5F:1C5F213:6A634A34 |
| html-safe-nonce | 63ddaf49b9fcee347b47796bc96c05ef01dab392fc72429c3a1ff845c2fb3cc7 |
| visitor-payload | eyJyZWZlcnJlciI6IiIsInJlcXVlc3RfaWQiOiI4MzEyOjExRjI1NDoxM0FEQTVGOjFDNUYyMTM6NkE2MzRBMzQiLCJ2aXNpdG9yX2lkIjoiMTk5NzMzMTkxNTIzOTI3OTE1NiIsInJlZ2lvbl9lZGdlIjoiaWFkIiwicmVnaW9uX3JlbmRlciI6ImlhZCJ9 |
| visitor-hmac | dbec08d25d6cc93ba37f038244e386135c6effd53649cd5dc409ae64a5aab366 |
| hovercard-subject-tag | issue:496720495 |
| 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/997/issue_layout |
| twitter:image | https://opengraph.githubassets.com/f985d2bba87a91908d7c880dd1c4ced3b3cefc021cb7b23c01e3e6a1105894ab/utPLSQL/utPLSQL/issues/997 |
| twitter:card | summary_large_image |
| og:image | https://opengraph.githubassets.com/f985d2bba87a91908d7c880dd1c4ced3b3cefc021cb7b23c01e3e6a1105894ab/utPLSQL/utPLSQL/issues/997 |
| og:image:alt | Describe the bug Due to the nature of cursor comparison implementation, when comparing cursor containing one of column names: ITEM_DATA DATA_ID ITEM_NO DUP_NO POSITION The cursor comparison fails. ... |
| 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 | 59e55daad7174ca59d63c6974d58276ccb5477442e550bebb3c035e1bef11c94 |
| 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 | 990295d92a4cc7b63fbbd83a046217cd7d77d49c |
| ui-target | full |
| theme-color | #1e2327 |
| color-scheme | light dark |
Links:
Viewport: width=device-width