Data problems after uplift from version 5.1.49 to 8.0.23

[Elvinas Paskauskas]

Good Afternoon,

I have recently updated the mysql-connector from version 5.1.49 to version 8.0.23. On version 5.1.49 float and double database datatype values which do not contain a number after the decimal point used to return a resultset from the database as an integer values (so 7.0 used to return as 7). Now that we have upgraded the sql-connector, float and double values which do not have any numbers after the decimal point return as 7.0

So to summarize in version 5.1.49 float values without a number after a decimal point return without the decimal point.(7.0 returns as 7)
And now in version 8.0.23 float values without a number after the decimal point return with the decimal point.(7.0 returns as 7.0)

So my question is whether there is some sort of configuration where we can ignore the .0 after the decimal point if a float or double value doesn't contain any numbers after the decimal point, so the query resultset will return exactly like the version previous to 8.x.x. (7.0 returns as 7).

Note: We are not looking to modify our querys we are explicitly looking for a matching resultset after the query is executed through java code.

If someone could give us an answer on why this happens it would be greatly appreciated.

Kind regards,
Elvinas.