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.

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

EXCEPT panics for jsonb column #19278

Open
xxchan opened this issue Nov 6, 2024 · 1 comment
Open

EXCEPT panics for jsonb column #19278

xxchan opened this issue Nov 6, 2024 · 1 comment
Assignees
Labels
no-issue-activity type/bug Something isn't working
Milestone

Comments

@xxchan
Copy link
Member

xxchan commented Nov 6, 2024

Describe the bug

No response

Error message/log

ERROR:  Panicked when handling the request: called `Result::unwrap()` on an `Err` value: function is_not_distinct_from(jsonb, jsonb) does not exist
This is a bug. We would appreciate a bug report at:

To Reproduce

No response

Expected behavior

No response

How did you deploy RisingWave?

No response

The version of RisingWave

No response

Additional context

  • I was trying to found whether there are different data, so I want to use EXCEPT.
  • I workarounded it using select * from t1 where not exists (select 1 from t2 where t1.col1=t2.col2 AND ...)
  • UNION with jsonb is also supported
@xxchan xxchan added the type/bug Something isn't working label Nov 6, 2024
@github-actions github-actions bot added this to the release-2.2 milestone Nov 6, 2024
Copy link
Contributor

github-actions bot commented Jan 6, 2025

This issue has been open for 60 days with no activity.

If you think it is still relevant today, and needs to be done in the near future, you can comment to update the status, or just manually remove the no-issue-activity label.

You can also confidently close this issue as not planned to keep our backlog clean.
Don't worry if you think the issue is still valuable to continue in the future.
It's searchable and can be reopened when it's time. 😄

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
no-issue-activity type/bug Something isn't working
Projects
None yet
Development

No branches or pull requests

2 participants