Open dveeden opened 2 hours ago
WITH RECURSIVE cte(n) AS ( SELECT 1 n UNION ALL SELECT 100+n FROM cte WHERE n<1000 ) SELECT FORMAT(n+RAND(),3,'en_UK') FROM cte;
With MySQL 9.0.1:
mysql-9.0.1> WITH RECURSIVE cte(n) AS (SELECT 1 n UNION ALL SELECT 100+n FROM cte WHERE n<1000) SELECT FORMAT(n+RAND(),3,'en_UK') FROM cte; +----------------------------+ | FORMAT(n+RAND(),3,'en_UK') | +----------------------------+ | 1.207 | | 101.688 | | 201.819 | | 301.030 | | 401.691 | | 501.368 | | 601.767 | | 701.731 | | 801.355 | | 901.582 | | 1,001.845 | +----------------------------+ 11 rows in set, 1 warning (0.00 sec) Warning (Code 1649): Unknown locale: 'en_UK'
mysql-8.0.11-TiDB-v8.4.0-alpha-207-gfb9b8a194f> WITH RECURSIVE cte(n) AS (SELECT 1 n UNION ALL SELECT 100+n FROM cte WHERE n<1000) SELECT FORMAT(n+RAND(),3,'en_UK') FROM cte; +----------------------------+ | FORMAT(n+RAND(),3,'en_UK') | +----------------------------+ | 1.613 | | 101.927 | | 201.795 | | 301.193 | | 401.579 | | 501.318 | | 601.854 | | 701.313 | | 801.006 | | 901.092 | | 1,001.439 | +----------------------------+ 11 rows in set, 11 warnings (0.00 sec) Warning (Code 1649): Unknown locale: ' .P��' Warning (Code 1649): Unknown locale: 'en_UK' Warning (Code 1649): Unknown locale: ' Warning (Code 1649): Unknown locale: ' .P��' Warning (Code 1649): Unknown locale: 'en_UK' Warning (Code 1649): Unknown locale: ' Warning (Code 1649): Unknown locale: ' .P��' Warning (Code 1649): Unknown locale: 'en_UK' Warning (Code 1649): Unknown locale: ' Warning (Code 1649): Unknown locale: ' .P��' Warning (Code 1649): Unknown locale: 'en_UK'
mysql-8.0.11-TiDB-v8.4.0-alpha-207-gfb9b8a194f> SELECT TIDB_VERSION()\G *************************** 1. row *************************** TIDB_VERSION(): Release Version: v8.4.0-alpha-207-gfb9b8a194f Edition: Community Git Commit Hash: fb9b8a194f8716beaee035cd0c285c30e29a9d64 Git Branch: master UTC Build Time: 2024-09-20 09:07:51 GoVersion: go1.22.7 Race Enabled: false Check Table Before Drop: false Store: unistore 1 row in set (0.00 sec)
Also happens with v8.3.0
Found this while working on #56167 / #56168
Bug Report
1. Minimal reproduce step (Required)
2. What did you expect to see? (Required)
With MySQL 9.0.1:
3. What did you see instead (Required)
4. What is your TiDB version? (Required)
Also happens with v8.3.0