Details
-
New Feature
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Won't Do
-
None
-
None
Description
jdbc connector 3.x added zeros in the digit part for double(M,D) up to D.
jdbc connector 2.7 truncates the zeroes
3.x behaviour is identical to standard client.
MariaDB [dbs3]> select cast(0.18174900 as double),cast(0.18174900 as double(24,8)),cast(0.18174900 as double(24,7)); |
+----------------------------+----------------------------------+----------------------------------+
|
| cast(0.18174900 as double) | cast(0.18174900 as double(24,8)) | cast(0.18174900 as double(24,7)) | |
+----------------------------+----------------------------------+----------------------------------+
|
| 0.181749 | 0.18174900 | 0.1817490 | |
+----------------------------+----------------------------------+----------------------------------+
|
1 row in set (0,000 sec) |
For compatibility reason, an option could be useful like
no_pad_for_digits
where default value is no/0
Attachments
Issue Links
- relates to
-
CONJ-558 JDBC driver adds extra .0 to DOUBLEs that MySQL driver doesn't
-
- Closed
-