DB2 Error Code 1054 – Column not found: Unknown column ‘Infinity’ in ‘field list’

In this post, you’ll learn about the DB2 error 1054-Column not found: Unknown column ‘Infinity’ in ‘field list’ and the reason why you are receiving the error message and how to fix it

How does this Error Message Looks like

1054 – Column not found: Unknown column ‘Infinity’ in ‘field list’

Reason for the Error & Solution

MySQL disallows storage of Double.POSITIVE_INFINITY or Double.NEGATIVE_INFINITY values.