Can you try casting the field explicitly to float in the query and see if you still have an issue?
If you still have the issue, give a different name for this field and see if it works?
I tried converting it to the default float 4 but that didn't work.then I did float 8 and that worked!
I changed the name and that didn't work either.
Then I explicitly converted to float 8 and that worked! Any ideas why??
Good question. I don't have an answer for it though.