Informix - Problem description
Problem IT29845 | Status: Closed |
SERVER RETURNS CASE AS A LVARCHAR INSTEAD OF CHAR | |
product: | |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 | |
Problem description: | |
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 | |
Problem Summary: | |
**************************************************************** * 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: * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 26.07.2019 20.09.2019 20.09.2019 |
Problem solved at the following versions (IBM BugInfos) | |
12.10.xC14 | |
Problem solved according to the fixlist(s) of the following version(s) |