From: | Yavuz TANRIVERDİ <sternix(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Is this error expected ? |
Date: | 2022-10-19 06:50:20 |
Message-ID: | CAH-+qaYG=v0ts62XJqAjDJthJcvtc_EdMYv4Eh0ZnX3TM7Zm5A@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi,
i have an
"ERROR: UNION types "char" and text cannot be matched CASE WHEN
indisprimary THEN"
error from
I read release notes, but can't find any related change,
It works for PostgreSQL 14.5 but fails with PostgreSQL 15.0, a test
sample below.
Is this error expected ?
Thanks,
create table tbla
(
a "char"
);
create table tblb
(
b char(1)
);
insert into tbla values ('a');
insert into tbla values ('b');
insert into tblb values ('c');
insert into tblb values ('d');
-- works with 14.5 fails on 15.0
select a from tbla
union all
select
case when true then
'p'
else
'u'
end from tblb;
From | Date | Subject | |
---|---|---|---|
Next Message | Laurenz Albe | 2022-10-19 07:15:39 | Re: Is this error expected ? |
Previous Message | vignesh C | 2022-10-19 05:48:05 | Re: Support logical replication of DDLs |