← Back to branch summary

~ubuntu-branches/ubuntu/trusty/mysql-5.6/trusty

« back to all changes in this revision

Viewing changes to mysql-test/r/host_cache_size_functionality.result

  • Committer: Package Import Robot
  • Author(s): James Page
  • Date: 2014-02-12 11:54:27 UTC
  • Revision ID: package-import@ubuntu.com-20140212115427-oq6tfsqxl1wuwehi
Tags: upstream-5.6.15
Import upstream version 5.6.15

Show diffs side-by-side

added added

removed removed

Lines of Context:
mysql-test/r/host_cache_size_functionality.result
 
1
'#________________________VAR_06_Host_Cache_Size__________________#'
 
2
echo '##'
 
3
--echo '#---------------------WL6372_VAR_6_01----------------------#'
 
4
####################################################################
 
5
#   Checking default value                                         #
 
6
####################################################################
 
7
SELECT COUNT(@@GLOBAL.Host_Cache_Size)
 
8
1 Expected
 
9
set @Default_host_cache_size=(select if(if(@@global.max_connections<500,128+@@global.max_connections,128+@@global.max_connections+floor((@@global.max_connections-500)/20))>2000,2000,if(@@global.max_connections<500,128+@@global.max_connections,128+@@global.max_connections+floor((@@global.max_connections-500)/20))));
 
10
select @@global.Host_Cache_Size=@Default_host_cache_size;
 
11
@@global.Host_Cache_Size=@Default_host_cache_size
 
12
1
 
13
1 Expected
 
14
'#---------------------WL6372_VAR_6_02----------------------#'
 
15
# Restart server with Host_Cache_Size 1
 
16
SELECT @@GLOBAL.Host_Cache_Size;
 
17
@@GLOBAL.Host_Cache_Size
 
18
1
 
19
1 Expected
 
20
set @Default_host_cache_size=(select if(if(@@global.max_connections<500,128+@@global.max_connections,128+@@global.max_connections+floor((@@global.max_connections-500)/20))>2000,2000,if(@@global.max_connections<500,128+@@global.max_connections,128+@@global.max_connections+floor((@@global.max_connections-500)/20))));
 
21
SET @@GLOBAL.Host_Cache_Size=DEFAULT;
 
22
select @@global.Host_Cache_Size=@Default_host_cache_size;
 
23
@@global.Host_Cache_Size=@Default_host_cache_size
 
24
1
 
25
1 Expected
 
26
'#---------------------WL6372_VAR_6_03----------------------#'
 
27
SET @@local.Host_Cache_Size=1;
 
28
ERROR HY000: Variable 'host_cache_size' is a GLOBAL variable and should be set with SET GLOBAL
 
29
Expected error 'Global variable'
 
30
SET @@session.Host_Cache_Size=1;
 
31
ERROR HY000: Variable 'host_cache_size' is a GLOBAL variable and should be set with SET GLOBAL
 
32
Expected error 'Global variable'
 
33
SET @@GLOBAL.Host_Cache_Size=1;
 
34
SET @@GLOBAL.Host_Cache_Size=DEFAULT;
 
35
SELECT COUNT(@@GLOBAL.Host_Cache_Size);
 
36
COUNT(@@GLOBAL.Host_Cache_Size)
 
37
1
 
38
1 Expected
 
39
select @@global.Host_Cache_Size=@Default_host_cache_size;
 
40
@@global.Host_Cache_Size=@Default_host_cache_size
 
41
1
 
42
1 Expected
 
43
'#---------------------WL6372_VAR_6_04----------------------#'
 
44
SELECT @@GLOBAL.Host_Cache_Size = VARIABLE_VALUE
 
45
FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
 
46
WHERE VARIABLE_NAME='Host_Cache_Size';
 
47
@@GLOBAL.Host_Cache_Size = VARIABLE_VALUE
 
48
1
 
49
1 Expected
 
50
SELECT COUNT(@@GLOBAL.Host_Cache_Size);
 
51
COUNT(@@GLOBAL.Host_Cache_Size)
 
52
1
 
53
1 Expected
 
54
SELECT COUNT(VARIABLE_VALUE)
 
55
FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 
 
56
WHERE VARIABLE_NAME='Host_Cache_Size';
 
57
COUNT(VARIABLE_VALUE)
 
58
1
 
59
1 Expected
 
60
'#---------------------WL6372_VAR_6_05----------------------#'
 
61
SELECT @@Host_Cache_Size = @@GLOBAL.Host_Cache_Size;
 
62
@@Host_Cache_Size = @@GLOBAL.Host_Cache_Size
 
63
1
 
64
1 Expected
 
65
SELECT COUNT(@@local.Host_Cache_Size);
 
66
ERROR HY000: Variable 'host_cache_size' is a GLOBAL variable
 
67
Expected error 'Variable is a GLOBAL variable'
 
68
SELECT COUNT(@@SESSION.Host_Cache_Size);
 
69
ERROR HY000: Variable 'host_cache_size' is a GLOBAL variable
 
70
Expected error 'Variable is a GLOBAL variable'
 
71
SELECT COUNT(@@GLOBAL.Host_Cache_Size);
 
72
COUNT(@@GLOBAL.Host_Cache_Size)
 
73
1
 
74
1 Expected
 
75
SELECT Host_Cache_Size = @@SESSION.Host_Cache_Size;
 
76
ERROR 42S22: Unknown column 'Host_Cache_Size' in 'field list'
 
77
Expected error 'Unknown column Host_Cache_Size in field list'
 
78
SET @@GLOBAL.Host_Cache_Size=DEFAULT;