Message5209
The 'testFilteringSpecialChars (test.test_mysql.mysqlDBTest)' test fails
when the mysql server is configured with the following:
[mysqld]
collation_server = utf8_unicode_ci
This seems to be because the backslash escaping behaves different.
The following generated SQL seems to work fine normally:
select _issue.id from _issue where (_issue._title LIKE "%\\\\%" ESCAPE
"\\") and _issue.__retired__=0 order by _issue.id
but when 'collation_server = utf8_unicode_ci' the query needs to be
changed to the following to work:
select _issue.id from _issue where (_issue._title LIKE "%\\\\\%"
ESCAPE "\\") and _issue.__retired__=0 order by _issue.id
(note the extra backslash in the LIKE) |
|
Date |
User |
Action |
Args |
2015-02-10 02:39:39 | jerrykan | set | recipients:
+ jerrykan |
2015-02-10 02:39:39 | jerrykan | set | messageid: <1423535979.25.0.762708162256.issue2550868@psf.upfronthosting.co.za> |
2015-02-10 02:39:39 | jerrykan | link | issue2550868 messages |
2015-02-10 02:39:38 | jerrykan | create | |
|