Skip to content
This repository has been archived by the owner on Feb 20, 2023. It is now read-only.

bug: Can not generate plan #1649

Open
iwanttobepowerful opened this issue Feb 4, 2023 · 0 comments
Open

bug: Can not generate plan #1649

iwanttobepowerful opened this issue Feb 4, 2023 · 0 comments

Comments

@iwanttobepowerful
Copy link

iwanttobepowerful commented Feb 4, 2023

postgres=# CREATE TABLE t1(a INT, b INT);
CREATE TABLE
postgres=# CREATE TABLE t2(c INT, d INT);;
CREATE TABLE
postgres=# SELECT * FROM t1 left JOIN t2 ON t2.c <= t1.a;  -- segment fault
postgres=# SELECT * FROM t1 right JOIN t2 ON t2.c = t1.a;  -- segment fault
postgres=# SELECT count(*) FROM t1 right JOIN t2 ON t2.c <= t1.a;  -- infinite loop
postgres=# SELECT count(*) FROM t1 left JOIN t2 ON t2.c <= t1.a;  -- infinite loop
postgres=# SELECT * FROM t1 left JOIN t2 ON t2.c = t1.a; -- ok

Actual Behavior

Can not generate plan.

@iwanttobepowerful iwanttobepowerful changed the title bug: Can not generate plan due to infinite loop bug: Can not generate plan Feb 5, 2023
Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant