René's URL Explorer Experiment


Title: MySQL: LEFT OUTER JOINed columns not considered NULLable · Issue #1247 · sqlc-dev/sqlc · GitHub

Open Graph Title: MySQL: LEFT OUTER JOINed columns not considered NULLable · Issue #1247 · sqlc-dev/sqlc

X Title: MySQL: LEFT OUTER JOINed columns not considered NULLable · Issue #1247 · sqlc-dev/sqlc

Description: Version 1.10.0 What happened? When I join another table using LEFT OUTER JOIN, the referenced colums are not treated as potential NULL. For example, int32 is used instead of sql.NullInt32 Relevant log output No response Database schema C...

Open Graph Description: Version 1.10.0 What happened? When I join another table using LEFT OUTER JOIN, the referenced colums are not treated as potential NULL. For example, int32 is used instead of sql.NullInt32 Relevant ...

X Description: Version 1.10.0 What happened? When I join another table using LEFT OUTER JOIN, the referenced colums are not treated as potential NULL. For example, int32 is used instead of sql.NullInt32 Relevant ...

Opengraph URL: https://github.com/sqlc-dev/sqlc/issues/1247

X: @github

direct link

Domain: github.com


Hey, it has json ld scripts:
{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"MySQL: LEFT OUTER JOINed columns not considered NULLable","articleBody":"### Version\n\n1.10.0\n\n### What happened?\n\nWhen I join another table using `LEFT OUTER JOIN`, the referenced colums are not treated as potential `NULL`.\r\n\r\nFor example, `int32` is used instead of `sql.NullInt32`\r\n\n\n### Relevant log output\n\n_No response_\n\n### Database schema\n\n```sql\nCREATE TABLE authors\r\n(\r\n    id INT(10) NOT NULL,\r\n    name VARCHAR(255) NOT NULL,\r\n    parent_id INT(10),\r\n    PRIMARY KEY (id)\r\n);\r\n\r\nCREATE TABLE parents\r\n(\r\n    id INT(10) NOT NULL,\r\n    name VARCHAR(255) NOT NULL,\r\n    PRIMARY KEY (id)\r\n);\n```\n\n\n### SQL queries\n\n```sql\n-- name: AllAuthors :many\r\nSELECT authors.id,\r\n       authors.name,\r\n       parents.id as alias_id,\r\n       parents.name as alias_name\r\nFROM authors LEFT OUTER JOIN parents ON (authors.parent_id = parents.id);\n```\n\n\n### Configuration\n\n```yaml\n{\r\n  \"version\": \"1\",\r\n  \"packages\": [\r\n    {\r\n      \"path\": \"db\",\r\n      \"engine\": \"mysql\",\r\n      \"schema\": \"query.sql\",\r\n      \"queries\": \"query.sql\"\r\n    }\r\n  ]\r\n}\n```\n\n\n### Playground URL\n\nhttps://play.sqlc.dev/p/ce7fec524f816ea7f485c8d9b83c60a0e36c7de065db7d23150d7271ce59bd90\n\n### What operating system are you using?\n\nmacOS\n\n### What database engines are you using?\n\nMySQL\n\n### What type of code are you generating?\n\nGo","author":{"url":"https://github.com/Funzinator","@type":"Person","name":"Funzinator"},"datePublished":"2021-10-22T12:09:34Z","url":"https://github.com/sqlc-dev/sqlc/issues/1247"}

react-profiling0
react-import-mapreact,react-dom,react-dom/client,react-dom/profiling,react-is,react/compiler-runtime,react/jsx-dev-runtime,react/jsx-runtime,scheduler@b8488ee2c322
route-pattern/_view_fragments/issues/show/:user_id/:repository/:id/issue_layout(.:format)
route-controllervoltron_issues_fragments
route-actionissue_layout
fetch-noncev2:8add0cbf-cf09-6a01-d690-41e02eb6749a
current-catalog-service-hash81bb79d38c15960b92d99bca9288a9108c7a47b18f2423d0f6438c5b7bcd2114
request-idC36C:38C5CF:27415A9:31CEB3E:6B017AAB
html-safe-nonceb15bdb59af473d1da0f7e9359d726151a320b4bac809bdaeec4e9ea1fe46ad13
visitor-payloadeyJyZWZlcnJlciI6IiIsInJlcXVlc3RfaWQiOiJDMzZDOjM4QzVDRjoyNzQxNUE5OjMxQ0VCM0U6NkIwMTdBQUIiLCJ2aXNpdG9yX2lkIjoiMTg0NjY2NjE2NzYwNzk4Mjc2MyIsInJlZ2lvbl9lZGdlIjoiaWFkIiwicmVnaW9uX3JlbmRlciI6ImlhZCJ9
visitor-hmacdcfb291c42e305496a87d083348469a0c0dcbbed1ef494bb776e801937d28385
hovercard-subject-tagissue:1033512693
github-keyboard-shortcutsrepository,issues,copilot
google-site-verificationApib7-x98H0j5cPqHWwSMm6dNU4GmODRoqxLiDzdx9I
octolytics-urlhttps://collector.github.com/github/collect
analytics-location///voltron/issues_fragments/issue_layout
fb:app_id1401488693436528
apple-itunes-appapp-id=1477376905, app-argument=https://github.com/_view_fragments/issues/show/sqlc-dev/sqlc/1247/issue_layout
twitter:imagehttps://opengraph.githubassets.com/e8eab80f01b43620fe03c0fe5f98d89be0488c8915bd37731e9beb98bba74edc/sqlc-dev/sqlc/issues/1247
twitter:cardsummary_large_image
og:imagehttps://opengraph.githubassets.com/e8eab80f01b43620fe03c0fe5f98d89be0488c8915bd37731e9beb98bba74edc/sqlc-dev/sqlc/issues/1247
og:image:altVersion 1.10.0 What happened? When I join another table using LEFT OUTER JOIN, the referenced colums are not treated as potential NULL. For example, int32 is used instead of sql.NullInt32 Relevant ...
og:image:width1200
og:image:height600
og:site_nameGitHub
og:typeobject
og:author:usernameFunzinator
hostnamegithub.com
expected-hostnamegithub.com
Nonecc5dfdd32f62ebd3223cab3af3aa2b268d3605218237326a48a99d1efd89495c
turbo-cache-controlno-preview
go-importgithub.com/sqlc-dev/sqlc git https://github.com/sqlc-dev/sqlc.git
octolytics-dimension-user_id136738596
octolytics-dimension-user_loginsqlc-dev
octolytics-dimension-repository_id193160679
octolytics-dimension-repository_nwosqlc-dev/sqlc
octolytics-dimension-repository_publictrue
octolytics-dimension-repository_is_forkfalse
octolytics-dimension-repository_network_root_id193160679
octolytics-dimension-repository_network_root_nwosqlc-dev/sqlc
turbo-body-classeslogged-out env-production page-responsive
disable-turbofalse
browser-stats-urlhttps://api.github.com/_private/browser/stats
browser-errors-urlhttps://api.github.com/_private/browser/errors
release8c77c9e8439031ad54c75a250694842892f693e1
ui-targetfull
theme-color#1e2327
color-schemelight dark
react-app-nameissues

Links:

Skip to contenthttps://github.com/sqlc-dev/sqlc/issues/1247#start-of-content
https://github.com/
Sign inhttps://github.com/login?return_to=https%3A%2F%2Fgithub.com%2Fsqlc-dev%2Fsqlc%2Fissues%2F1247
GitHubRepository hosting, code review, and collaborationhttps://github.com/platform
CopilotAI coding agent for tasks, projects, and automated workhttps://github.com/features/copilot
ActionsCI/CD and automationhttps://github.com/features/actions
Code QualityQuality analysis, fixes, and enforcementhttps://github.com/features/code-quality
CodespacesCloud development environmentshttps://github.com/features/codespaces
Code SecurityVulnerability detection and remediationhttps://github.com/security/advanced-security/code-security
Secret ProtectionSecret scanning and leak preventionhttps://github.com/security/advanced-security/secret-protection
All Featureshttps://github.com/features
Documentationhttps://docs.github.com/en
Traininghttps://learn.github.com/skills
Certificationshttps://learn.github.com/credentials
Build with Copilothttps://github.com/features/ai
Customize Copilothttps://docs.github.com/en/copilot/how-tos/copilot-on-github/customize-copilot/customize-copilot-overview
Integrationshttps://github.com/marketplace
Trending reposhttps://github.com/trending
GitHub Sponsorshttps://github.com/open-source/sponsors
Developer articleshttps://github.com/resources/articles
ChangelogYour source for the latest features, improvements, and fixes across GitHub products, all in one place.https://github.blog/changelog/
Enterpriseshttps://github.com/enterprise
Teamhttps://github.com/team
Startupshttps://github.com/enterprise/startups
Nonprofitshttps://github.com/solutions/industry/nonprofits
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
See all industrieshttps://github.com/solutions/industry
Why GitHubhttps://github.com/why-github
Customer Storieshttps://github.com/customer-stories
Business insightshttps://github.com/solutions/executive-insights
Trust Centerhttps://github.com/trust-center
GitHub Advanced SecurityEnterprise-grade code securityhttps://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
Documentationhttps://docs.github.com/en
Resource centerhttps://github.com/resources
Bloghttps://github.blog/
Events & webinarshttps://github.com/resources/events
Community Forumhttps://github.com/orgs/community/discussions
Customer Storieshttps://github.com/customer-stories
Integrationshttps://github.com/marketplace
Customer supporthttps://help.github.com/
Traininghttps://learn.github.com/skills
GitHub Statushttps://www.githubstatus.com/
Abouthttps://github.com/about
Partnershttps://github.com/partners
Changeloghttps://github.blog/changelog/
GitHub UniverseThe event for developers, by developers — talks, workshops, and what’s next for GitHub.https://githubuniverse.com/
Pricinghttps://github.com/pricing
Sign inhttps://github.com/login?return_to=https%3A%2F%2Fgithub.com%2Fsqlc-dev%2Fsqlc%2Fissues%2F1247
Sign uphttps://github.com/signup?ref_cta=Sign+up&ref_loc=header+logged+out&ref_page=%2F%3Cuser-name%3E%2F%3Crepo-name%3E%2Fvoltron%2Fissues_fragments%2Fissue_layout&source=header-repo&source_repo=sqlc-dev%2Fsqlc
Reloadhttps://github.com/sqlc-dev/sqlc/issues/1247
Reloadhttps://github.com/sqlc-dev/sqlc/issues/1247
Reloadhttps://github.com/sqlc-dev/sqlc/issues/1247
sqlc-devhttps://github.com/sqlc-dev
sqlchttps://github.com/sqlc-dev/sqlc
Codehttps://github.com/sqlc-dev/sqlc
Issues600 (600)https://github.com/sqlc-dev/sqlc/issues
Pull requests132 (132)https://github.com/sqlc-dev/sqlc/pulls
Discussionshttps://github.com/sqlc-dev/sqlc/discussions
Actionshttps://github.com/sqlc-dev/sqlc/actions
Projectshttps://github.com/sqlc-dev/sqlc/projects
Security and qualityhttps://github.com/sqlc-dev/sqlc/security
Insightshttps://github.com/sqlc-dev/sqlc/insights
https://github.com/sqlc-dev/sqlc
New issuehttps://github.com/login?return_to=https://github.com/sqlc-dev/sqlc/issues/1247
New issuehttps://github.com/login?return_to=https://github.com/sqlc-dev/sqlc/issues/1247
MySQL: LEFT OUTER JOINed columns not considered NULLablehttps://github.com/sqlc-dev/sqlc/issues/1247#top
bugSomething isn't workinghttps://github.com/sqlc-dev/sqlc/issues?q=state%3Aopen%20label%3A%22bug%22
triageNew issues that hasn't been reviewedhttps://github.com/sqlc-dev/sqlc/issues?q=state%3Aopen%20label%3A%22triage%22
https://github.com/Funzinator
Funzinatorhttps://github.com/Funzinator
on Oct 22, 2021https://github.com/sqlc-dev/sqlc/issues/1247#issue-1033512693
https://play.sqlc.dev/p/ce7fec524f816ea7f485c8d9b83c60a0e36c7de065db7d23150d7271ce59bd90https://play.sqlc.dev/p/ce7fec524f816ea7f485c8d9b83c60a0e36c7de065db7d23150d7271ce59bd90
Funzinatorhttps://github.com/Funzinator
bugSomething isn't workinghttps://github.com/sqlc-dev/sqlc/issues?q=state%3Aopen%20label%3A%22bug%22
triageNew issues that hasn't been reviewedhttps://github.com/sqlc-dev/sqlc/issues?q=state%3Aopen%20label%3A%22triage%22
on Oct 22, 2021https://github.com/sqlc-dev/sqlc/issues/1247#event-5504471501
https://github.com/Funzinator
Funzinatorhttps://github.com/Funzinator
on Nov 4, 2021https://github.com/sqlc-dev/sqlc/issues/1247#issuecomment-960513879
@timstuddhttps://github.com/timstudd
#1237https://github.com/sqlc-dev/sqlc/issues/1237
examplehttps://play.sqlc.dev/p/cffeef39709f61e77413bc75ae15cfed67965d99a22b1470365cb4fb62bd29fa
https://github.com/Funzinator
Funzinatorhttps://github.com/Funzinator
on Nov 4, 2021https://github.com/sqlc-dev/sqlc/issues/1247#issuecomment-961216320
Funzinatorhttps://github.com/Funzinator
completedhttps://github.com/sqlc-dev/sqlc/issues?q=is%3Aissue%20state%3Aclosed%20archived%3Afalse%20reason%3Acompleted
on Nov 4, 2021https://github.com/sqlc-dev/sqlc/issues/1247#event-5569544776
Sign up for freehttps://github.com/signup?return_to=https://github.com/sqlc-dev/sqlc/issues/1247
Sign in to commenthttps://github.com/login?return_to=https://github.com/sqlc-dev/sqlc/issues/1247
bugSomething isn't workinghttps://github.com/sqlc-dev/sqlc/issues?q=state%3Aopen%20label%3A%22bug%22
triageNew issues that hasn't been reviewedhttps://github.com/sqlc-dev/sqlc/issues?q=state%3Aopen%20label%3A%22triage%22
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.