INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10

String manipulation on a view using FIELD[n,m] can return 
corrupted data, where using SUBSTR(var,n,m) yields correct 
results. This problem is observed in 12.10.FC4, but not in 11.70 
 
Example: 
 
  SELECT v_col10[1, 20] FROM my_view WHERE ROWID = 101; 
  returns wrong results with control characters => 
"ABCDEF08^BIFAL" 
 
  SELECT substr(v_col10,1, 20) FROM my_view WHERE ROWID = 101; 
  returns expected results=> "ABCDEF"

**************************************************************** 
* USERS AFFECTED:                                              * 
* Users of 12.10.xC1 through 12.10.xC4                         * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* A query may return incorrect results under the following     * 
* conditions:                                                  * 
*   - it references a view (or derived table)                  * 
*   - the projection clause of the main query uses a           * 
* subscripted view column reference, e.g. v1.col1[2,20]        * 
*   - the referenced view column (v1.col1 above) is of type    * 
* VARCHAR                                                      * 
*   - the view is folded into the main query (i.e., no temp    * 
* table created for the view)                                  * 
*   - for some rows the value of the view column reference is  * 
* shorter than the subscripted range, i.e., the range          * 
* v1.col1[2,20] specifies up to position 20, but the VARCHAR   * 
* column has a value that's less than 20 characters long       * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Update to IDS-12.10.xC5                                      * 
****************************************************************

Problem Fixed In IDS-12.10.xC5

not known / see Local fix

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

03.07.2014
16.10.2015
16.10.2015