Is this error expected ?
От | Yavuz TANRIVERDİ |
---|---|
Тема | Is this error expected ? |
Дата | |
Msg-id | CAH-+qaYG=v0ts62XJqAjDJthJcvtc_EdMYv4Eh0ZnX3TM7Zm5A@mail.gmail.com обсуждение исходный текст |
Ответы |
Re: Is this error expected ?
Re: Is this error expected ? |
Список | 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 по дате отправления: