[MDEV-6661] PI() does not work well in UCS2/UTF16/UTF32 context Created: 2014-08-29  Updated: 2014-10-01  Resolved: 2014-09-02

Status: Closed
Project: MariaDB Server
Component/s: None
Affects Version/s: 5.3.12, 5.5.39, 10.0.14
Fix Version/s: 10.0.14

Type: Bug Priority: Major
Reporter: Alexander Barkov Assignee: Alexander Barkov
Resolution: Fixed Votes: 0
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.
Generated at Thu Feb 08 07:13:39 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.