Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
5.3.12, 5.5.39, 10.0.14
-
None
-
None
Description
MariaDB [test]> SELECT CONCAT(CONVERT('pi' USING ucs2),PI()) AS bad, CONCAT(CONVERT('pi' USING ucs2),CONCAT(PI())) AS good;
|
+----------------+------------+
|
| bad | good |
|
+----------------+------------+
|
| pi㌮ㄴㄵ㤳 | pi3.141593 |
|
+----------------+------------+
|
1 row in set (0.00 sec)
|
The first column with PI() produces a wrong value.
The second column with CONCAT(PI()) returns a good value.
The first column should be fixed to return the same value with the second one.