Roundup Tracker - Issues

Message5209

Author jerrykan
Recipients jerrykan
Date 2015-02-10.02:39:38
Message-id <1423535979.25.0.762708162256.issue2550868@psf.upfronthosting.co.za>
In-reply-to
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)
History
Date User Action Args
2015-02-10 02:39:39jerrykansetrecipients: + jerrykan
2015-02-10 02:39:39jerrykansetmessageid: <1423535979.25.0.762708162256.issue2550868@psf.upfronthosting.co.za>
2015-02-10 02:39:39jerrykanlinkissue2550868 messages
2015-02-10 02:39:38jerrykancreate