INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10

Starting with 12.10.xC7W1 the select

    select skip 1 trim(line) as line from sysonlinelog where
offset > -10000;

does show an empty result set.

This query is used in OAT to display the log file of the
instance and due to this issue OAT can not display the log file.

When changing the SQL to

    select {+FULL(sysonlinelog)} skip 1 trim(line) as line from
sysonlinelog;

the expected result is shown.

****************************************************************
* USERS AFFECTED:                                              *
* SELECT from sysmaster:sysonlinelog pseudo table using        *
* negative value for offset in where clause.                   *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description.                                       *
* When selecting from sysmaster:sysonlinelog pseudo table and  *
* specifying a negative value for the offset in the where      *
* clause, a functionality similar to the UNIX utility "tail"   *
* is expected, i.e. that the last lines of the log file are in *
* the result of the query.                                     *
* This behavior is not documented, but it is expected e.g. by  *
* OAT.                                                         *
****************************************************************
* RECOMMENDATION:                                              *
* Update to IBM Informix Server 12.10.xC9 or newer version.    *
****************************************************************

not known / see Local fix

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

18.08.2016
09.12.2016
09.12.2016

12.10.xC9