René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"column does not exists (when an alias)","articleBody":"### Version\n\n1.14.0\n\n### What happened?\n\n\r\nthe above query does not compile using sqlc generate.\r\n\r\n\n\n### Relevant log output\n\n```shell\n# package orm\r\nqueries/users.sql:8:5: column \"rank_email\" does not exist\n```\n\n\n### Database schema\n\n```sql\nCREATE EXTENSION pg_trgm;\r\nCREATE EXTENSION pgcrypto;\r\n\r\nCREATE TABLE users(\r\n    id INT GENERATED ALWAYS AS IDENTITY NOT NULL,\r\n    fname VARCHAR(100) NOT NULL,\r\n    lname VARCHAR(100) NOT NULL,\r\n    email VARCHAR(100) NOT NULL UNIQUE,\r\n    enc_passwd TEXT NOT NULL,\r\n    created_at TIMESTAMP WITH TIME ZONE NOT NULL default (NOW() AT TIME ZONE 'utc'),\r\n    PRIMARY KEY(id)\r\n);\n```\n\n\n### SQL queries\n\n```sql\nSELECT \r\n    users.id,\r\n    users.fname,\r\n    users.lname,\r\n    users.email,\r\n    users.created_at,\r\n    rank_email,\r\n    rank_fname,\r\n    rank_lname,\r\n    similarity\r\nFROM \r\n    users, \r\n    to_tsvector(users.email || users.fname || users.lname) document,\r\n    to_tsquery(@search_term::TEXT) query,\r\n    NULLIF(ts_rank(to_tsvector(users.email), query), 0) rank_email,\r\n    NULLIF(ts_rank(to_tsvector(users.fname), query), 0) rank_fname,\r\n    NULLIF(ts_rank(to_tsvector(users.lname), query), 0) rank_lname,\r\n    SIMILARITY(@search_term::TEXT, users.email || users.fname || users.lname) similarity\r\nWHERE query @@ document OR similarity \u003e 0\r\nORDER BY rank_email, rank_lname, rank_fname, similarity DESC NULLS LAST;\n```\n\n\n### Configuration\n\n```yaml\nversion: \"2\"\r\nsql:\r\n- schema: \"migrations\"\r\n  queries: \"queries\"\r\n  engine: \"postgresql\"\r\n  gen:\r\n    go: \r\n      package: \"orm\"\r\n      out: \"orm\"\r\n      sql_package: \"pgx/v4\"\n```\n\n\n### Playground URL\n\nhttps://play.sqlc.dev/p/3935699fa944c07c82d9e0c5cfdd84e95ffd315c62e09a3801bf9209d5f29e81\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/gosom","@type":"Person","name":"gosom"},"datePublished":"2022-07-10T14:43:56.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":8},"url":"https://github.com/1739/sqlc/issues/1739"}