Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
1.1.4
-
None
-
None
-
2018-10, 2018-11
Description
This is a continuation of the following bug (which was fixed in 1.1.4):
https://jira.mariadb.org/browse/MCOL-1246
However, the bug does not address some edge case comparisons.
For instance, we've identified 2 cases where this is not working as expected:
1. This returns 0 results when the 'name' is "Majestic12 " (note trailing space):
SELECT name from `wpafb` where lower(name) like 'majestic12 ';
|
2. This one, I'm not as sure if it is a bug or not, but was reported nonetheless. This query finds all rows in the table whether they end in space of not:
SELECT CONCAT(name,'#') from `hangar18` where name like '% ';
|