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