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

Panicked when processing: assertion failed: (left == right) #12818

Closed
YuanchengJiang opened this issue Oct 12, 2023 · 2 comments
Closed

Panicked when processing: assertion failed: (left == right) #12818

YuanchengJiang opened this issue Oct 12, 2023 · 2 comments
Labels
type/bug Something isn't working
Milestone

Comments

@YuanchengJiang
Copy link

YuanchengJiang commented Oct 12, 2023

Error message/log

Panicked when processing: assertion failed: `(left == right)`
  left: `Timestamp`,
 right: `Float64`: Type mismatch when substituting $1 with $4.
This is a bug. We would appreciate a bug report at https://github.com/risingwavelabs/risingwave/issues/new?labels=type%2Fbug&template=bug_report.yml
server closed the connection unexpectedly
	This probably means the server terminated abnormally
	before or while processing the request.

To Reproduce

CREATE TABLE test1 (c_0 TIMESTAMP, c_1 INT, c_2 FLOAT);
CREATE TABLE test2 (c_0 TIMESTAMP, c_1 INT, c_2 FLOAT);
SELECT max(T1.c_0) OVER(PARTITION BY T2.c_0<>T1.c_0) FROM test1 AS T1 INNER JOIN test2 AS T2 ON T1.c_0>T2.c_0 group by T1.c_0,T2.c_0,T1.c_1,T2.c_1,T1.c_2,T2.c_2;

How did you deploy RisingWave?

Docker

The version of RisingWave

PostgreSQL 9.5-RisingWave-1.2.0 (f27f085)

@BugenZhao
Copy link
Member

Would you please help to take a look? cc @stdrc

@xxchan
Copy link
Member

xxchan commented Oct 17, 2023

duplicate with #10666, already fixed in main

@xxchan xxchan closed this as completed Oct 17, 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

No branches or pull requests

3 participants