Is this error expected ?

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

https://github.com/yiisoft/yii/blob/e7c298343bf1f76186d443b62ff853d2d36e19f0/framework/db/schema/pgsql/CPgsqlSchema.php#L233

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;

Responses

Browse pgsql-general by date

  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