General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only