home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Latest versionsfixlist
14.10.xC11 FixList
12.10.xC16.X5 FixList
11.70.xC9.XB FixList
11.50.xC9.X2 FixList
11.10.xC3.W5 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

Informix - Problem description

Problem IT41397 Status: Closed

CONNECT BY QUERY CREATES UNIQUE ROW AND MULTISET TYPES IN SYSXTDDESC TABLE
AND THEY ARE NOT REMOVED

product:
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10
Problem description:
Query with "connect by" clause creates the following ROW and
MULTISET types with session id and random number in system
catalogue tables.
There is nobody else who will ever reference these types except
a session with the same session id and server will delete those
types as soon as the query execution completes.

If we execute procedure having SQLs with CONNECT BY clause in
parallel, can cause the server to close the session without
deleting these
types from the system catalog tables. As a consequence the
tables
sysxtdtypes, sysxtddesc, and sysattrtypes are filled with
useless records.
Problem Summary:
Local Fix:
Solution
Workaround
not known / see Local fix
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
01.07.2022
05.12.2022
05.12.2022
Problem solved at the following versions (IBM BugInfos)
Problem solved according to the fixlist(s) of the following version(s)