|
Problem IT29479
|
Status: Closed |
A SELECT OF A VARCHAR(255) COLUMN WHICH USES CASE AND CONCAT WILL FAIL WITH ERROR 9628: TYPE (VARIABLE UDT, XID = 0) NOT FOUND
|
| product: |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 |
| Problem description: |
ENV : Linux 12.10.FC13 and 14.10.FC1
A table created with
create table test (id integer not null, name varchar (255));
will fail when the following select statement is run â ¦
select case when (a.id != 0) then a.name else a.name || 'aa' end
name from test a
Database selected.
9628: Type (variable udt, xid = 0) not found.
Error in line 1
Near character position 62
This fails with and without any rows being added to the table. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* Users of IDS 12.10.xC13. *
****************************************************************
* PROBLEM DESCRIPTION: *
* A select of a vachar(255) column which uses case and concat *
* will fail with error 9628: TYPE (VARIABLE UDT, XID = 0) NOT *
* FOUND. *
****************************************************************
* RECOMMENDATION: *
**************************************************************** |
| Local Fix: |
|
| Solution |
|
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 18.06.2019
23.09.2019
19.02.2020 |
| Problem solved at the following versions (IBM BugInfos) |
12.10.xC14
|
| Problem solved according to the fixlist(s) of the following version(s) |
