Roundup Tracker - Issues

Message7604

Author rouilj
Recipients rouilj
Date 2022-07-10.19:42:55
Message-id <1657482176.05.0.761868477754.issue2551216@roundup.psfhosted.org>
In-reply-to
The travisci config edits back_mysql.py adding:

  COLLATE utf8_general_ci

to avoid the crash reported on three tests:

 mysqlIndexerTest.test_unicode:

  OperationalError: (1366, "Incorrect string value: '\\xD0\\xA2\\xD0\\x95\\xD0\\x9A...' for 
column '_word' at row 1")
   
 mysqlDBTest.testFilteringStringExactMatch and mysqlRestTest.testGetExactMatch:
  OperationalError: (1253, "COLLATION 'utf8_bin' is not valid for CHARACTER SET 'latin1'")

AFAICT it has no effect on existing databases and also seems to not be required when running
under python3. I am not sure why this is true. I can't find anything in the release notes
(https://dev.mysql.com/doc/relnotes/connector-python/en/) that seems to explain this.
This change does pass with python3.

So I am putting it in the 2.2.0 release.

Also reverting the travisci hotfix.
History
Date User Action Args
2022-07-10 19:42:56rouiljsetrecipients: + rouilj
2022-07-10 19:42:56rouiljsetmessageid: <1657482176.05.0.761868477754.issue2551216@roundup.psfhosted.org>
2022-07-10 19:42:56rouiljlinkissue2551216 messages
2022-07-10 19:42:55rouiljcreate