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: window function in case when cause panic #13869

Closed
1 of 2 tasks
b41sh opened this issue Nov 30, 2023 · 0 comments
Closed
1 of 2 tasks

bug: window function in case when cause panic #13869

b41sh opened this issue Nov 30, 2023 · 0 comments
Assignees
Labels
C-bug Category: something isn't working found-by-sqlsmith

Comments

@b41sh
Copy link
Member

b41sh commented Nov 30, 2023

Search before asking

  • I had searched in the issues and found no similar issues.

Version

v1.2.233

What's Wrong?

window function in case when cause panic

panicked at src/query/expression/src/property.rs:333:30:
internal error: entered unreachable code: unable to merge Map(None) with Undefined

How to Reproduce?

mysql> create table tt1(a bool, b int);
Query OK, 0 rows affected (0.15 sec)

mysql> insert into tt1 values(true, 1),(false, 2);
Query OK, 2 rows affected (0.31 sec)

mysql> SELECT CASE WHEN tt1.a THEN last_value([{}, {}, {}]) OVER (PARTITION BY FALSE) WHEN tt1.a THEN [{}] END FROM tt1;
ERROR 2013 (HY000): Lost connection to MySQL server during query
No connection. Trying to reconnect...
Connection id:    19
Current database: *** NONE ***

Are you willing to submit PR?

  • Yes I am willing to submit a PR!
@b41sh b41sh added C-bug Category: something isn't working found-by-sqlsmith labels Nov 30, 2023
@lichuang lichuang self-assigned this Nov 30, 2023
@lichuang lichuang closed this as completed Jan 5, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
C-bug Category: something isn't working found-by-sqlsmith
Projects
None yet
Development

No branches or pull requests

2 participants