We have noticed a few rows in our db with possibly corrupted data. If we try to SELECT these rows, we are met with this error: "An error occurred while executing batch. Error message is: Arithmetic Overflow."
If we CAST the column in question as a VARCHAR, we see that the value stored in the column is "1000000.000". e.g. 1,000,000.000
This raises two questions:
1) If the column is defined as DECIMAL(9,3) how can it hold 10 digits???
2) Why didn't whatever process that inserted/updated that value fail?