Issue Bug Closed

#23557quoteStrForLike does not properly escape strings in sql_mode NO_BACKSLASH_ESCAPES

Helmut Hummel 09/17/10, 19:25 updated 10/02/18, 12:22

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.