Bug 21846: Make 'term' use utf8mb_bin collation on tags tables
authorTomas Cohen Arazi <tomascohen@theke.io>
Fri, 23 Nov 2018 19:47:05 +0000 (16:47 -0300)
committerNick Clemens <nick@bywatersolutions.com>
Fri, 15 Mar 2019 12:27:44 +0000 (12:27 +0000)
commit04f1b0ca950a5a133f6afe6785787d1982414a1e
tree085fc4bb4c7f14d9d0540f1206997db9df3d0f03
parent865f9a165d5d5e025737324843eccb5c39a74efb
Bug 21846: Make 'term' use utf8mb_bin collation on tags tables

This patch makes the utf8mb4_bin collation preferred for comparing tags.
Otherwise suppolemental unicode characters all match.

To test:

- Enable tags and disable moderation (or plan to moderate and accept tags)
- Tag 3 records:
   a - with 🐋
   b - with 🌮
   c - with 👍
- Note the weight on each says '3'
- Click the tag to search, you get back all the records
- Apply the previous patches from this bug report
- Run:
  $ kshell
 k$ prove t/db_dependent/Tags.t
=> FAIL: Tests fail, related to counting stuffs
- Apply this patch and
(a) Run updatedatabase to upgrade the schema
- Run:
 k$ prove t/db_dependent/Tags.t
=> SUCCESS: Tests pass!
(b) reset_all to get a fresh DB using kohastructure.sql
- Run:
 k$ prove t/db_dependent/Tags.t
=> SUCCESS: Tests pass too!
- Sign off :-D

Signed-off-by: Owen Leonard <oleonard@myacpl.org>

Signed-off-by: Josef Moravec <josef.moravec@gmail.com>

Signed-off-by: Nick Clemens <nick@bywatersolutions.com>
installer/data/mysql/atomicupdate/bug_21846.perl [new file with mode: 0644]
installer/data/mysql/kohastructure.sql