René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"LEFT JOIN not generating `Null*` types with table aliases","articleBody":"### Version\r\n\r\n1.15.0\r\n\r\n### What happened?\r\n\r\nsqlc generates incorrect code when using table aliases inside left joins.\r\n#1491 was supposed to fix it, but I'm still able to reproduce it.\r\nThe `StripeID` field should be of type `sql.NullString` but it isn't.\r\n\r\n### Relevant log output\r\n\r\n_No response_\r\n\r\n### Database schema\r\n\r\n```sql\r\nCREATE TABLE users (\r\n\tuser_id uuid primary key  \r\n);\r\n\r\nCREATE TABLE user_stripe_customers\r\n(\r\n    user_id   uuid NOT NULL,\r\n    stripe_id TEXT NOT NULL,\r\n    UNIQUE (user_id, stripe_id)\r\n);\r\nALTER TABLE user_stripe_customers\r\n    ADD FOREIGN KEY (user_id) REFERENCES users (user_id) ON UPDATE CASCADE ON DELETE CASCADE;\r\n```\r\n\r\n\r\n### SQL queries\r\n\r\n```sql\r\n-- name: GetStripeUserByUserID :one\r\nSELECT stripe_id, users.user_id\r\nFROM users\r\n         LEFT JOIN user_stripe_customers ON users.user_id = user_stripe_customers.user_id\r\nWHERE users.user_id = @user_id;\r\n\r\n\r\n-- name: GetStripeUserByUserIDBroken :one\r\nSELECT stripe_id, u.user_id\r\nFROM users u\r\n         LEFT JOIN user_stripe_customers usu ON u.user_id = usu.user_id\r\nWHERE u.user_id = @user_id;\r\n```\r\n\r\n\r\n### Configuration\r\n\r\n```yaml\r\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}\r\n```\r\n\r\n\r\n### Playground URL\r\n\r\nhttps://play.sqlc.dev/p/4827a9efa8fd793d7ee704f877890af04675aa382a3942d0f9807a95ae779cf7\r\n\r\n### What operating system are you using?\r\n\r\nmacOS\r\n\r\n### What database engines are you using?\r\n\r\nPostgreSQL\r\n\r\n### What type of code are you generating?\r\n\r\nGo","author":{"url":"https://github.com/fr3fou","@type":"Person","name":"fr3fou"},"datePublished":"2022-10-13T22:50:48.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":3},"url":"https://github.com/1897/sqlc/issues/1897"}