I have a field in my table that is of SMALLINT type. If I edit in place that column and enter a decimal value, the data gets truncated when it gets inserted into the table (as expected), but the field shows the original decimal value.
e.g. - I have my SMALLINT field, I enter 500.987 and hit enter. It runs for a second, then shows "500.987" as being the field value when the actual field value (on refresh), shows "501" (as expected).