suche 36x36
  • Admin-Scout-small-Banner
           

    CURSOR Admin-Scout

    das ultimative Tool für Informix

    pfeil  
Neueste VersionenFixList
14.10.xC10 FixList
12.10.xC16.X5 FixList
11.70.xC9.XB FixList
11.50.xC9.X2 FixList
11.10.xC3.W5 FixList
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

Informix - Problembeschreibung

Problem IT27522 Status: Geschlossen

THE FUNCTION DELRANGE SOMETIMES FAILS TO DELETE ENTRIES / ELEMENTS

Produkt:
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10
Problembeschreibung:
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-Zusammenfassung:
****************************************************************
* USERS AFFECTED:                                              *
* Users of IDS 12.10.xC10 or older versions.                   *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* The function delrange sometimes fails to delete entries /    *
* elements.                                                    *
****************************************************************
* RECOMMENDATION:                                              *
****************************************************************
Local-Fix:
Lösung
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
24.12.2018
08.10.2019
08.10.2019
Problem behoben ab folgender Versionen (IBM BugInfos)
12.10.xC11
Problem behoben lt. FixList in der Version
Informix EditionenInformix Editionen
Informix Editionen
DokumentationDokumentation
Dokumentation
IBM NewsletterIBM Newsletter
IBM Newsletter
Current BugsCurrent Bugs
Current Bugs
Bug ResearchBug Research
Bug Research
Bug FixlistsBug Fixlists
Bug Fixlists
Release NotesRelease Notes
Release Notes
Machine NotesMachine Notes
Machine Notes
Release NewsRelease News
Release News
Product LifecycleProduct Lifecycle
Lifecycle
Media DownloadMedia Download
Media Download