1SET @start_global_value = @@global.histogram_type; 2SELECT @start_global_value; 3@start_global_value 4DOUBLE_PREC_HB 5SET @start_session_value = @@session.histogram_type; 6SELECT @start_session_value; 7@start_session_value 8DOUBLE_PREC_HB 9SET @@global.histogram_type = 1; 10SET @@global.histogram_type = DEFAULT; 11SELECT @@global.histogram_type; 12@@global.histogram_type 13DOUBLE_PREC_HB 14SET @@global.histogram_type = 0; 15SELECT @@global.histogram_type; 16@@global.histogram_type 17SINGLE_PREC_HB 18SET @@global.histogram_type = 1; 19SELECT @@global.histogram_type; 20@@global.histogram_type 21DOUBLE_PREC_HB 22SET @@global.histogram_type = SINGLE_PREC_HB; 23SELECT @@global.histogram_type; 24@@global.histogram_type 25SINGLE_PREC_HB 26SET @@global.histogram_type = DOUBLE_PREC_HB; 27SELECT @@global.histogram_type; 28@@global.histogram_type 29DOUBLE_PREC_HB 30SET @@session.histogram_type = 0; 31SELECT @@session.histogram_type; 32@@session.histogram_type 33SINGLE_PREC_HB 34SET @@session.histogram_type = 1; 35SELECT @@session.histogram_type; 36@@session.histogram_type 37DOUBLE_PREC_HB 38SET @@session.histogram_type = SINGLE_PREC_HB; 39SELECT @@session.histogram_type; 40@@session.histogram_type 41SINGLE_PREC_HB 42SET @@session.histogram_type = DOUBLE_PREC_HB; 43SELECT @@session.histogram_type; 44@@session.histogram_type 45DOUBLE_PREC_HB 46set sql_mode=TRADITIONAL; 47SET @@global.histogram_type = 10; 48ERROR 42000: Variable 'histogram_type' can't be set to the value of '10' 49SET @@global.histogram_type = -1024; 50ERROR 42000: Variable 'histogram_type' can't be set to the value of '-1024' 51SET @@global.histogram_type = 2.4; 52ERROR 42000: Incorrect argument type to variable 'histogram_type' 53SET @@global.histogram_type = OFF; 54ERROR 42000: Variable 'histogram_type' can't be set to the value of 'OFF' 55SET @@session.histogram_type = 10; 56ERROR 42000: Variable 'histogram_type' can't be set to the value of '10' 57SET @@session.histogram_type = -2; 58ERROR 42000: Variable 'histogram_type' can't be set to the value of '-2' 59SET @@session.histogram_type = 1.2; 60ERROR 42000: Incorrect argument type to variable 'histogram_type' 61SET @@session.histogram_type = ON; 62ERROR 42000: Variable 'histogram_type' can't be set to the value of 'ON' 63SELECT * FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 64WHERE VARIABLE_NAME='histogram_type'; 65VARIABLE_NAME VARIABLE_VALUE 66HISTOGRAM_TYPE DOUBLE_PREC_HB 67SELECT * FROM INFORMATION_SCHEMA.SESSION_VARIABLES 68WHERE VARIABLE_NAME='histogram_type'; 69VARIABLE_NAME VARIABLE_VALUE 70HISTOGRAM_TYPE DOUBLE_PREC_HB 71SET @@global.histogram_type = @start_global_value; 72SELECT @@global.histogram_type; 73@@global.histogram_type 74DOUBLE_PREC_HB 75SET @@session.histogram_type = @start_session_value; 76SELECT @@session.histogram_type; 77@@session.histogram_type 78DOUBLE_PREC_HB 79set sql_mode=''; 80