Details
-
Bug
-
Status: Confirmed (View Workflow)
-
Minor
-
Resolution: Unresolved
-
10.5.13, 10.3.36, 10.5.17
-
None
Description
See below. The GROUP_CONCAT is missing the last two characters.
+---------------------------------------+
|
| VERSION() |
|
+---------------------------------------+
|
| 10.5.13-MariaDB-1:10.5.13+maria~focal | |
+---------------------------------------+
|
1 row in set (0.000 sec) |
 |
MariaDB [(none)]> select GROUP_CONCAT(a) FROM (SELECT CONCAT(conv('38681F000', 16, 10) / conv('38681F400', 16, 10) * 100 - 100, 'AFTER') as a) xxx; |
+------------------------------+
|
| GROUP_CONCAT(a) |
|
+------------------------------+
|
| -0.0000067628410249653825AFT | |
+------------------------------+
|
1 row in set (0.000 sec) |
Just the CONCAT is fine:
MariaDB [(none)]> SELECT CONCAT(conv('38681F000', 16, 10) / conv('38681F400', 16, 10) * 100 - 100, 'AFTER');
|
+------------------------------------------------------------------------------------+
|
| CONCAT(conv('38681F000', 16, 10) / conv('38681F400', 16, 10) * 100 - 100, 'AFTER') |
|
+------------------------------------------------------------------------------------+
|
| -0.0000067628410249653825AFTER |
|
+------------------------------------------------------------------------------------+
|
1 row in set (0.000 sec)
|
This was initially hit with real data in column type float, but above is same issue with no need for the table. The conv() is needed to get original float values. Just selecting them the two print the same.
Attachments
Issue Links
- links to