#23557quoteStrForLike does not properly escape strings in sql_mode NO_BACKSLASH_ESCAPES
Description
In this mode MySQL expects the quoting character to be explicitly set:
e.g.
SELECT ‘David_’ LIKE ‘David\_’ ESCAPE ‘\’;
Solution:
set sql_mode=’‘ during DBinit
Note:
It has to be checked if this is a proper solution and if this needs a bulletin.
SET sql_mode=‘NO_BACKSLASH_ESCAPES’;
(issue imported from #M15737)
Reviews 0
No change resolves or names this issue in its commit message, and no comment links one.