From: | xianliang(dot)ji(at)esgyn(dot)cn |
---|---|
To: | pgsql-bugs(at)lists(dot)postgresql(dot)org |
Cc: | Wang Xiao-Zhong <xiaozhong(dot)wang(at)esgyn(dot)cn>, Guo Heng <heng(dot)guo(at)esgyn(dot)cn> |
Subject: | Optimizer failed to generate plan |
Date: | 2023-02-13 10:24:45 |
Message-ID: | 3ce0a99e71d27c47a9d5e5589002da8c@esgyn.cn |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
Hi PostgreSQL community,
Hello guys,I am a DBA and found the flowing issue when doing test on
postgresql. is there any plan to fix this issue?Thanks and feedback are
welcome.
xianliang.ji
Company: esgyn
Email: xianliang(dot)ji(at)esgyn(dot)cn
[postgres(at)mdw postgresql]$ /home/postgres/postgresql/install/bin/psql
psql (15.2)
Type "help" for help.
postgres=# select version();
version
---------------------------------------------------------------------------------------------------------
PostgreSQL 15.2 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5
20150623 (Red Hat 4.8.5-44), 64-bit
(1 row)
postgres=# CREATE TABLE dept(
postgres(# deptno int,
postgres(# dname VARCHAR(14),
postgres(# loc VARCHAR(13)
postgres(# );
CREATE TABLE
postgres=# 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=# select a.*,b.* from EMP a FULL JOIN DEPT b on
a.deptno=b.deptno OR upper(ename)='BLAKE' where a.job='MANAGER' OR
b.dname='SALES';
ERROR: FULL JOIN is only supported with merge-joinable or hash-joinable
join conditions
postgres=#
From | Date | Subject | |
---|---|---|---|
Next Message | David Rowley | 2023-02-13 10:41:06 | Re: array_agg(DISTINCT) caused a segmentation fault |
Previous Message | Alexander Lakhin | 2023-02-13 10:00:00 | Re: array_agg(DISTINCT) caused a segmentation fault |