Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Support seemingly ambiguous reference #297

Open
NoyException opened this issue Dec 18, 2024 · 0 comments · May be fixed by #299
Open

Support seemingly ambiguous reference #297

NoyException opened this issue Dec 18, 2024 · 0 comments · May be fixed by #299
Assignees
@TianyuZhang1214

Comments

@NoyException
Copy link
Contributor

When trying to connect using Npgsql (in C#), it sends a sql like this:

SELECT pg_type.oid, enumlabel
FROM pg_enum
JOIN pg_type ON pg_type.oid=enumtypid
ORDER BY oid, enumsortorder;

The problem is that in real pg server, this can work properly. But in MyDuck Server, it brings us a bug (created by DuckDB):

Binder Error: Ambiguous reference to column name "oid" (use: "pg_type.oid" or "pg_enum.oid")
@TianyuZhang1214 TianyuZhang1214 self-assigned this Dec 18, 2024
TianyuZhang1214 added a commit that referenced this issue Dec 19, 2024
@TianyuZhang1214
to #297 fix: add full_match_handler.go to convert the query.
af3deb4
@TianyuZhang1214 TianyuZhang1214 linked a pull request Dec 19, 2024 that will close this issue
Open
@TianyuZhang1214 TianyuZhang1214 linked a pull request Dec 19, 2024 that will close this issue
fix: add full_match_handler.go to convert the query. #299
Open
TianyuZhang1214 added a commit that referenced this issue Dec 19, 2024
@TianyuZhang1214
to #297 test: enable pg test for csharp
b6d19f4
TianyuZhang1214 added a commit that referenced this issue Dec 23, 2024
@TianyuZhang1214
to #297 fix: bugs in ConvertToSys()
aabe13b
TianyuZhang1214 added a commit that referenced this issue Dec 24, 2024
@TianyuZhang1214
to #297 fix: mock pg_type, pg_namespace, pg_class, pg_proc and pg_ran…
f48b083 
…ge in __sys__
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@TianyuZhang1214 TianyuZhang1214

Labels
None yet
Projects
None yet
Milestone
No milestone
Development

Successfully merging a pull request may close this issue.

fix: add full_match_handler.go to convert the query. apecloud/myduckserver
2 participants
@TianyuZhang1214 @NoyException