Skip to content
This repository was archived by the owner on Oct 10, 2025. It is now read-only.
This repository was archived by the owner on Oct 10, 2025. It is now read-only.

Bug: Duplicated column names error in sql_query with join queries #5132

@ray6080

Description

@ray6080

Kuzu version

master

What operating system are you using?

No response

What happened?

When attached to a Postgres database with table person, evaluate the following query can lead to binding error on duplicate column name "id".

kuzu> call sql_query('pg', 'select * from person p1, person p2 where p1.id=p2.id and p1.age<30;') return *;
Error: Binder Error: table "postgres_query" has duplicate column name "id"

Are there known steps to reproduce?

No response

Metadata

Metadata

Assignees

Labels

type: bugSomething isn't working

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions