|
Problem IT39411
|
Status: Closed |
COLMIN,COLMAX EXPLANATION NEEDS TO BE CHANGED
|
| product: |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 |
| Problem description: |
Both IBM Informix - 12.10 and 14.10 needs changes.
Task 1:
https://www.ibm.com/docs/en/informix-servers/12.10?topic=tables-
syscolumns
https://www.ibm.com/docs/en/informix-servers/14.10?topic=tables-
syscolumns#ids_sqr_025
Explanation
colmin INTEGER Minimum column length (in bytes)
colmax INTEGER Maximum column length (in bytes)
needs to be changed to below,
==============>
Explanation
colmin INTEGER Hold the second-smallest value in a column
colmax INTEGER Hold the second-largest value in a column
----------------------------------------------------------------
--------------------------------------------------------------
Task 2:
https://www.ibm.com/docs/en/informix-servers/12.10?topic=syscolu
mns-storing-maximum-minimum-values
https://www.ibm.com/docs/en/informix-servers/14.10?topic=syscolu
mns-storing-maximum-minimum-values
The colmin and colmax values hold the second-smallest and
second-largest data values in the column, respectively.
needs to be changed to below,
==============>
The colmin and colmax are statistical values which give only the
second-smallest and second-largest value of a column at the time
of the last update statistics (and only for leading index
columns). |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* Users of Informix Server prior to 14.10.FC10. *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to Informix Server 14.10.FC10. *
**************************************************************** |
| Local Fix: |
|
| Solution |
|
| Workaround |
****************************************************************
* USERS AFFECTED: *
* Users of Informix Server prior to 14.10.FC10. *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to Informix Server 14.10.FC10. *
**************************************************************** |
| Comment |
Fixed in Informix Server 14.10.FC10. |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 15.12.2021
23.02.2023
23.02.2023 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
