[MDEV-38836] The result returned by COERCIBILITY() is inconsistent with the documentation. - Jira

XML

Word

Printable

The document shows :

per docs
SELECT COERCIBILITY(CAST(1 AS CHAR));
+-------------------------------+
\| COERCIBILITY(CAST(1 AS CHAR)) \|
+-------------------------------+
\| 2 \|
+-------------------------------+

SELECT COERCIBILITY('abc');
+---------------------+
\| COERCIBILITY('abc') \|
+---------------------+
\| 4 \|
+---------------------+

SELECT COERCIBILITY(1);
+-----------------+
\| COERCIBILITY(1) \|
+-----------------+
\| 5 \|
+-----------------+

SELECT COERCIBILITY(NULL);
+--------------------+
\| COERCIBILITY(NULL) \|
+--------------------+
\| 6 \|
+--------------------+

However, my actual execution result is as follows:

relates to

MDEV-25829 Change default Unicode collation to uca1400_ai_ci

MDEV-35041 Simple comparison causes "Illegal mix of collations" even with default server settings

MDEV-31852 COERCIBILITY(NULL) returns 6 instead of 5

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