Severity:
High (data integrity issue)
Context:
The application UI allows users to enter decimal values (e.g., 10.5), and it accepts the input. However, in the backend, the value is stored as an integer 10, leading to data loss.
Steps to Reproduce:
- Go to the input form
- Enter 10.5 into the relevant Field
- Click on “Submit”
- Check the record in the database.
- the stored value is 10 not 10.5
Expected Result:
Decimal value 10.5 should be stored accurately in the database.
Actual Result:
Only the integer portion (10) is stored, and the decimal is lost.
Impact:
Loss of precision in stored data
May affect calculations, reporting, or billing
Suggested Fix:
Ensure the database field is set to an appropriate type (e.g., Float, Decimal(10,5)), and verify that the backend preserves decimal input without rounding or truncation.
Lesson learnt:
Not all bugs are binary. Sometimes, they are… Point Five!
Let’s connect! I share common bugs, solutions, and QA tips regularly.