BUG #15974: Concact with || doesn't work, but function CONCAT () works
От | PG Bug reporting form |
---|---|
Тема | BUG #15974: Concact with || doesn't work, but function CONCAT () works |
Дата | |
Msg-id | 15974-7722ea6a362abf3d@postgresql.org обсуждение исходный текст |
Ответы |
Re: BUG #15974: Concact with || doesn't work, but function CONCAT () works
|
Список | pgsql-bugs |
The following bug has been logged on the website: Bug reference: 15974 Logged by: Tessari Andrea Email address: tessari@gmail.com PostgreSQL version: 11.4 Operating system: linux - Red Hat 7.6 Description: Example. ( I test on postgres 11.4 and postgres 10.9 (edb) ) create table AA3 (CLIV CHAR(2), SSTT CHAR(1)); INSERT INTO AA3 (CLIV,SSTT) VALUES (' ','2'); COMMIT; ---errore expect "A Z" --> result "AZ" select 'A'||(CASE WHEN J01.CLIV = ' ' THEN ' ' ELSE J01.CLIV END)||'Z' as X from AA3 J01; ---errore expect "A "--> result "A" select 'A'||(CASE WHEN J01.CLIV = ' ' THEN ' ' ELSE J01.CLIV END) as X from AA3 J01; ---errore expect " Z"--> result "Z" select (CASE WHEN J01.CLIV = ' ' THEN ' ' ELSE J01.CLIV END)||'Z' as X from AA3 J01; --WORKS - show " "--> result " " select (CASE WHEN J01.CLIV = ' ' THEN ' ' ELSE J01.CLIV END) as X from AA3 J01; -- WORKS select 'A'||(CASE WHEN CLIV = ' ' THEN ' ' ELSE ' ' END)||'Z' from AA3 ; -- WORKS select CONCAT ('A', x,'Z') FROM (SELECT CASE WHEN CLIV = ' ' THEN ' ' ELSE CLIV END AS X from AA3) ;
В списке pgsql-bugs по дате отправления: