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 pg_opclass #3431

Closed
Tracked by #3364
lmatz opened this issue Jun 23, 2022 · 3 comments
Closed
Tracked by #3364

Support pg_opclass #3431

lmatz opened this issue Jun 23, 2022 · 3 comments
Assignees
@kwannoel
Labels
help wanted Issues that need help from contributors no-issue-activity type/bug Something isn't working
Milestone
release-0.1.15

Comments

@lmatz
Copy link
Contributor

lmatz commented Jun 23, 2022

Describe the bug

select opcname FROM pg_opclass:
Catalog error: table or source not found: pg_opclass

To Reproduce

Expected behavior
The same as PG

Additional context
Try to make Sqlancer make. See #3364
@lmatz lmatz added the type/bug Something isn't working label Jun 23, 2022
@lmatz lmatz mentioned this issue Jun 23, 2022
Open
8 tasks
@yezizp2012
Copy link
Member

yezizp2012 commented Jun 23, 2022 •
edited
Loading

pg_opclass is a system table and not implemented yet. Besides, we don't support query on system table without specified pg_catalog schema name also. 😂
Ref: https://www.postgresql.org/docs/current/catalog-pg-opclass.html

@lmatz lmatz added the help wanted Issues that need help from contributors label Jun 23, 2022
@lmatz
Copy link
Contributor Author

lmatz commented Jun 23, 2022 •
edited
Loading

pg_opclass is a system table and not implemented yet. Besides, we don't support query on system table without specified pg_catalog schema name also. 😂 Ref: https://www.postgresql.org/docs/current/catalog-pg-opclass.html

Thanks for the info! Running Sqlancer is not urgent and this issue can be addressed in the future. Right now, we focus on enhancing Sqlsmith.

We can also start to support SQLancer now by hard-coding the pg_opclass system table.

@yezizp2012 yezizp2012 mentioned this issue Jul 4, 2022
Open
15 tasks
@lmatz lmatz added this to the release-0.1.14 milestone Oct 18, 2022
@lmatz lmatz changed the title Support pg_opclass Support pg_opclass Oct 31, 2022
@kwannoel kwannoel self-assigned this Oct 31, 2022
@kwannoel kwannoel mentioned this issue Nov 2, 2022
Merged
4 tasks
@kwannoel
Copy link
Contributor

kwannoel commented Nov 9, 2022

Closing this first since it is already stubbed for sqlancer. We can reopen when planned again.

@kwannoel kwannoel closed this as not planned Won't fix, can't repro, duplicate, stale Nov 9, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@kwannoel kwannoel

Labels
help wanted Issues that need help from contributors no-issue-activity type/bug Something isn't working
Projects
None yet
Milestone
release-0.1.15
Development

No branches or pull requests
4 participants
@lmatz @neverchanje @yezizp2012 @kwannoel