MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8;
 format=flowed
Date: Mon, 13 Feb 2023 18:24:45 +0800
From: xianliang.ji@esgyn.cn
To: pgsql-bugs@lists.postgresql.org
Cc: Wang Xiao-Zhong <xiaozhong.wang@esgyn.cn>, Guo Heng <heng.guo@esgyn.cn>
Subject: Optimizer failed to generate plan
User-Agent: Roundcube Webmail
Message-ID: <3ce0a99e71d27c47a9d5e5589002da8c@esgyn.cn>
Content-Transfer-Encoding: quoted-printable
Archived-At: 
 <https://www.postgresql.org/message-id/3ce0a99e71d27c47a9d5e5589002da8c%40esgyn.cn>
Precedence: bulk

Hi PostgreSQL community,
    Hello guys=EF=BC=8CI am a DBA and found the flowing issue when doing =
test on=20
postgresql. is there any plan to fix this issue=EF=BC=9FThanks and feedba=
ck are=20
welcome.


xianliang.ji
Company: esgyn
Email: xianliang.ji@esgyn.cn


[postgres@mdw postgresql]$ /home/postgres/postgresql/install/bin/psql
psql (15.2)
Type "help" for help.

postgres=3D# select version();
                                                  version
-------------------------------------------------------------------------=
--------------------------------
  PostgreSQL 15.2 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5=20
20150623 (Red Hat 4.8.5-44), 64-bit
(1 row)

postgres=3D# CREATE TABLE dept(
postgres(#     deptno int,
postgres(#     dname VARCHAR(14),
postgres(#     loc VARCHAR(13)
postgres(#   );
CREATE TABLE
postgres=3D# CREATE TABLE emp(
postgres(#   empno int,
postgres(#   ename VARCHAR(10),
postgres(#   job VARCHAR(9),
postgres(#   mgr int,
postgres(#   hiredate DATE,
postgres(#   sal double precision,
postgres(#   comm double precision,
postgres(#   deptno int,
postgres(#   jobno int
postgres(# );
CREATE TABLE
postgres=3D# select a.*,b.* from EMP a FULL JOIN DEPT b on=20
a.deptno=3Db.deptno OR upper(ename)=3D'BLAKE' where a.job=3D'MANAGER' OR=20
b.dname=3D'SALES';
ERROR:  FULL JOIN is only supported with merge-joinable or hash-joinable=20
join conditions
postgres=3D#