[MDEV-10865] COLLATE keyword doesn't work in PREPARE query - Jira

Type: Bug
Status: Closed (View Workflow)
Priority: Major
Resolution: Fixed
Affects Version/s: 5.5(EOL), 10.0(EOL), 10.1(EOL), 10.2(EOL), 10.3(EOL), 10.4(EOL), 10.5, 10.6, 10.7(EOL), 10.8(EOL), 10.9(EOL), 10.10(EOL)
Fix Version/s: 11.6.0, 10.11.9, 11.1.6, 11.2.5, 11.4.3, 11.5.2
Component/s: Character Sets
Labels:
- django
- upstream

COLLATE keyword doesn't work in PREPARE query.
Example :

CREATE TABLE IF NOT EXISTS `tt` (

    `test` varchar(500) COLLATE utf8mb4_unicode_ci NOT NULL

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

SELECT * FROM `tt` WHERE `test` LIKE  'jj' COLLATE utf8mb4_unicode_ci

Text work well

	PREPARE stmt FROM 'SELECT * FROM `tt` WHERE `test` LIKE  ? COLLATE utf8mb4_unicode_ci'

will throw an error

Erreur SQL (1253) : COLLATION 'utf8mb4_unicode_ci' is not valid for CHARACTER SET 'binary'"

In PREPARE, collate is always considering character set as binary.

causes

CONJ-345 Regression with unexpected collation error

relates to

MDEV-16708 Unsupported commands for prepared statements

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.

MariaDB Server