Bug #82744 utf8_unicode_ci. double '%'. like
Submitted: 26 Aug 2016 11:31 Modified: 26 Sep 2016 16:51
Reporter: Alex Timin Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Server: Parser Severity:S1 (Critical)
Version:5.6 OS:Linux
Assigned to: CPU Architecture:Any

[26 Aug 2016 11:31] Alex Timin 
Description:
innobd, utf8_unicode_ci

If you try to select rows containing double percent sign - '%%' - 'using "like", you'll receive records with single %, double %, etc.

How to repeat:
innobd, utf8_unicode_ci

There are identical results for two different queries:
SELECT * FROM `Article` WHERE title like '%\\%\\%%';
SELECT * FROM `Article` WHERE title like '%\\%';

Returned result (two rows):
Test \\\ 50 % __ event ||
Test \ article %% en

Suggested fix:
Bug appeared  for utf8_unicode_ci - encoded columns.
[26 Aug 2016 16:51] MySQL Verification Team 
Hello Alex,

Thank you for the report.
Please could you attach repeatable test case(create table statement, sample and data) to the bug report?

Thanks,
Umesh
[27 Sep 2016 1:00] Bugs System 
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".