Re: Is this error expected ?

On 10/19/22 01:50, Yavuz TANRIVERDİ wrote:
> |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" ); |

Try CHAR(1) instead of just 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; |

--
Angular momentum makes the world go 'round.