|
Problem IT10693
|
Status: Closed |
ERROR -1204 RETURNED WHEN RIGHT HAND DATE VALUE OF EQUALITY EXPRESSION CONTAINS DECEMBER 31ST, 9999 |
| product: |
INFORMIX SERVER / 5725A3900 / B70 - IDS 11.70 |
| Problem description: |
With DBDATE set to DMY4-, the SQL expression below returns -1204
"Invalid year in date".
select date(dtcol) from table1 where date(dtcol) = '31129999';
The above SQL works fine if the date value on the right side is
'30129999' or less. The above test works fine in 11.70.xC5 but
fails as described in 11.70.xC8 and 11.70.xC8W1. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* Users of 11.70.xC8. *
****************************************************************
* PROBLEM DESCRIPTION: *
* A query may return -1204 error if it contains the following *
* predicate: *
* date(datetime_col) = 12/31/9999 *
****************************************************************
* RECOMMENDATION: *
* Update to IBM Informix Server 11.70.xC9. *
**************************************************************** |
| Local Fix: |
|
| Solution |
Problem Fixed In IBM Informix Server 11.70.xC9. |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 13.08.2015
09.06.2017
09.06.2017 |
| Problem solved at the following versions (IBM BugInfos) |
11.70.xC9
|
| Problem solved according to the fixlist(s) of the following version(s) |
