René's URL Explorer Experiment


Title: pgx parameter nullability inference bugs · Issue #4336 · sqlc-dev/sqlc · GitHub

Open Graph Title: pgx parameter nullability inference bugs · Issue #4336 · sqlc-dev/sqlc

X Title: pgx parameter nullability inference bugs · Issue #4336 · sqlc-dev/sqlc

Description: Version 1.30.0 What happened? Sqlc’s parameter nullability inference is inconsistent in many cases in the current implementation. The expected rule appears to be: Nullable parameters should always use nullable types Non-null parameters s...

Open Graph Description: Version 1.30.0 What happened? Sqlc’s parameter nullability inference is inconsistent in many cases in the current implementation. The expected rule appears to be: Nullable parameters should always ...

X Description: Version 1.30.0 What happened? Sqlc’s parameter nullability inference is inconsistent in many cases in the current implementation. The expected rule appears to be: Nullable parameters should always ...

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

X: @github

direct link

Domain: github.com


Hey, it has json ld scripts:
{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"pgx parameter nullability inference bugs","articleBody":"### Version\n\n1.30.0\n\n### What happened?\n\nSqlc’s parameter nullability inference is inconsistent in many cases in the current implementation.\n\nThe expected rule appears to be:\n- Nullable parameters should always use nullable types\n- Non-null parameters should always use non-null types\n- `sqlc.narg(...)` is the explicit way to force a nullable parameter\n\nIn the docs:\n- \"sqlc infers the nullability of any specified parameters, and often does exactly what you want. If you want finer control over the nullability of your parameters, you may use `sqlc.narg()`\"\n- \"for structs, null values are represented using the appropriate type from the database/sql or pgx package.\"\n\nThere are many correct e2e tests that handle nullability correctly but also some that don't.\n\nWe of course want parameters to match the types in structs by default. If you have `pgtype.Int4` while really that parameter is NOT NULL, that's dangerous. I found multiple occurrences of this but only when `sqlc.yaml` included `pgx`. I don’t see a convincing non-pgx nullability bug in the e2e tests\n\nIn `internal/endtoend/testdata/insert_select_param/postgresql/pgx/`:\n```sql\n-- schema.sql\nCREATE TABLE authors (\n  id   BIGSERIAL PRIMARY KEY,\n  name text      NOT NULL,\n  bio  text\n);\n```\n\n```sql\n-- query.sql\n-- name: InsertSelect :exec\nINSERT INTO authors (id, name, bio) \nSELECT @id, name, bio\nFROM authors\nWHERE name = @name;\n```\n\n```sql\n-- query.sql\n-- name: InsertSelect :exec\nINSERT INTO authors (id, name, bio) \nSELECT @id, name, bio\nFROM authors\nWHERE name = @name;\n```\n\n```go\n// query.sql.go\npackage querytest\n\nimport (\n\t\"context\"\n\n\t\"github.com/jackc/pgx/v5/pgtype\"\n)\n\nconst insertSelect = `-- name: InsertSelect :exec\nINSERT INTO authors (id, name, bio) \nSELECT $1, name, bio\nFROM authors\nWHERE name = $2\n`\n\ntype InsertSelectParams struct {\n\tID   pgtype.Int8\n\tName pgtype.Text\n}\n\nfunc (q *Queries) InsertSelect(ctx context.Context, arg InsertSelectParams) error {\n\t_, err := q.db.Exec(ctx, insertSelect, arg.ID, arg.Name)\n\treturn err\n}\n```\n\nClearly we see that `name` is supposed to be NOT NULL and yet it takes on the type `pgtype.Text`. The same thing happens in `nested_select`, `select_subquery`, and `unnest_star`.\n\n### Relevant log output\n\n```shell\n\n```\n\n### Database schema\n\n```sql\n\n```\n\n### SQL queries\n\n```sql\n\n```\n\n### Configuration\n\n```yaml\n\n```\n\n### Playground URL\n\n_No response_\n\n### What operating system are you using?\n\n_No response_\n\n### What database engines are you using?\n\n_No response_\n\n### What type of code are you generating?\n\n_No response_","author":{"url":"https://github.com/qykr","@type":"Person","name":"qykr"},"datePublished":"2026-03-11T08:25:26Z","url":"https://github.com/sqlc-dev/sqlc/issues/4336"}

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:148b6d02-5641-2ee2-c4f3-6f40280a6d26
current-catalog-service-hash81bb79d38c15960b92d99bca9288a9108c7a47b18f2423d0f6438c5b7bcd2114
request-idA2FE:14ECB:251FF4D:2F28BC8:6B018B72
html-safe-nonce18a7c32ed82b61d18b46e173d859e6d8ac9a8b1b5add8286d7e2de32012cf816
visitor-payloadeyJyZWZlcnJlciI6IiIsInJlcXVlc3RfaWQiOiJBMkZFOjE0RUNCOjI1MUZGNEQ6MkYyOEJDODo2QjAxOEI3MiIsInZpc2l0b3JfaWQiOiIyNzgxMjY2OTM0MDA2NjQ3NjY2IiwicmVnaW9uX2VkZ2UiOiJpYWQiLCJyZWdpb25fcmVuZGVyIjoiaWFkIn0=
visitor-hmac0795582f460bedf1051922d69c3344097fc74fd83d72563cb533f2e507a73f84
hovercard-subject-tagissue:4056687476
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/4336/issue_layout
twitter:imagehttps://opengraph.githubassets.com/61c2285dab8f68ff29fd6f0d1064434ccd351aed7afbe8ef914be863f9966382/sqlc-dev/sqlc/issues/4336
twitter:cardsummary_large_image
og:imagehttps://opengraph.githubassets.com/61c2285dab8f68ff29fd6f0d1064434ccd351aed7afbe8ef914be863f9966382/sqlc-dev/sqlc/issues/4336
og:image:altVersion 1.30.0 What happened? Sqlc’s parameter nullability inference is inconsistent in many cases in the current implementation. The expected rule appears to be: Nullable parameters should always ...
og:image:width1200
og:image:height600
og:site_nameGitHub
og:typeobject
og:author:usernameqykr
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/4336#start-of-content
https://github.com/
Sign inhttps://github.com/login?return_to=https%3A%2F%2Fgithub.com%2Fsqlc-dev%2Fsqlc%2Fissues%2F4336
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%2F4336
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/4336
Reloadhttps://github.com/sqlc-dev/sqlc/issues/4336
Reloadhttps://github.com/sqlc-dev/sqlc/issues/4336
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/4336
New issuehttps://github.com/login?return_to=https://github.com/sqlc-dev/sqlc/issues/4336
pgx parameter nullability inference bugshttps://github.com/sqlc-dev/sqlc/issues/4336#top
📚 postgresqlhttps://github.com/sqlc-dev/sqlc/issues?q=state%3Aopen%20label%3A%22%3Abooks%3A%20postgresql%22
🔧 golanghttps://github.com/sqlc-dev/sqlc/issues?q=state%3Aopen%20label%3A%22%3Awrench%3A%20golang%22
bugSomething isn't workinghttps://github.com/sqlc-dev/sqlc/issues?q=state%3Aopen%20label%3A%22bug%22
https://github.com/qykr
qykrhttps://github.com/qykr
on Mar 11, 2026https://github.com/sqlc-dev/sqlc/issues/4336#issue-4056687476
qykrhttps://github.com/qykr
bugSomething isn't workinghttps://github.com/sqlc-dev/sqlc/issues?q=state%3Aopen%20label%3A%22bug%22
on Mar 11, 2026https://github.com/sqlc-dev/sqlc/issues/4336#event-23461057269
qykrhttps://github.com/qykr
on Mar 11, 2026https://github.com/sqlc-dev/sqlc/issues/4336#event-23461088062
dosubothttps://github.com/apps/dosubot
📚 postgresqlhttps://github.com/sqlc-dev/sqlc/issues?q=state%3Aopen%20label%3A%22%3Abooks%3A%20postgresql%22
🔧 golanghttps://github.com/sqlc-dev/sqlc/issues?q=state%3Aopen%20label%3A%22%3Awrench%3A%20golang%22
on Mar 11, 2026https://github.com/sqlc-dev/sqlc/issues/4336#event-23461153487
Sign up for freehttps://github.com/signup?return_to=https://github.com/sqlc-dev/sqlc/issues/4336
Sign in to commenthttps://github.com/login?return_to=https://github.com/sqlc-dev/sqlc/issues/4336
📚 postgresqlhttps://github.com/sqlc-dev/sqlc/issues?q=state%3Aopen%20label%3A%22%3Abooks%3A%20postgresql%22
🔧 golanghttps://github.com/sqlc-dev/sqlc/issues?q=state%3Aopen%20label%3A%22%3Awrench%3A%20golang%22
bugSomething isn't workinghttps://github.com/sqlc-dev/sqlc/issues?q=state%3Aopen%20label%3A%22bug%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.