[MDEV-38944] collation_connection in new session is not initialized with the updated GLOBAL value. - Jira

XML

Word

Printable

collation_connection remains unchanged in a new session even after assigning a new GLOBAL value.

--echo ## check default values

SHOW VARIABLES LIKE 'collation_connection';

--echo ## assign a new value

SET SESSION collation_connection='utf8mb3_general_ci';

SET GLOBAL collation_connection='utf8mb3_general_ci';

SHOW VARIABLES LIKE 'collation_connection';

SHOW GLOBAL VARIABLES LIKE 'collation_connection';

--echo ## connect to new session and check values

--connect(con1,localhost,root,,test)

SHOW VARIABLES LIKE 'collation_connection';

SHOW GLOBAL VARIABLES LIKE 'collation_connection';

--echo ## Observe that session value is not assigned as per current global value

Actual Result
===========
In the new session, collation_connection is not initialized with the updated GLOBAL value.

Expected Result
=============
New sessions should inherit the current GLOBAL value of collation_connection.

Output of MTR testcase

## check default values

SHOW VARIABLES LIKE 'collation_connection';

Variable_name	Value

collation_connection	latin1_swedish_ci

## assign a new value

SET SESSION collation_connection='utf8mb3_general_ci';

SET GLOBAL collation_connection='utf8mb3_general_ci';

SHOW VARIABLES LIKE 'collation_connection';

Variable_name	Value

collation_connection	utf8mb3_general_ci

SHOW GLOBAL VARIABLES LIKE 'collation_connection';

Variable_name	Value

collation_connection	utf8mb3_general_ci

## connect to new session and check values

connect con1,localhost,root,,test;

SHOW VARIABLES LIKE 'collation_connection';

Variable_name	Value

collation_connection	latin1_swedish_ci

SHOW GLOBAL VARIABLES LIKE 'collation_connection';

Variable_name	Value

collation_connection	utf8mb3_general_ci

## Observe that session value is not assigned as per current global value

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