Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Integers have oddly changed by 128
Hi, all.
We have a sticky problem at one of our client's sites. They are experiencing some odd behavior in several tables. It seems that integer fields are mysteriously changing values by 128 (that's right, 2^7).
Has anyone ever seen this happen to them? The clients are getting upset, and rightfully so. So far, we have been able to correct the data by looking at backup tapes. But this is a band-aid over the true problem. We are seeing this happen in multiple tables and with different fields.
Oh, one more thing: we tried putting update triggers on the data, but the triggers haven't fired. The records affected were added 2 years ago or so. They hadn't changed at all until a few weeks ago. Our system is set up in such a way that these records really never change.
Any ideas?
- George
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement