Details
-
Type:
Bug
-
Status: Closed (View Workflow)
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: 5.3.12, 5.5.39, 10.0.14
-
Fix Version/s: 10.0.14
-
Component/s: None
-
Labels: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.