René's URL Explorer Experiment


Title: SELECT WITH query with multiple table aliases in FROM get ignored, only last one considered · Issue #1237 · sqlc-dev/sqlc · GitHub

Open Graph Title: SELECT WITH query with multiple table aliases in FROM get ignored, only last one considered · Issue #1237 · sqlc-dev/sqlc

X Title: SELECT WITH query with multiple table aliases in FROM get ignored, only last one considered · Issue #1237 · sqlc-dev/sqlc

Description: Version 1.10.0 What happened? When selecting with SELECT WITH with multiple table aliases in the FROM statement, only the last one on the statements list gets considered. Given the query, we're expecting to select everything from both c1...

Open Graph Description: Version 1.10.0 What happened? When selecting with SELECT WITH with multiple table aliases in the FROM statement, only the last one on the statements list gets considered. Given the query, we're exp...

X Description: Version 1.10.0 What happened? When selecting with SELECT WITH with multiple table aliases in the FROM statement, only the last one on the statements list gets considered. Given the query, we're...

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

X: @github

direct link

Domain: github.com


Hey, it has json ld scripts:
{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"SELECT WITH query with multiple table aliases in FROM get ignored, only last one considered","articleBody":"### Version\n\n1.10.0\n\n### What happened?\n\nWhen selecting with `SELECT WITH` with multiple table aliases in the FROM statement, only the last one on the statements list gets considered.\r\n\r\nGiven the query, we're expecting to select everything from both c1 and c2, but the generated query only selects from c2:\r\n\r\n```sql\r\nWITH\r\n\tq\r\n\t\tAS (\r\n\t\t\tSELECT\r\n\t\t\t\tauthors.name, authors.bio\r\n\t\t\tFROM\r\n\t\t\t\tauthors\r\n\t\t\t\tLEFT JOIN fake ON authors.name = fake.name\r\n\t\t)\r\nSELECT\r\n\tc2.name, c2.bio, c2.name, c2.bio\r\nFROM\r\n\tq AS c1,\r\n\tq as c2\r\n```\n\n### Relevant log output\n\n_No response_\n\n### Database schema\n\n```sql\nCREATE TABLE authors (\r\n  id   BIGSERIAL PRIMARY KEY,\r\n  name text      NOT NULL,\r\n  bio  text\r\n);\r\n\r\nCREATE TABLE fake (\r\n  id   BIGSERIAL PRIMARY KEY,\r\n  name text      NOT NULL,\r\n  bio  text\r\n);\n```\n\n\n### SQL queries\n\n```sql\n-- name: BadQuery :exec\r\nWITH\r\n\tq\r\n\t\tAS (\r\n\t\t\tSELECT\r\n\t\t\t\tauthors.name, authors.bio\r\n\t\t\tFROM\r\n\t\t\t\tauthors\r\n\t\t\t\tLEFT JOIN fake ON authors.name = fake.name\r\n\t\t)\r\nSELECT\r\n\t*\r\nFROM\r\n\tq AS c1,\r\n\tq as c2;\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\": \"postgresql\",\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/79910ee88639b38cdbcbbefeccb1e1a55b8492776ed7fd0a4bbb617217411d46\n\n### What operating system are you using?\n\nLinux\n\n### What database engines are you using?\n\nPostgreSQL\n\n### What type of code are you generating?\n\nGo","author":{"url":"https://github.com/gsora","@type":"Person","name":"gsora"},"datePublished":"2021-10-14T11:57:01Z","url":"https://github.com/sqlc-dev/sqlc/issues/1237"}

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:509ffd2a-496c-50db-b242-f8b033d69a95
current-catalog-service-hash81bb79d38c15960b92d99bca9288a9108c7a47b18f2423d0f6438c5b7bcd2114
request-idC87C:2D2F2F:2581A80:2FE14BE:6B017E63
html-safe-nonce90b2be798b988ba9a87fdfaadcb1fb9c477c4e611dcc1bbc290f0511d11f2bb4
visitor-payloadeyJyZWZlcnJlciI6IiIsInJlcXVlc3RfaWQiOiJDODdDOjJEMkYyRjoyNTgxQTgwOjJGRTE0QkU6NkIwMTdFNjMiLCJ2aXNpdG9yX2lkIjoiOTExNjQyNDE0ODkzNDAzMjk5NSIsInJlZ2lvbl9lZGdlIjoiaWFkIiwicmVnaW9uX3JlbmRlciI6ImlhZCJ9
visitor-hmaca05f924bafd65758539dd98bf18dee0ba3748dfe254d4d46f0560c1f8959bc7a
hovercard-subject-tagissue:1026307432
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/1237/issue_layout
twitter:imagehttps://opengraph.githubassets.com/f722331a5d5e8cfca605749206c9ae79badbfbd9efd109fac25a499e3547f83f/sqlc-dev/sqlc/issues/1237
twitter:cardsummary_large_image
og:imagehttps://opengraph.githubassets.com/f722331a5d5e8cfca605749206c9ae79badbfbd9efd109fac25a499e3547f83f/sqlc-dev/sqlc/issues/1237
og:image:altVersion 1.10.0 What happened? When selecting with SELECT WITH with multiple table aliases in the FROM statement, only the last one on the statements list gets considered. Given the query, we're exp...
og:image:width1200
og:image:height600
og:site_nameGitHub
og:typeobject
og:author:usernamegsora
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/1237#start-of-content
https://github.com/
Sign inhttps://github.com/login?return_to=https%3A%2F%2Fgithub.com%2Fsqlc-dev%2Fsqlc%2Fissues%2F1237
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%2F1237
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/1237
Reloadhttps://github.com/sqlc-dev/sqlc/issues/1237
Reloadhttps://github.com/sqlc-dev/sqlc/issues/1237
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/1237
New issuehttps://github.com/login?return_to=https://github.com/sqlc-dev/sqlc/issues/1237
SELECT WITH query with multiple table aliases in FROM get ignored, only last one consideredhttps://github.com/sqlc-dev/sqlc/issues/1237#top
📚 postgresqlhttps://github.com/sqlc-dev/sqlc/issues?q=state%3Aopen%20label%3A%22%3Abooks%3A%20postgresql%22
💻 linuxhttps://github.com/sqlc-dev/sqlc/issues?q=state%3Aopen%20label%3A%22%3Acomputer%3A%20linux%22
🔧 golanghttps://github.com/sqlc-dev/sqlc/issues?q=state%3Aopen%20label%3A%22%3Awrench%3A%20golang%22
analyzerhttps://github.com/sqlc-dev/sqlc/issues?q=state%3Aopen%20label%3A%22analyzer%22
bugSomething isn't workinghttps://github.com/sqlc-dev/sqlc/issues?q=state%3Aopen%20label%3A%22bug%22
https://github.com/gsora
gsorahttps://github.com/gsora
on Oct 14, 2021https://github.com/sqlc-dev/sqlc/issues/1237#issue-1026307432
https://play.sqlc.dev/p/79910ee88639b38cdbcbbefeccb1e1a55b8492776ed7fd0a4bbb617217411d46https://play.sqlc.dev/p/79910ee88639b38cdbcbbefeccb1e1a55b8492776ed7fd0a4bbb617217411d46
gsorahttps://github.com/gsora
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 14, 2021https://github.com/sqlc-dev/sqlc/issues/1237#event-5463299372
kyleconroyhttps://github.com/kyleconroy
📚 postgresqlhttps://github.com/sqlc-dev/sqlc/issues?q=state%3Aopen%20label%3A%22%3Abooks%3A%20postgresql%22
💻 linuxhttps://github.com/sqlc-dev/sqlc/issues?q=state%3Aopen%20label%3A%22%3Acomputer%3A%20linux%22
🔧 golanghttps://github.com/sqlc-dev/sqlc/issues?q=state%3Aopen%20label%3A%22%3Awrench%3A%20golang%22
triageNew issues that hasn't been reviewedhttps://github.com/sqlc-dev/sqlc/issues?q=state%3Aopen%20label%3A%22triage%22
on Jan 26, 2022https://github.com/sqlc-dev/sqlc/issues/1237#event-5954274022
kyleconroyhttps://github.com/kyleconroy
analyzerhttps://github.com/sqlc-dev/sqlc/issues?q=state%3Aopen%20label%3A%22analyzer%22
on Sep 22, 2023https://github.com/sqlc-dev/sqlc/issues/1237#event-10449976132
kyleconroyhttps://github.com/kyleconroy
on Oct 10, 2023https://github.com/sqlc-dev/sqlc/issues/1237#event-10597098876
Fix #1237https://github.com/sqlc-dev/sqlc/commit/3b2ec9f5439a0d8b2106c4f50076de289817eda0
#1237https://github.com/sqlc-dev/sqlc/issues/1237
https://docs.github.com/articles/closing-issues-via-commit-messages
3b2ec9fhttps://github.com/sqlc-dev/sqlc/commit/3b2ec9f5439a0d8b2106c4f50076de289817eda0
https://github.com/kyleconroy
kyleconroyhttps://github.com/kyleconroy
on Oct 24, 2023https://github.com/sqlc-dev/sqlc/issues/1237#issuecomment-1778178384
v1.23.0https://docs.sqlc.dev/en/latest/reference/changelog.html#v1-23-0
database-backed query analyzerhttps://docs.sqlc.dev/en/latest/howto/generate.html#enhanced-analysis-with-managed-databases
test casehttps://github.com/sqlc-dev/sqlc/tree/main/internal/endtoend/testdata/cte_multiple_alias/postgresql/pgx
working example on the playgroundhttps://play.sqlc.dev/p/59274775fd3b74646afdb47eb9c212eca86d5e8134a3e1a52f704b0a73cf7f13
kyleconroyhttps://github.com/kyleconroy
completedhttps://github.com/sqlc-dev/sqlc/issues?q=is%3Aissue%20state%3Aclosed%20archived%3Afalse%20reason%3Acompleted
on Oct 24, 2023https://github.com/sqlc-dev/sqlc/issues/1237#event-10760122906
Sign up for freehttps://github.com/signup?return_to=https://github.com/sqlc-dev/sqlc/issues/1237
Sign in to commenthttps://github.com/login?return_to=https://github.com/sqlc-dev/sqlc/issues/1237
📚 postgresqlhttps://github.com/sqlc-dev/sqlc/issues?q=state%3Aopen%20label%3A%22%3Abooks%3A%20postgresql%22
💻 linuxhttps://github.com/sqlc-dev/sqlc/issues?q=state%3Aopen%20label%3A%22%3Acomputer%3A%20linux%22
🔧 golanghttps://github.com/sqlc-dev/sqlc/issues?q=state%3Aopen%20label%3A%22%3Awrench%3A%20golang%22
analyzerhttps://github.com/sqlc-dev/sqlc/issues?q=state%3Aopen%20label%3A%22analyzer%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.