[MDEV-15692] install_spider.sql can fail with some collations Created: 2018-03-27  Updated: 2020-08-25  Resolved: 2018-04-12

Status: Closed
Project: MariaDB Server
Component/s: Storage Engine - Spider
Affects Version/s: 10.2.13
Fix Version/s: 10.2.15, 10.3.6

Type: Bug Priority: Major
Reporter: Geoff Montee (Inactive) Assignee: Jacob Mathew (Inactive)
Resolution: Fixed Votes: 0
Labels: spider


 Description   

install_spider.sql can fail with the following error:

ERROR 1267 (HY000) at line 288 in file: '/usr/share/mysql/install_spider.sql': Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation '='

To reproduce, simply do:

SET NAMES utf8;
 
SET SESSION collation_server=utf8_unicode_ci;
 
source /usr/share/mysql/install_spider.sql



 Comments   
Comment by Jacob Mathew (Inactive) [ 2018-04-05 ]

Kentoku, please review my fix for this problem in commit ff0bf45 on my branch.

Comment by Kentoku Shiba (Inactive) [ 2018-04-12 ]

It's OK to push. Thank you for finding and fixing it.

Comment by Jacob Mathew (Inactive) [ 2018-04-12 ]

Fix is pushed to 10.3 and 10.2.

Generated at Thu Feb 08 08:23:18 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.