PostgreSQL Bugs

Collected from the PG bugs email list.

Bug ID15974
PG Version11.4
OSlinux - Red Hat 7.6
Opened2019-08-23 11:16:19+00
Reported byTessari Andrea
StatusNew

Body of first available message related to this bug follows.

The following bug has been logged on the website:

Bug reference:      15974
Logged by:          Tessari Andrea
Email address:      (redacted)
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) 
 ;

Messages

DateAuthorSubject
2019-08-23 11:16:19+00PG Bug reporting formBUG #15974: Concact with || doesn't work, but function CONCAT () works
2019-08-23 18:09:56+00"David G(dot) Johnston"Re: BUG #15974: Concact with || doesn't work, but function CONCAT () works