Is this error expected ?

Поиск
Список
Период
Сортировка
От Yavuz TANRIVERDİ
Тема Is this error expected ?
Дата
Msg-id CAH-+qaYG=v0ts62XJqAjDJthJcvtc_EdMYv4Eh0ZnX3TM7Zm5A@mail.gmail.com
обсуждение исходный текст
Ответы Re: Is this error expected ?  (Ron <ronljohnsonjr@gmail.com>)
Re: Is this error expected ?  (Laurenz Albe <laurenz.albe@cybertec.at>)
Список 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;

В списке pgsql-general по дате отправления:

Предыдущее
От: Christophe Pettus
Дата:
Сообщение: Re: COMMIT IN STORED PROCEDURE WHILE IN A LOOP
Следующее
От: Laurenz Albe
Дата:
Сообщение: Re: Is this error expected ?