|
Problem IT22950
|
Status: Closed |
THE FUNCTION DELRANGE SOMETIMES FAILS TO DELETE ENTRIES / ELEMENTS
|
| product: |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 |
| Problem description: |
Running the following SQL ...
update meter_ts_tbl set
para_values=DELRANGE(para_values,'2017-09-29
00:00:00.00000'::datetime year to fraction(5),'2017-09-30
00:00:00.00000'::datetime year to fraction(5)) where
para_id=102211047;
... the following SQL was run before and after the update and it
shows the same number ...
select count(*), para_id from vt_meter_ts_tbl where
date1>'2017-09-29 00:00:00' and date1 |
| Problem Summary: |
|
| Local Fix: |
|
| Solution |
|
| Workaround |
not known / see Local fix |
| Comment |
This APAR is a duplicate of IT27522 |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 26.10.2017
23.09.2019
08.10.2019 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
