Query to Dataset Rounding Values

It is not a MySQL bug. It is a known problem. If you set a float property of a numeric text field in Ignition you would get the same result.