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

Bug: multi scalar subquery cause optimizer panic #13543

Closed
chenzl25 opened this issue Nov 21, 2023 · 0 comments · Fixed by #13544
Closed

Bug: multi scalar subquery cause optimizer panic #13543

chenzl25 opened this issue Nov 21, 2023 · 0 comments · Fixed by #13544
Assignees
Labels
type/bug Something isn't working
Milestone

Comments

@chenzl25
Copy link
Contributor

chenzl25 commented Nov 21, 2023

Describe the bug

create table t (a int);
create table dl(c1 int, c2 int);
create table di(d1 int, d2 int);

explain (trace) create materialized view outbound_tracking_mv as 
select
        (select 1 from t,di where t.a = dl.c1 limit 1) name
        , (select 1 from t, di where t.a = dl.c2  limit 1) name2
from dl;

Error message/log

No response

To Reproduce

No response

Expected behavior

No response

How did you deploy RisingWave?

No response

The version of RisingWave

No response

Additional context

No response

@chenzl25 chenzl25 added the type/bug Something isn't working label Nov 21, 2023
@chenzl25 chenzl25 self-assigned this Nov 21, 2023
@github-actions github-actions bot added this to the release-1.5 milestone Nov 21, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
type/bug Something isn't working
Projects
None yet
Development

Successfully merging a pull request may close this issue.

1 participant