INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10

The return value of a CASE/CONCAT field to be returned as
LVARCHAR rather than CHAR/VARCHAR.

informix@irk:/tmp$ cat c3.sql
drop table sources;
create table sources
(
	srcgenidfield varchar(100,1) not null,
	srcdescrtable varchar(100,1) not null,
	srcdescrfield varchar(100,1) not null
);

create view va2(descrsql) as
select
	CASE WHEN (srcdescrtable = srcdescrtable) THEN
		"select " || srcdescrfield || " from " || srcdescrtable || "
where " || srcgenidfield || " = "
	ELSE
		""
	END
from sources;

select descrsql from va2;
informix@irk:/tmp$

informix@irk:/tmp$ dbaccess stores7 c3
Database selected.
Table dropped.
Table created.
View created.
No rows found.
Database closed.
informix@irk:/tmp$ sqliprint pp_21296  | grep Type
	Stmt Type...........: 1
	Stmt Type...........: 15
	Stmt Type...........: 14
	Stmt Type...........: 40
	Stmt Type...........: 2
	Type....................: CHAR; NULLABLE
	Stmt Type...........: 31
informix@irk:/tmp$ cat

Against a 12.10.FC13 or 14.10

informix@irk:/tmp$ dbaccess stores7 c3
Database selected.
Table dropped.
Table created.
View created.
No rows found.
Database closed.

informix@irk:/tmp$ sqliprint pp_21457 | grep Type
	Stmt Type...........: 1
	Stmt Type...........: 15
	Stmt Type...........: 14
	Stmt Type...........: 40
	Stmt Type...........: 2
	Type....................: SQLUDTVAR; NULLABLE
	Extended Type Name Length: 8
	Extended Type Name: lvarchar
	Source Type for Distinct Type: 0
	Type.....: SQLLVARCHAR; NULLABLE
	Extended Type Name:  "lvarchar" [8]
	Stmt Type...........: 31
informix@irk:/tmp$

This can cause problems with clients who don't support/expect a
lvarchar type

****************************************************************
* USERS AFFECTED:                                              *
* Users of IDS 12.10.xC13.                                     *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* The return value of a CASE/CONCAT field is returned as       *
* LVARCHAR rather than CHAR/VARCHAR.                           *
****************************************************************
* RECOMMENDATION:                                              *
****************************************************************

not known / see Local fix

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

26.07.2019
20.09.2019
20.09.2019

12.10.xC14