home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Latest versionsfixlist
14.10.xC10 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 IT41784 Status: Closed

Error 410 when executing a select with connect by using an lvarchar from
base table

product:
INFORMIX SERVER / 5725A3900 / E10 -
Problem description:
Getting a SQL error on server. At first glance the issue seems
to be related to the "col3 lvarchar" column.
Tried to modify the column as "col3 char(2048)" it works. And
with the "col3 lvarchar" column it is not working and getting
sql error

Output -

> create table table_a1
  (
    col1_id serial not null,
    col2_id integer,
    col3 lvarchar,
    col4 char(1),
> > > > > >     col5 integer,
    col6 char(1),
    col7 datetime year to second,
    col8 char(15),
    col9 char(1),
    col10 char(1),
    col11 integer,
    col12 integer
  ) extent size 32768 next size 32768 lock mode row;

begin work;

lock table table_a1 in exclusive mode;

> > > > > > > >
Table created.

> >
Started transaction.

> >
Table locked.

> > load from table_a1 insert into table_a1;

commit work;
2 row(s) loaded.

> >

Data committed.



> select n.* , level, connect_by_isleaf
from table_a1 n
start with col2_id = 224960  and col10 = 'Y'
connect by prior col1_id = col11 ;> > >

  410: Prepare statement failed or was not executed.
Error in line 4
Near character position 30



Product Version : IDS 14.10.xC8
Tested in : IDS 14.10.xC8
Problem Summary:
****************************************************************
* USERS AFFECTED:                                              *
* Users of Informix Server 14.10.xC7 and 14.10.xC8.            *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description                                        *
****************************************************************
* RECOMMENDATION:                                              *
* Upgrade to Informix Server 14.10.xC9.                        *
****************************************************************
Local Fix:


Solution




Workaround


****************************************************************
* USERS AFFECTED:                                              *
* Users of Informix Server 14.10.xC7 and 14.10.xC8.            *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description                                        *
****************************************************************
* RECOMMENDATION:                                              *
* Upgrade to Informix Server 14.10.xC9.                        *
****************************************************************


Comment


Fixed in Informix Server 14.10.xC9.


Timestamps


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

16.08.2022
17.02.2023
17.02.2023


Problem solved at the following versions (IBM BugInfos)




Problem solved according to the fixlist(s) of the following version(s)