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

EXCEPT panics for jsonb column #19278

Open
xxchan opened this issue Nov 6, 2024 · 0 comments
Open

EXCEPT panics for jsonb column #19278

xxchan opened this issue Nov 6, 2024 · 0 comments
Labels
type/bug Something isn't working
Milestone
release-2.2

Comments

@xxchan
Copy link
Member

xxchan commented Nov 6, 2024 •
edited
Loading

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
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
type/bug Something isn't working
Projects
None yet
Milestone
release-2.2
Development

No branches or pull requests
1 participant
@xxchan