René's URL Explorer Experiment


Title: Refactored expectations on compound data by jgebal · Pull Request #1043 · utPLSQL/utPLSQL · GitHub

Open Graph Title: Refactored expectations on compound data by jgebal · Pull Request #1043 · utPLSQL/utPLSQL

X Title: Refactored expectations on compound data by jgebal · Pull Request #1043 · utPLSQL/utPLSQL

Description: With this change the reporting of differences is unified across: unordered, ordered and join_by comparison. Up until now, when using unordered or join_by the differences were reported column by column as opposed to diff of entire row in one-line, as it is when using default data-set compare method. This was making reports hard to read and interpret. Also signal-to-noise ration was pretty bad, as each new line was repeating join_by columns. The change addresses this issue. Additionally, unordered_columns diff report is now showing expected and actual columns in the same order for rows that contain differences. You may see the differences by looking into changed test lines

Open Graph Description: With this change the reporting of differences is unified across: unordered, ordered and join_by comparison. Up until now, when using unordered or join_by the differences were reported column by col...

X Description: With this change the reporting of differences is unified across: unordered, ordered and join_by comparison. Up until now, when using unordered or join_by the differences were reported column by col...

Opengraph URL: https://github.com/utPLSQL/utPLSQL/pull/1043

X: @github

direct link

Domain: github.com

route-pattern/:user_id/:repository/pull/:id/files(.:format)
route-controllerpull_requests
route-actionfiles
fetch-noncev2:47c398f1-b850-a57f-4c84-68946bbcb9de
current-catalog-service-hashae870bc5e265a340912cde392f23dad3671a0a881730ffdadd82f2f57d81641b
request-idC46A:1CCA7D:FEFCF:16D109:6A636297
html-safe-nonce95576a7f651619b4aff58805e782a863eb81225e55718d68c71f28dd4c5afab7
visitor-payloadeyJyZWZlcnJlciI6IiIsInJlcXVlc3RfaWQiOiJDNDZBOjFDQ0E3RDpGRUZDRjoxNkQxMDk6NkE2MzYyOTciLCJ2aXNpdG9yX2lkIjoiNTc5ODgyNzQwMTg3MjEwNjEzNSIsInJlZ2lvbl9lZGdlIjoiaWFkIiwicmVnaW9uX3JlbmRlciI6ImlhZCJ9
visitor-hmac0c84c6d8dd706167838c14ba849072acf6429bfb0b434de23e605a9a8858deac
hovercard-subject-tagpull_request:375722026
github-keyboard-shortcutsrepository,pull-request-list,pull-request-conversation,pull-request-files-changed,copilot
google-site-verificationApib7-x98H0j5cPqHWwSMm6dNU4GmODRoqxLiDzdx9I
octolytics-urlhttps://collector.github.com/github/collect
analytics-location///pull_requests/show/files
fb:app_id1401488693436528
apple-itunes-appapp-id=1477376905, app-argument=https://github.com/utPLSQL/utPLSQL/pull/1043/files
twitter:imagehttps://avatars.githubusercontent.com/u/1398171?s=400&v=4
twitter:cardsummary_large_image
og:imagehttps://avatars.githubusercontent.com/u/1398171?s=400&v=4
og:image:altWith this change the reporting of differences is unified across: unordered, ordered and join_by comparison. Up until now, when using unordered or join_by the differences were reported column by col...
og:site_nameGitHub
og:typeobject
hostnamegithub.com
expected-hostnamegithub.com
None669d3fcd704a169521d2b6431762f95a6878a9e8ccaf0fd5f2d0802fc5b971f9
turbo-cache-controlno-preview
diff-viewunified
go-importgithub.com/utPLSQL/utPLSQL git https://github.com/utPLSQL/utPLSQL.git
octolytics-dimension-user_id15661281
octolytics-dimension-user_loginutPLSQL
octolytics-dimension-repository_id50728220
octolytics-dimension-repository_nwoutPLSQL/utPLSQL
octolytics-dimension-repository_publictrue
octolytics-dimension-repository_is_forkfalse
octolytics-dimension-repository_network_root_id50728220
octolytics-dimension-repository_network_root_nwoutPLSQL/utPLSQL
turbo-body-classeslogged-out env-production page-responsive full-width
disable-turbotrue
browser-stats-urlhttps://api.github.com/_private/browser/stats
browser-errors-urlhttps://api.github.com/_private/browser/errors
release20da292f132ff51328be50073854259f417052c1
ui-targetfull
theme-color#1e2327
color-schemelight dark

Links:

Skip to contenthttps://github.com/utPLSQL/utPLSQL/pull/1043/files#start-of-content
https://github.com/
Sign in https://github.com/login?return_to=https%3A%2F%2Fgithub.com%2FutPLSQL%2FutPLSQL%2Fpull%2F1043%2Ffiles
GitHub CopilotWrite better code with AIhttps://github.com/features/copilot
GitHub Copilot appDirect agents from issue to mergehttps://github.com/features/ai/github-app
MCP RegistryNewIntegrate external toolshttps://github.com/mcp
ActionsAutomate any workflowhttps://github.com/features/actions
CodespacesInstant dev environmentshttps://github.com/features/codespaces
IssuesPlan and track workhttps://github.com/features/issues
Code ReviewManage code changeshttps://github.com/features/code-review
Code QualityEnforce quality at mergehttps://github.com/features/code-quality
GitHub Advanced SecurityFind and fix vulnerabilitieshttps://github.com/security/advanced-security
Code securitySecure your code as you buildhttps://github.com/security/advanced-security/code-security
Secret protectionStop leaks before they starthttps://github.com/security/advanced-security/secret-protection
Why GitHubhttps://github.com/why-github
Documentationhttps://docs.github.com
Bloghttps://github.blog
Changeloghttps://github.blog/changelog
Marketplacehttps://github.com/marketplace
View all featureshttps://github.com/features
Enterpriseshttps://github.com/enterprise
Small and medium teamshttps://github.com/team
Startupshttps://github.com/enterprise/startups
Nonprofitshttps://github.com/solutions/industry/nonprofits
App Modernizationhttps://github.com/solutions/use-case/app-modernization
DevSecOpshttps://github.com/solutions/use-case/devsecops
DevOpshttps://github.com/solutions/use-case/devops
CI/CDhttps://github.com/solutions/use-case/ci-cd
View all use caseshttps://github.com/solutions/use-case
Healthcarehttps://github.com/solutions/industry/healthcare
Financial serviceshttps://github.com/solutions/industry/financial-services
Manufacturinghttps://github.com/solutions/industry/manufacturing
Governmenthttps://github.com/solutions/industry/government
View all industrieshttps://github.com/solutions/industry
View all solutionshttps://github.com/solutions
AIhttps://github.com/resources/articles?topic=ai
Software Developmenthttps://github.com/resources/articles?topic=software-development
DevOpshttps://github.com/resources/articles?topic=devops
Securityhttps://github.com/resources/articles?topic=security
View all topicshttps://github.com/resources/articles
Customer storieshttps://github.com/customer-stories
Events & webinarshttps://github.com/resources/events
Ebooks & reportshttps://github.com/resources/whitepapers
Business insightshttps://github.com/solutions/executive-insights
GitHub Skillshttps://skills.github.com
Documentationhttps://docs.github.com
Customer supporthttps://support.github.com
Community forumhttps://github.com/orgs/community/discussions
Trust centerhttps://github.com/trust-center
Partnershttps://github.com/partners
View all resourceshttps://github.com/resources
GitHub SponsorsFund open source developershttps://github.com/open-source/sponsors
Security Labhttps://securitylab.github.com
Maintainer Communityhttps://maintainers.github.com
Acceleratorhttps://github.com/open-source/accelerator
GitHub Starshttps://stars.github.com
Archive Programhttps://archiveprogram.github.com
Topicshttps://github.com/topics
Trendinghttps://github.com/trending
Collectionshttps://github.com/collections
Enterprise platformAI-powered developer platformhttps://github.com/enterprise
GitHub Advanced SecurityEnterprise-grade security featureshttps://github.com/security/advanced-security
Copilot for BusinessEnterprise-grade AI featureshttps://github.com/features/copilot/copilot-business
Premium SupportEnterprise-grade 24/7 supporthttps://github.com/enterprise/premium-support
Pricinghttps://github.com/pricing
Search syntax tipshttps://docs.github.com/search-github/github-code-search/understanding-github-code-search-syntax
documentationhttps://docs.github.com/search-github/github-code-search/understanding-github-code-search-syntax
Sign in https://github.com/login?return_to=https%3A%2F%2Fgithub.com%2FutPLSQL%2FutPLSQL%2Fpull%2F1043%2Ffiles
Sign up https://github.com/signup?ref_cta=Sign+up&ref_loc=header+logged+out&ref_page=%2F%3Cuser-name%3E%2F%3Crepo-name%3E%2Fpull_requests%2Fshow%2Ffiles&source=header-repo&source_repo=utPLSQL%2FutPLSQL
Reloadhttps://github.com/utPLSQL/utPLSQL/pull/1043/files
Reloadhttps://github.com/utPLSQL/utPLSQL/pull/1043/files
Reloadhttps://github.com/utPLSQL/utPLSQL/pull/1043/files
Please reload this pagehttps://github.com/utPLSQL/utPLSQL/pull/1043/files
utPLSQL https://github.com/utPLSQL
utPLSQLhttps://github.com/utPLSQL/utPLSQL
Notifications https://github.com/login?return_to=%2FutPLSQL%2FutPLSQL
Fork 188 https://github.com/login?return_to=%2FutPLSQL%2FutPLSQL
Star 619 https://github.com/login?return_to=%2FutPLSQL%2FutPLSQL
Code https://github.com/utPLSQL/utPLSQL
Issues 12 https://github.com/utPLSQL/utPLSQL/issues
Pull requests 0 https://github.com/utPLSQL/utPLSQL/pulls
Discussions https://github.com/utPLSQL/utPLSQL/discussions
Actions https://github.com/utPLSQL/utPLSQL/actions
Projects https://github.com/utPLSQL/utPLSQL/projects
Security and quality 0 https://github.com/utPLSQL/utPLSQL/security
Insights https://github.com/utPLSQL/utPLSQL/pulse
Code https://github.com/utPLSQL/utPLSQL
Issues https://github.com/utPLSQL/utPLSQL/issues
Pull requests https://github.com/utPLSQL/utPLSQL/pulls
Discussions https://github.com/utPLSQL/utPLSQL/discussions
Actions https://github.com/utPLSQL/utPLSQL/actions
Projects https://github.com/utPLSQL/utPLSQL/projects
Security and quality https://github.com/utPLSQL/utPLSQL/security
Insights https://github.com/utPLSQL/utPLSQL/pulse
Sign up for GitHub https://github.com/signup?return_to=%2FutPLSQL%2FutPLSQL%2Fissues%2Fnew%2Fchoose
terms of servicehttps://docs.github.com/terms
privacy statementhttps://docs.github.com/privacy
Sign inhttps://github.com/login?return_to=%2FutPLSQL%2FutPLSQL%2Fissues%2Fnew%2Fchoose
jgebalhttps://github.com/jgebal
develophttps://github.com/utPLSQL/utPLSQL/tree/develop
feature/unify_cursor_compare_behaviorhttps://github.com/utPLSQL/utPLSQL/tree/feature/unify_cursor_compare_behavior
Conversation 1 https://github.com/utPLSQL/utPLSQL/pull/1043
Commits 3 https://github.com/utPLSQL/utPLSQL/pull/1043/commits
Checks 0 https://github.com/utPLSQL/utPLSQL/pull/1043/checks
Files changed https://github.com/utPLSQL/utPLSQL/pull/1043/files
Please reload this pagehttps://github.com/utPLSQL/utPLSQL/pull/1043/files
Refactored expectations on compound data https://github.com/utPLSQL/utPLSQL/pull/1043/files#top
Show all changes 3 commits https://github.com/utPLSQL/utPLSQL/pull/1043/files
1b0b8f8 Refactored expectations on compound data jgebal Feb 15, 2020 https://github.com/utPLSQL/utPLSQL/pull/1043/commits/1b0b8f8c616356a211005f11a8960eac5300a57c
94f9c43 Merge remote-tracking branch 'origin/develop' into feature/unify_curs… jgebal Feb 15, 2020 https://github.com/utPLSQL/utPLSQL/pull/1043/commits/94f9c4340e1b9369a90d92e8010acdcf18ba291c
054c39f Fixed issues with new cursor-results compare query on 11g jgebal Feb 16, 2020 https://github.com/utPLSQL/utPLSQL/pull/1043/commits/054c39fb522fd456aeb39545d395bb840296db7c
Clear filters https://github.com/utPLSQL/utPLSQL/pull/1043/files
Please reload this pagehttps://github.com/utPLSQL/utPLSQL/pull/1043/files
Please reload this pagehttps://github.com/utPLSQL/utPLSQL/pull/1043/files
ut_compound_data_helper.pkb https://github.com/utPLSQL/utPLSQL/pull/1043/files#diff-8811cce086e40120fd3e8aba9c101f3e2d7378a5e7b1bfba40100ec1a3dbd102
test_expectation_anydata.pkb https://github.com/utPLSQL/utPLSQL/pull/1043/files#diff-f80dd2ead716ccd9eea8ce8f44b0f784b871841b5baf0b882f510b042145ac4c
test_expectations_cursor.pkb https://github.com/utPLSQL/utPLSQL/pull/1043/files#diff-9f0b34d5caa30b779c823bc67ec9b5032d45c1ed39321cb7bf89ae6769d63ecf
source/expectations/data_values/ut_compound_data_helper.pkbhttps://github.com/utPLSQL/utPLSQL/pull/1043/files#diff-8811cce086e40120fd3e8aba9c101f3e2d7378a5e7b1bfba40100ec1a3dbd102
View file https://github.com/utPLSQL/utPLSQL/blob/054c39fb522fd456aeb39545d395bb840296db7c/source/expectations/data_values/ut_compound_data_helper.pkb
Open in desktop https://desktop.github.com
https://github.co/hiddenchars
https://github.com/utPLSQL/utPLSQL/pull/1043/{{ revealButtonHref }}
https://github.com/utPLSQL/utPLSQL/pull/1043/files#diff-8811cce086e40120fd3e8aba9c101f3e2d7378a5e7b1bfba40100ec1a3dbd102
https://github.com/utPLSQL/utPLSQL/pull/1043/files#diff-8811cce086e40120fd3e8aba9c101f3e2d7378a5e7b1bfba40100ec1a3dbd102
https://github.com/utPLSQL/utPLSQL/pull/1043/files#diff-8811cce086e40120fd3e8aba9c101f3e2d7378a5e7b1bfba40100ec1a3dbd102
https://github.com/utPLSQL/utPLSQL/pull/1043/files#diff-8811cce086e40120fd3e8aba9c101f3e2d7378a5e7b1bfba40100ec1a3dbd102
https://github.com/utPLSQL/utPLSQL/pull/1043/files#diff-8811cce086e40120fd3e8aba9c101f3e2d7378a5e7b1bfba40100ec1a3dbd102
https://github.com/utPLSQL/utPLSQL/pull/1043/files#diff-8811cce086e40120fd3e8aba9c101f3e2d7378a5e7b1bfba40100ec1a3dbd102
test/ut3_user/expectations/test_expectation_anydata.pkbhttps://github.com/utPLSQL/utPLSQL/pull/1043/files#diff-f80dd2ead716ccd9eea8ce8f44b0f784b871841b5baf0b882f510b042145ac4c
View file https://github.com/utPLSQL/utPLSQL/blob/054c39fb522fd456aeb39545d395bb840296db7c/test/ut3_user/expectations/test_expectation_anydata.pkb
Open in desktop https://desktop.github.com
https://github.co/hiddenchars
https://github.com/utPLSQL/utPLSQL/pull/1043/{{ revealButtonHref }}
https://github.com/utPLSQL/utPLSQL/pull/1043/files#diff-f80dd2ead716ccd9eea8ce8f44b0f784b871841b5baf0b882f510b042145ac4c
https://github.com/utPLSQL/utPLSQL/pull/1043/files#diff-f80dd2ead716ccd9eea8ce8f44b0f784b871841b5baf0b882f510b042145ac4c
test/ut3_user/expectations/test_expectations_cursor.pkbhttps://github.com/utPLSQL/utPLSQL/pull/1043/files#diff-9f0b34d5caa30b779c823bc67ec9b5032d45c1ed39321cb7bf89ae6769d63ecf
View file https://github.com/utPLSQL/utPLSQL/blob/054c39fb522fd456aeb39545d395bb840296db7c/test/ut3_user/expectations/test_expectations_cursor.pkb
Open in desktop https://desktop.github.com
https://github.co/hiddenchars
https://github.com/utPLSQL/utPLSQL/pull/1043/{{ revealButtonHref }}
https://github.com/utPLSQL/utPLSQL/pull/1043/files#diff-9f0b34d5caa30b779c823bc67ec9b5032d45c1ed39321cb7bf89ae6769d63ecf
https://github.com/utPLSQL/utPLSQL/pull/1043/files#diff-9f0b34d5caa30b779c823bc67ec9b5032d45c1ed39321cb7bf89ae6769d63ecf
https://github.com/utPLSQL/utPLSQL/pull/1043/files#diff-9f0b34d5caa30b779c823bc67ec9b5032d45c1ed39321cb7bf89ae6769d63ecf
https://github.com/utPLSQL/utPLSQL/pull/1043/files#diff-9f0b34d5caa30b779c823bc67ec9b5032d45c1ed39321cb7bf89ae6769d63ecf
https://github.com/utPLSQL/utPLSQL/pull/1043/files#diff-9f0b34d5caa30b779c823bc67ec9b5032d45c1ed39321cb7bf89ae6769d63ecf
https://github.com/utPLSQL/utPLSQL/pull/1043/files#diff-9f0b34d5caa30b779c823bc67ec9b5032d45c1ed39321cb7bf89ae6769d63ecf
https://github.com/utPLSQL/utPLSQL/pull/1043/files#diff-9f0b34d5caa30b779c823bc67ec9b5032d45c1ed39321cb7bf89ae6769d63ecf
https://github.com/utPLSQL/utPLSQL/pull/1043/files#diff-9f0b34d5caa30b779c823bc67ec9b5032d45c1ed39321cb7bf89ae6769d63ecf
https://github.com/utPLSQL/utPLSQL/pull/1043/files#diff-9f0b34d5caa30b779c823bc67ec9b5032d45c1ed39321cb7bf89ae6769d63ecf
https://github.com/utPLSQL/utPLSQL/pull/1043/files#diff-9f0b34d5caa30b779c823bc67ec9b5032d45c1ed39321cb7bf89ae6769d63ecf
https://github.com/utPLSQL/utPLSQL/pull/1043/files#diff-9f0b34d5caa30b779c823bc67ec9b5032d45c1ed39321cb7bf89ae6769d63ecf
https://github.com/utPLSQL/utPLSQL/pull/1043/files#diff-9f0b34d5caa30b779c823bc67ec9b5032d45c1ed39321cb7bf89ae6769d63ecf
https://github.com
Termshttps://docs.github.com/site-policy/github-terms/github-terms-of-service
Privacyhttps://docs.github.com/site-policy/privacy-policies/github-privacy-statement
Securityhttps://github.com/security
Statushttps://www.githubstatus.com/
Communityhttps://github.community/
Docshttps://docs.github.com/
Contacthttps://support.github.com?tags=dotcom-footer

Viewport: width=device-width


URLs of crawlers that visited me.