Closed
Description
Version
1.20.0
What happened?
Upgraded to sqlc 1.20.0 and a view that was previously compiling under 1.18.0 now creates an error column reference "name" is ambiguous
-- `union` works in sqlc 1.18.0, 1.19.0 and 1.19.1
create view all_staff as
select name, lname, pos from employees
union
select name, lname, title as pos from managers;
Also, while investigating this bug noticed that union
and union all
have different error handling in versions prior to 1.20.0.
Relevant log output
# package db
query.sql:15:12: column reference "name" is ambiguous
Database schema
create table employees (
name text,
lname text,
pos text
);
create table managers (
name text,
lname text,
title text
);
SQL queries
No response
Configuration
No response
Playground URL
https://play.sqlc.dev/p/48bae081f4aec4493fb0f202219c82267c25358eace80b7841679034b1c1a82d
What operating system are you using?
Linux
What database engines are you using?
SQLite
What type of code are you generating?
Go