• Admin-Scout-small-Banner
           
    CURSOR Admin-Scout
    get the ultimate tool for Informix
    pfeil  
invispix 10x10
invispix 10x10
Latest versionsfixlist
14.10.xC5 FixList
12.10.xC14.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
Question in the chat LiveZilla Live Help

Informix - Problem description

Problem IT34172 Status: Closed

SELECT STATEMENT USING A SUBQUERY WILL FAIL WITH 528 ERROR

product:
INFORMIX SERVER / 5725A3900 / E10 - 
Problem description:
A select statement using a sub-query referring the same table
will fail with error 528, even though the values displayed are
small.

the following statement:
SELECT DISTINCT
        CRITERIA_0.order_no,
        CRITERIA_0.order_id
FROM
        tab2,  tab1 CRITERIA_0
WHERE
        CRITERIA_0.order_id = tab2.order_id
         AND EXISTS
                (SELECT DISTINCT CRITERIA_1.order_id
                        FROM
                                tab2, tab1 CRITERIA_1
                        WHERE
                                CRITERIA_1.order_id =
tab2.order_id
                                AND CRITERIA_0.order_id =
CRITERIA_1.order_id

will fail with error 528  if the size of both tables is bigger
that 32k.
This is at the very least misleading as 528 means:
-528    Maximum output rowsize max-size exceeded.

One table is using an Lvarchar(32000), which is only part of the
table, not of the criteria of the query.
Making this just a bit smaller will avoid the issue.

The stack for onmode -I shows:
base: 0x00000000481e9000
  len:   69632
   pc: 0x00000000014a458d
  tos: 0x00000000481f72f0
state: running
   vp: 1

0x00000000014a458d (oninit) afstack
0x00000000014a962d (oninit) afhandler
0x00000000014a9c42 (oninit) affail_interface
0x0000000000ed9a00 (oninit) check_traperror
0x0000000000762a41 (oninit) sqerr
0x000000000096cf11 (oninit) create_rdupsinfo
0x000000000097409f (oninit) opdojoin
0x000000000097492b (oninit) chk_dir_oj
0x00000000009768ef (oninit) opjoin
0x0000000000977da1 (oninit) op_join
0x000000000097b6cd (oninit) op_phasejoin
0x00000000008401e0 (oninit) sqoptim
0x0000000000a9a6ae (oninit) bldstructs
0x0000000000aa79e1 (oninit) sqcmd
0x0000000000aa7f3d (oninit) sq_prepare
0x0000000000b8eeae (oninit) sqmain
0x00000000015d2e3b (oninit) spawn_thread
0x0000000001495103 (oninit) th_init_initgls
0x00000000014dc0bf (oninit) startup
Problem Summary:
****************************************************************
* USERS AFFECTED:                                              *
* Users of Informix Server prior to 14.10.xC5.                 *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description                                        *
****************************************************************
* RECOMMENDATION:                                              *
* Upgrade to Informix Server 14.10.xC5.                        *
****************************************************************
Local Fix:
Solution
Workaround
not known / see Local fix
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
10.09.2020
09.12.2020
09.12.2020
Problem solved at the following versions (IBM BugInfos)
Problem solved according to the fixlist(s) of the following version(s)
invispix 10x10
invispix 10x10
invispix 10x10
Technical InfoTechnical Info

Technical Info

DocumentationDocumentation

Documentation

IBM NewsletterIBM Newsletter

IBM Newsletter

Current BugsCurrent Bugs

Current Bugs

Bug ResearchBug Research

Bug Research

Bug FixlistsBug Fixlists

Bug Fixlists

Release NotesRelease Notes

Release Notes

Machine NotesMachine Notes

Machine Notes

Release NewsRelease News

Release News

Product LifecycleProduct Lifecycle

Lifecycle

Media DownloadMedia Download

Media Download

invispix 10x10
Service und SupportService und Support

Service and Support

Informix MonitoringInformix Monitoring

Informix Monitoring

Admin-Scout forInformixAdmin-Scout forInformix

Admin-Scout for Informix

Informix News & InfosInformix News & Infos

Informix News & Infos

This site uses cookies to make it easier for us to provide you with our services. By using our site you agree to the use of cookies.