René's URL Explorer Experiment


Title: left-join-correction by general-kroll-4-life · Pull Request #641 · stackql/stackql · GitHub

Open Graph Title: left-join-correction by general-kroll-4-life · Pull Request #641 · stackql/stackql

X Title: left-join-correction by general-kroll-4-life · Pull Request #641 · stackql/stackql

Description: Description Correction of left join from defective inner join implementation to proper left outer join implementation. Updated robot test Subquery Left Joined With Aliasing and Name Collision. Updated robot test Inner Join Users Cross Cloud Fuzzy Match. Added robot test Inner Join Negative LHS Inline. Added robot test Inner Join Positive LHS Inline. Added robot test Left Join Negative LHS Inline. Added robot test Left Join Positive LHS Inline. Added robot test View Left Join View Returns Results. Added robot test View Left Join Subquery Returns Results. Added robot test View Left Join Materialized View Returns Results. Type of change Bug fix (non-breaking change to fix a bug). Feature (non-breaking change to add functionality). Breaking change. Other (eg: documentation change). Please explain. Issues referenced. Closes #642 Evidence Updated robot test Subquery Left Joined With Aliasing and Name Collision. Updated robot test Inner Join Users Cross Cloud Fuzzy Match. Added robot test Inner Join Negative LHS Inline. Added robot test Inner Join Positive LHS Inline. Added robot test Left Join Negative LHS Inline. Added robot test Left Join Positive LHS Inline. Added robot test View Left Join View Returns Results. Added robot test View Left Join Subquery Returns Results. Added robot test View Left Join Materialized View Returns Results. Checklist: A full round of testing has been completed, and there are no test failures as a result of these changes. The changes are covered with functional and/or integration robot testing. The changes work on all supported platforms. Unit tests pass locally, as per the developer guide. Robot tests pass locally, as per the developer guide. Linter passes locally, as per the developer guide. Variations N/A. Tech Debt No technical debt is added in this change.

Open Graph Description: Description Correction of left join from defective inner join implementation to proper left outer join implementation. Updated robot test Subquery Left Joined With Aliasing and Name Collision. Upd...

X Description: Description Correction of left join from defective inner join implementation to proper left outer join implementation. Updated robot test Subquery Left Joined With Aliasing and Name Collision. Upd...

Opengraph URL: https://github.com/stackql/stackql/pull/641

X: @github

direct link

Domain: github.com

route-pattern/:user_id/:repository/pull/:id/files(.:format)
route-controllerpull_requests
route-actionfiles
fetch-noncev2:193f9ae2-35aa-7509-d09b-3e3d57bac1e9
current-catalog-service-hashae870bc5e265a340912cde392f23dad3671a0a881730ffdadd82f2f57d81641b
request-id9240:6A6D7:23A3B56:32881F2:6A4CE401
html-safe-nonceaf480f8748f2bc03afae8665aba84209a32b6618a95cf09472324c153d428fe2
visitor-payloadeyJyZWZlcnJlciI6IiIsInJlcXVlc3RfaWQiOiI5MjQwOjZBNkQ3OjIzQTNCNTY6MzI4ODFGMjo2QTRDRTQwMSIsInZpc2l0b3JfaWQiOiI4OTQ2OTUzNDQ5NjE1NzEzMjgxIiwicmVnaW9uX2VkZ2UiOiJpYWQiLCJyZWdpb25fcmVuZGVyIjoiaWFkIn0=
visitor-hmac84852299e58f238dae3456d74b32cbaf06dab66f567b2ca3d0dcf543b371139f
hovercard-subject-tagpull_request:3488087450
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/stackql/stackql/pull/641/files
twitter:imagehttps://avatars.githubusercontent.com/u/82620104?s=400&v=4
twitter:cardsummary_large_image
og:imagehttps://avatars.githubusercontent.com/u/82620104?s=400&v=4
og:image:altDescription Correction of left join from defective inner join implementation to proper left outer join implementation. Updated robot test Subquery Left Joined With Aliasing and Name Collision. Upd...
og:site_nameGitHub
og:typeobject
hostnamegithub.com
expected-hostnamegithub.com
None299b43bca6e02ad35197ffeba30d2466846d5fb02ab96fbced5b5e6cec589fb8
turbo-cache-controlno-preview
diff-viewunified
go-importgithub.com/stackql/stackql git https://github.com/stackql/stackql.git
octolytics-dimension-user_id95105302
octolytics-dimension-user_loginstackql
octolytics-dimension-repository_id443987542
octolytics-dimension-repository_nwostackql/stackql
octolytics-dimension-repository_publictrue
octolytics-dimension-repository_is_forkfalse
octolytics-dimension-repository_network_root_id443987542
octolytics-dimension-repository_network_root_nwostackql/stackql
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
releasec5a57f04eeb310f57c73fd6d751d957e2ca27ed2
ui-targetfull
theme-color#1e2327
color-schemelight dark

Links:

Skip to contenthttps://github.com/stackql/stackql/pull/641/files#start-of-content
https://github.com/
Sign in https://github.com/login?return_to=https%3A%2F%2Fgithub.com%2Fstackql%2Fstackql%2Fpull%2F641%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
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/sponsors
Security Labhttps://securitylab.github.com
Maintainer Communityhttps://maintainers.github.com
Acceleratorhttps://github.com/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/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%2Fstackql%2Fstackql%2Fpull%2F641%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=stackql%2Fstackql
Reloadhttps://github.com/stackql/stackql/pull/641/files
Reloadhttps://github.com/stackql/stackql/pull/641/files
Reloadhttps://github.com/stackql/stackql/pull/641/files
Please reload this pagehttps://github.com/stackql/stackql/pull/641/files
stackql https://github.com/stackql
stackqlhttps://github.com/stackql/stackql
Please reload this pagehttps://github.com/stackql/stackql/pull/641/files
Notifications https://github.com/login?return_to=%2Fstackql%2Fstackql
Fork 80 https://github.com/login?return_to=%2Fstackql%2Fstackql
Star 861 https://github.com/login?return_to=%2Fstackql%2Fstackql
Code https://github.com/stackql/stackql
Issues 101 https://github.com/stackql/stackql/issues
Pull requests 1 https://github.com/stackql/stackql/pulls
Discussions https://github.com/stackql/stackql/discussions
Actions https://github.com/stackql/stackql/actions
Projects https://github.com/stackql/stackql/projects
Wiki https://github.com/stackql/stackql/wiki
Security and quality 0 https://github.com/stackql/stackql/security
Insights https://github.com/stackql/stackql/pulse
Code https://github.com/stackql/stackql
Issues https://github.com/stackql/stackql/issues
Pull requests https://github.com/stackql/stackql/pulls
Discussions https://github.com/stackql/stackql/discussions
Actions https://github.com/stackql/stackql/actions
Projects https://github.com/stackql/stackql/projects
Wiki https://github.com/stackql/stackql/wiki
Security and quality https://github.com/stackql/stackql/security
Insights https://github.com/stackql/stackql/pulse
Sign up for GitHub https://github.com/signup?return_to=%2Fstackql%2Fstackql%2Fissues%2Fnew%2Fchoose
terms of servicehttps://docs.github.com/terms
privacy statementhttps://docs.github.com/privacy
Sign inhttps://github.com/login?return_to=%2Fstackql%2Fstackql%2Fissues%2Fnew%2Fchoose
general-kroll-4-lifehttps://github.com/general-kroll-4-life
mainhttps://github.com/stackql/stackql/tree/main
bugfix/left-join-to-outerhttps://github.com/stackql/stackql/tree/bugfix/left-join-to-outer
Conversation 0 https://github.com/stackql/stackql/pull/641
Commits 1 https://github.com/stackql/stackql/pull/641/commits
Checks 19 https://github.com/stackql/stackql/pull/641/checks
Files changed https://github.com/stackql/stackql/pull/641/files
Please reload this pagehttps://github.com/stackql/stackql/pull/641/files
left-join-correction https://github.com/stackql/stackql/pull/641/files#top
Show all changes 1 commit https://github.com/stackql/stackql/pull/641/files
2761acb left-join-correction general-kroll-4-life Apr 4, 2026 https://github.com/stackql/stackql/pull/641/commits/2761acbd86963ca5042fb2643a395b3bd622bedf
Clear filters https://github.com/stackql/stackql/pull/641/files
Please reload this pagehttps://github.com/stackql/stackql/pull/641/files
Please reload this pagehttps://github.com/stackql/stackql/pull/641/files
table_routing.go https://github.com/stackql/stackql/pull/641/files#diff-34d0120e079121c7549e0875f4fa3386e0c081d947b9de703436742fb5b73e31
stackql_mocked_from_cmd_line.robot https://github.com/stackql/stackql/pull/641/files#diff-ddd5b4a2666274a78077aa47ea5ad0161773e4a5d51e2605293b09c99fd0956e
internal/stackql/router/table_routing.gohttps://github.com/stackql/stackql/pull/641/files#diff-34d0120e079121c7549e0875f4fa3386e0c081d947b9de703436742fb5b73e31
View file https://github.com/stackql/stackql/blob/2761acbd86963ca5042fb2643a395b3bd622bedf/internal/stackql/router/table_routing.go
Open in desktop https://desktop.github.com
https://github.co/hiddenchars
https://github.com/stackql/stackql/pull/641/{{ revealButtonHref }}
https://github.com/stackql/stackql/pull/641/files#diff-34d0120e079121c7549e0875f4fa3386e0c081d947b9de703436742fb5b73e31
https://github.com/stackql/stackql/pull/641/files#diff-34d0120e079121c7549e0875f4fa3386e0c081d947b9de703436742fb5b73e31
test/robot/functional/stackql_mocked_from_cmd_line.robothttps://github.com/stackql/stackql/pull/641/files#diff-ddd5b4a2666274a78077aa47ea5ad0161773e4a5d51e2605293b09c99fd0956e
View file https://github.com/stackql/stackql/blob/2761acbd86963ca5042fb2643a395b3bd622bedf/test/robot/functional/stackql_mocked_from_cmd_line.robot
Open in desktop https://desktop.github.com
https://github.co/hiddenchars
https://github.com/stackql/stackql/pull/641/{{ revealButtonHref }}
https://github.com/stackql/stackql/pull/641/files#diff-ddd5b4a2666274a78077aa47ea5ad0161773e4a5d51e2605293b09c99fd0956e
https://github.com/stackql/stackql/pull/641/files#diff-ddd5b4a2666274a78077aa47ea5ad0161773e4a5d51e2605293b09c99fd0956e
https://github.com/stackql/stackql/pull/641/files#diff-ddd5b4a2666274a78077aa47ea5ad0161773e4a5d51e2605293b09c99fd0956e
https://github.com/stackql/stackql/pull/641/files#diff-ddd5b4a2666274a78077aa47ea5ad0161773e4a5d51e2605293b09c99fd0956e
https://github.com/stackql/stackql/pull/641/files#diff-ddd5b4a2666274a78077aa47ea5ad0161773e4a5d51e2605293b09c99fd0956e
https://github.com/stackql/stackql/pull/641/files#diff-ddd5b4a2666274a78077aa47ea5ad0161773e4a5d51e2605293b09c99fd0956e
https://github.com/stackql/stackql/pull/641/files#diff-ddd5b4a2666274a78077aa47ea5ad0161773e4a5d51e2605293b09c99fd0956e
https://github.com/stackql/stackql/pull/641/files#diff-ddd5b4a2666274a78077aa47ea5ad0161773e4a5d51e2605293b09c99fd0956e
https://github.com/stackql/stackql/pull/641/files#diff-ddd5b4a2666274a78077aa47ea5ad0161773e4a5d51e2605293b09c99fd0956e
https://github.com/stackql/stackql/pull/641/files#diff-ddd5b4a2666274a78077aa47ea5ad0161773e4a5d51e2605293b09c99fd0956e
Please reload this pagehttps://github.com/stackql/stackql/pull/641/files
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.