-
Type:
Bug
-
Status: Closed (View Workflow)
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: 5.3.12, 5.5.37, 10.0.10
-
Component/s: None
-
Labels:None
SELECT
|
SUBSTRING_INDEX(_utf8'.wwwmysqlcom', _utf8'.', -2) AS c1,
|
SUBSTRING_INDEX(_latin1'.wwwmysqlcom',_latin1'.', -2) AS c2;
|
returns
+--------------+----+
|
| c1 | c2 |
|
+--------------+----+
|
| .wwwmysqlcom | |
|
+--------------+----+
|
c1 is correct, c2 is wrong.
MySQL-5.5 has the same problems.
MySQL-5.6 and 5.7 work fine.