René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"Materialized View does not enforce columns names - 1.13.0","articleBody":"### Version\n\nOther\n\n### What happened?\n\nWhen compiling, sqlc does not verify that the columns exist in the mat view.\r\n\r\nSee the schema below and the query, the query compiles fine, but running that on the DB throws `column \"earned\" does not exist`\n\n### Relevant log output\n\n_No response_\n\n### Database schema\n\n```sql\nCREATE TABLE kpis (\r\n  ts TIMESTAMPTZ,\r\n  event_id TEXT NOT NULL,\r\n  svc TEXT NOT NULL,\r\n  stage TEXT,\r\n  region TEXT,\r\n  instance TEXT,\r\n  player_id TEXT,\r\n  slip_id TEXT,\r\n  game TEXT,\r\n  data JSONB NOT NULL\r\n);\r\n\r\nCREATE MATERIALIZED VIEW IF NOT EXISTS ten_day_kills\r\nWITH (timescaledb.continuous) AS\r\nSELECT time_bucket(INTERVAL '10 day', ts) AS bucket,\r\n  COUNT(*) AS kill_count,\r\n  (data-\u003e\u003e'winning_player_id')::TEXT pid\r\nFROM kpis\r\nWHERE event_id = 'player.defeated'\r\nGROUP BY pid, bucket\r\n;\n```\n\n\n### SQL queries\n\n```sql\nSELECT COALESCE(SUM(earned), 0) as total_earned\r\nFROM ten_day_kills\r\nWHERE pid = @player_id\r\n;\n```\n\n\n### Configuration\n\n```yaml\nversion: 1\r\npackages:\r\n  - path: \"tsdb\"\r\n    name: \"tsdb\"\r\n    engine: \"postgresql\"\r\n    schema: \"schema.sql\"\r\n    queries: \"./queries/\"\r\n    sql_package: \"pgx/v4\"\n```\n\n\n### Playground URL\n\nhttps://play.sqlc.dev/p/5fa2f34d645dba3e876ff1d17c42a8927cfcb1b3885755abba3604831d8e1010\n\n### What operating system are you using?\n\nmacOS\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/danthegoodman1","@type":"Person","name":"danthegoodman1"},"datePublished":"2022-04-11T19:50:16.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":4},"url":"https://github.com/1545/sqlc/issues/1545"}