I have a table that stores DOUBLE values. Frequently these are non-decimal values.
When I issue the following query via Workbench:
Workbench gives me the expected results (importantly, so does the MySQL JDBC driver when connecting to a MySQL 5.6 database):
When I do the same via Connector/J to a MariaDB 10.1.29 database the string representation of the number via getString() adds a trailing .0 as follows:
I thought at first it might be a Connector/J or Mariadb server setting, but I can't find anything, so looks like incompatible behavior.