René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"sqlc generate error: table alias \"amounts\" does not exist","articleBody":"### Version\r\n\r\n1.15.0\r\n\r\n### What happened?\r\n\r\nThis sql query does not work.\r\n\r\nI am getting the following error:\r\n\r\n```bash\r\ntable alias \"amounts\" does not exist\r\n```\r\n\r\n### Relevant log output\r\n\r\n```shell\r\ntable alias \"amounts\" does not exist\r\n```\r\n\r\n\r\n### Database schema\r\n\r\n```sql\r\nCREATE TABLE IF NOT EXISTS wallets\r\n(\r\n    id uuid NOT NULL DEFAULT uuid_generate_v4() PRIMARY KEY,\r\n    address VARCHAR(44) NOT NULL,\r\n    type VARCHAR(44) NOT NULL,\r\n    balance DECIMAL(32, 18) NULL\r\n);\r\n```\r\n\r\n\r\n### SQL queries\r\n\r\n```sql\r\n-- name: FindWallets :many\r\nselect id, address, balance, total_balance from \r\n(\r\n\tselect id, address, balance,\r\n\t  sum(balance) over (order by balance desc rows between unbounded preceding and current row) as total_balance,\r\n\t  sum(balance) over (order by balance desc rows between unbounded preceding and current row) - balance as last_balance\r\n\tfrom wallets\r\n\twhere type=$1\r\n) amounts\r\nwhere amounts.last_balance \u003c $2;\r\n```\r\n\r\n\r\n### Configuration\r\n\r\n```yaml\r\nversion: 2\r\nsql:\r\n  - schema: \"sql/migrations\"\r\n    queries: \"sql/queries\"\r\n    engine: \"postgresql\"\r\n    gen:\r\n      go:\r\n        sql_package: \"pgx/v4\"\r\n        out: \"internal/store\"\r\n        emit_prepared_queries: false\r\n        emit_json_tags: true\r\n        emit_exported_queries: false\r\n        emit_db_tags: true\r\n        emit_interface: true\r\n        emit_exact_table_names: false\r\n        emit_empty_slices: true\r\n        emit_result_struct_pointers: true\r\n        emit_params_struct_pointers: false\r\n        emit_enum_valid_method: true\r\n        emit_all_enum_values: true\r\n        overrides:\r\n          - go_type: \"github.com/shopspring/decimal.Decimal\"\r\n            db_type: \"pg_catalog.numeric\"\r\n          - go_type: \"github.com/shopspring/decimal.NullDecimal\"\r\n            db_type: \"pg_catalog.numeric\"\r\n            nullable: true\r\n```\r\n\r\n\r\n### Playground URL\r\n\r\n[https://play.sqlc.dev/p/3011dd28fdcc2ee1e3c0c02e19f0fae102e794177017135f63500e43ee0910fe](https://play.sqlc.dev/p/3011dd28fdcc2ee1e3c0c02e19f0fae102e794177017135f63500e43ee0910fe)\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/sxwebdev","@type":"Person","name":"sxwebdev"},"datePublished":"2022-12-07T07:33:58.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":1},"url":"https://github.com/1990/sqlc/issues/1990"}