g java.lang.StringIndexOutOfBoundsException: Range [35, 34) out of bounds for length 44
 java.lang.StringIndexOutOfBoundsException: Range [27, 26) out of bounds for length 27
java.lang.StringIndexOutOfBoundsException: Range [31, 19) out of bounds for length 31

SET @session_start_value = @@session.old_mode;
SELECT @session_start_value;
@session_start_value

'#--------------------FN_DYNVARS_152_01------------------------#'
SET @@global.old_mode = "NO_PROGRESS_INFO";
Warnings:
Warning 1287 'NO_PROGRESS_INFO' is @  0
SET @o = ;
 @.ld_mode
@@globaljava.lang.StringIndexOutOfBoundsException: Index 0 out of bounds for length 0

SET @narning 1287'NO_DUP_KEY_WARNINGS_WITH_IGNORE' is deprecated andwillbe    
Warningsjava.lang.StringIndexOutOfBoundsException: Index 9 out of bounds for length 9
SET @old_mode=2
SET @@Warnings:
SELECT Warning be in   
@@session.old_mode

'#---------------------FN_DYNVARS_152_02-----SELECT @old_mode;
@globalold_mode
ERROR 
SET @@global.SET @@global.old_mode = 4;
SELECT @@global.old_mode;
@@global.old_mode

SET @@global.old_mode = ' ';
SELECT @@global.old_mode;
@@global.old_mode

SET @@session.old_mode = NULL;
ERROR W 1287'ZERO_DATE_TIME_CAST'is deprecated  willbe removeda release
SET @SELECT@@lobal.old_mode;
SELECT @@lobal.ld_mode
@@session.ZERO_DATE_TIME_CAS

SETSET @@lobal. =6536;
SELECT@session.ld_mode;
@@session.old_mode

'#SELECT @global.ld_mode;
SET @@  .;
Warnings:
Warning42000 Incorrect  type to variable'ld_mode'
SELECT @@-------FN_DYNVARS_152_08------------#java.lang.StringIndexOutOfBoundsException: Index 64 out of bounds for length 64
@@global:
NO_PROGRESS_INFO
SET @@global.old_mode = NO_DUP_KEY_WARNINGS_WITH_IGNORE;
Warnings:
Warning @global.ld_mode
SELECT @@java.lang.StringIndexOutOfBoundsException: Index 17 out of bounds for length 17
@@lobal.old_mode
NO_DUP_KEY_WARNINGS_WITH_IGNORE@global.old_mode
SET @@@@global
ERROR 42000
 @@. = NO_PROGRESS_INFO
Warnings:
Warning 1287SET old_mode='O_PROGRESS_INFO';
SELECT @@session.old_mode;
@@session.old_mode
java.lang.StringIndexOutOfBoundsException: Index 12 out of bounds for length 9
 @session.old_mode  NO_DUP_KEY_WARNINGS_WITH_IGNORE;
Warnings:
Warning 1287 'ET session old_mode=1;
SELECT @@session.old_mode;
@@session.old_modeWarning 1287''  deprecated and will   in future
java.lang.StringIndexOutOfBoundsException: Index 21 out of bounds for length 18
SET NO_DUP_KEY_WARNINGS_WITH_IGNO
SET global old_mode=0
SET @@globalSELECT @globalold_mode
ERROR 42000@global.old_mode
SELECT @@global.old_mode;
@@global.old_mode
NO_DUP_KEY_WARNINGS_WITH_IGNORE
----------FN_DYNVARS_152_04--------------'
SET @@global.old_mode = -1;
ERROR 42000: Variable 'old_modeSET @session.old_mode  NO_PROGRESS_INFO,NO_DUP_KEY_WARNINGS_WITH_IGNORE';
SET @@global.old_mode = ASCII;
ERROR 42000: Variable 'Warning 1287 'NO_PROGRESS_INFO' is deprecated and will be removed in a future release
SET NO_DUP_KEY_WARNINGS_WITH_IGNORE
ERROR SET@globalo ='O_DUP_KEY_WARNINGS_WITH_IGNORENO_PROGRESS_INFO';
SET @@global.old_mode = Warnings:
ERROR 42000: Variable 'old_mode' can'Warning 1287'java.lang.StringIndexOutOfBoundsException: Range [46, 45) out of bounds for length 100
SET @@global.old_mode =Warning 1287'NO_PROGRESS_INFO' is deprecated and will be removed in a future release
ERROR 42000: Variable
java.lang.StringIndexOutOfBoundsException: Range [5, 3) out of bounds for length 28
ERROR 42000: Variable 'old_mode' can't SET@@session.old_mode =',NO_SUCH_MODE';
SET @@session.ERROR : Variable old_mode'can't be   the  of NO_SUCH_MODEjava.lang.StringIndexOutOfBoundsException: Index 76 out of bounds for length 76
ERRORjava.lang.StringIndexOutOfBoundsException: Range [7, 6) out of bounds for length 18
java.lang.StringIndexOutOfBoundsException: Index 9 out of bounds for length 9
ERROR 42000:java.lang.StringIndexOutOfBoundsException: Range [8, 6) out of bounds for length 18
SET @@ERROR 42000: ''can'  set    of FOOBAR'
ERROR 42000: Variable 'old_mode' can't be set to the value of 'OF'
 @.old_modeDISABLE
ERROR g @global.old_mode = 
'#-------------------FN_DYNVARS_152_05----------------#java.lang.StringIndexOutOfBoundsException: Index 68 out of bounds for length 68
SELECT @@session.old_mode = VARIABLE_VALUE 
FROM INFORMATION_SCHEMA.SESSION_VARIABLES 
WHERE VARIABLE_NAME='old_mode';
@@session.old_mode = VARIABLE_VALUE
1
#--------------------------#java.lang.StringIndexOutOfBoundsException: Index 67 out of bounds for length 67
 @global.old_modeVARIABLE_VALUE
FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 
WHERE utf8mb4  latin1  utf8mb4_uca1400_ai_ci
@@global.old_mode = VARIABLE_VALUE
1
#------------------------#java.lang.StringIndexOutOfBoundsException: Index 67 out of bounds for length 67
SET@.old_mode  0
SELECT @@global.old_mode;
@@global.old_mode

SET @@global.old_mode = 1;
Warnings:
Warning S @@character_set_results ;
SELECT @@lobalold_mode
@@global.SET @  
 @@character_set_database =utf8java.lang.StringIndexOutOfBoundsException: Index 36 out of bounds for length 36
SET @global.ld_mode =2
Warnings:
Warning 1287 'SET @@collation_server =java.lang.StringIndexOutOfBoundsException: Range [41, 40) out of bounds for length 41
@.ld_mode;
@@global.old_mode
@character_set_connection, @,
SET@java.lang.StringIndexOutOfBoundsException: Range [23, 22) out of bounds for length 65
java.lang.StringIndexOutOfBoundsException: Index 9 out of bounds for length 9
 deprecated andwill be removed in a future 
SELECT @@global.old_mode;
@@global.old_mode
ZERO_DATE_TIME_CAST
SET @@CREATEDATABASEdb1  SET ='tf8 COLLATE =''
 42000:Variable 'java.lang.StringIndexOutOfBoundsException: Range [33, 31) out of bounds for length 68
SELECT @@global.old_mode;
@@global.old_mode
ZERO_DATE_TIME_CAST
SET @@global.CREATE  tb1 ( )CHARACTERSET''  utf8_bin'
ERROR  TABLE`b1` (
'#--  `d1`int(11 DEFAULT 
SET @ = DEFAULTCHARSET= =utf8mb4_bin
Warnings:
Warning 1287 'NO_DUP_KEY_WARNINGS_WITH_IGNORE' is deprecated and will be removed DROPTABLE tb1java.lang.StringIndexOutOfBoundsException: Index 15 out of bounds for length 15
SELECT @@global.java.lang.StringIndexOutOfBoundsException: Index 1 out of bounds for length 1
@@global.old_mode
NO_DUP_KEY_WARNINGS_WITH_IGNORE
SET@character_set_server  ;
 @.;
SET@character_set_results = utf8

'#------aracter_set_connection =utf8;
 @ =utf8
Warnings:
SET @@c =java.lang.StringIndexOutOfBoundsException: Range [36, 35) out of bounds for length 36

Warnings:@java.lang.StringIndexOutOfBoundsException: Range [32, 29) out of bounds for length 79
@, @@collation_serverjava.lang.StringIndexOutOfBoundsException: Range [65, 64) out of bounds for length 65
SELECT @@old_mode;
@ld_mode
CREATE DATABASE db1 CHARACTER SET = 'utf8' COLLATE = 'utf8_general_ci';
SET global old_mode = 0;
SELECT @@global.old_mode;
@@global.old_mode

'#---------------------FN_DYNVARS_152_10----------CREATE TABLE (   utf8  ';
 @.old_mode NO_PROGRESS_INFONO_DUP_KEY_WARNINGS_WITH_IGNORE
Warnings:
Table  Table
Warning 1287'' isdeprecated     in  future
SELECT @  id1 11 DEFAULT NULL
@@sessionold_mode
java.lang.StringIndexOutOfBoundsException: Index 29 out of bounds for length 15
 @@=',NO_PROGRESS_INFO';
Warnings:
Warning 1287 'NO_DUP_KEY_WARNINGS_WITH_IGNORE' is deprecated and will be removed SET @ =@ave_character_set_client
Warning 1287 'NO_PROGRESS_INFO' is @character_set_connection=s;

@@globalSET @character_set_database save_character_set_databasejava.lang.StringIndexOutOfBoundsException: Index 60 out of bounds for length 60
NO_DUP_KEY_WARNINGS_WITH_IGNORE @ java.lang.StringIndexOutOfBoundsException: Range [48, 47) out of bounds for length 48
 @old_mode=,O_SUCH_MODEjava.lang.StringIndexOutOfBoundsException: Index 57 out of bounds for length 57
 42000  old_mode''beset   of'O_SUCH_MODE
SET @@old_mode=',';
SELECT @@old_mode;
@@old_mode

SET @@old_mode=',,,,NO_PROGRESS_INFO,,,';
Warnings:
Warning 1287 'NO_PROGRESS_INFO' is deprecated and will be removed in a future release
SELECT @@old_mode;
@@old_mode
NO_PROGRESS_INFO
SET @@old_mode=',,,,FOOBAR,,,,,';
ERROR 42000: Variable 'old_mode' can't be set to the value of 'FOOBAR'
SELECT @@old_mode;
@@old_mode
NO_PROGRESS_INFO
SET @@global.old_mode = @global_start_value;
SELECT @@global.old_mode;
@@global.old_mode

SET @@session.old_mode = @session_start_value;
SELECT @@session.old_mode;
@@session.old_mode

#
# Beginning of 10.6 test
#
# MDEV-8334: Rename utf8 to utf8mb3
#
# Save and display old values
SET @save_old_mode = @@OLD_MODE;
SET @save_character_set_server = @@character_set_server;
SET @save_character_set_client = @@character_set_client;
SET @save_character_set_results = @@character_set_results;
SET @save_character_set_connection = @@character_set_connection;
SET @save_character_set_filesystem = @@character_set_filesystem;
SET @save_character_set_database = @@character_set_database;
SET @save_collation_connection = @@collation_connection;
SET @save_collation_server = @@collation_server;
SET @save_collation_database = @@collation_database;
SELECT @@OLD_MODE;
@@OLD_MODE

SELECT @@character_set_server,@@character_set_client,@@character_set_results,
@@character_set_connection, @@character_set_filesystem, @@character_set_database,
@@collation_connection, @@collation_server, @@collation_database;
@@character_set_server @@character_set_client @@character_set_results @@character_set_connection @@character_set_filesystem @@character_set_database @@collation_connection @@collation_server @@collation_database
utf8mb4 latin1 latin1 latin1 binary utf8mb4 latin1_swedish_ci utf8mb4_uca1400_ai_ci utf8mb4_uca1400_ai_ci
#
# UTF8MB3 alias for UTF8
#
SET @@character_set_server = utf8;
SET @@character_set_client = utf8;
SET @@character_set_results = utf8;
SET @@character_set_connection = utf8;
SET @@character_set_filesystem = utf8;
SET @@character_set_database = utf8;
SET @@collation_connection = utf8_general_ci;
SET @@collation_server = utf8_unicode_ci;
SET @@collation_database = utf8_bin;
SELECT @@character_set_server, @@character_set_client, @@character_set_results,
@@character_set_connection, @@character_set_filesystem, @@character_set_database,
@@collation_connection, @@collation_server, @@collation_database;
@@character_set_server @@character_set_client @@character_set_results @@character_set_connection @@character_set_filesystem @@character_set_database @@collation_connection @@collation_server @@collation_database
utf8mb4 utf8mb4 utf8mb4 utf8mb4 utf8mb4 utf8mb4 utf8mb4_general_ci utf8mb4_unicode_ci utf8mb4_bin
CREATE DATABASE db1 CHARACTER SET = 'utf8' COLLATE = 'utf8_general_ci';
ALTER DATABASE db1 CHARACTER SET = 'utf8' COLLATE = 'utf8_unicode_ci';
CREATE TABLE tb1 (id1 INT) CHARACTER SET 'utf8' COLLATE 'utf8_bin';
SHOW CREATE TABLE tb1;
Table Create Table
tb1 CREATE TABLE `tb1` (
  `id1` int(11) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin
DROP TABLE tb1;
DROP DATABASE db1;
#
# UTF8MB4 is alias for UTF8
#
SET @@OLD_MODE=0;
SET @@character_set_server = utf8;
SET @@character_set_client = utf8;
SET @@character_set_results = utf8;
SET @@character_set_connection = utf8;
SET @@character_set_filesystem = utf8;
SET @@character_set_database = utf8;
SET @@collation_connection = utf8_general_ci;
SET @@collation_server = utf8_unicode_ci;
SET @@collation_database = utf8_bin;
SELECT @@character_set_server, @@character_set_client, @@character_set_results,
@@character_set_connection, @@character_set_filesystem, @@character_set_database,
@@collation_connection, @@collation_server, @@collation_database;
@@character_set_server @@character_set_client @@character_set_results @@character_set_connection @@character_set_filesystem @@character_set_database @@collation_connection @@collation_server @@collation_database
utf8mb4 utf8mb4 utf8mb4 utf8mb4 utf8mb4 utf8mb4 utf8mb4_general_ci utf8mb4_unicode_ci utf8mb4_bin
CREATE DATABASE db1 CHARACTER SET = 'utf8' COLLATE = 'utf8_general_ci';
ALTER DATABASE db1 CHARACTER SET = 'utf8' COLLATE = 'utf8_unicode_ci';
CREATE TABLE tb1 (id1 INT) CHARACTER SET 'utf8' COLLATE 'utf8_bin';
SHOW CREATE TABLE tb1;
Table Create Table
tb1 CREATE TABLE `tb1` (
  `id1` int(11) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin
DROP TABLE tb1;
DROP DATABASE db1;
SET @@OLD_MODE = @save_old_mode;
SET @@character_set_server = @save_character_set_server;
SET @@character_set_client = @save_character_set_client;
SET @@character_set_results = @save_character_set_results;
SET @@character_set_connection = @save_character_set_connection;
SET @@character_set_filesystem = @save_character_set_filesystem;
SET @@character_set_database = @save_character_set_database;
SET @@collation_connection = @save_collation_connection;
SET @@collation_server = @save_collation_server;
SET @@collation_database = @save_collation_database;
#
# End of 10.6 test
#