Skip to content

DBSP: JOIN USING should deduplicate columns #3362

@jussisaurio

Description

@jussisaurio
turso> create table t(a);create table u(a);create table v(a);
turso> insert into t select * from generate_series(1,5);
turso> insert into u select * from generate_series(1,5);
turso> insert into v select * from generate_series(1,5);
turso> select * from t join u using (a) join v using (a);
1
2
3
4
5
turso> create materialized view tuv as select * from t join u using (a) join v using (a);
turso> select * from tuv;
2|2|2
4|4|4
1|1|1
3|3|3
5|5|5

Metadata

Metadata

Assignees

No one assigned

    Labels

    Type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions