← Back to branch summary

~vadim-tk/percona-server/percona-5.5.15-galera

« back to all changes in this revision

Viewing changes to mysql-test/suite/sys_vars/r/myisam_use_mmap_basic.result

  • Committer: root
  • Date: 2011-09-10 16:37:18 UTC
  • Revision ID: root@r815.office.percona.com-20110910163718-ydh4zj8hcdgoyavb
Porting Galera to 5.5.15

Show diffs side-by-side

added added

removed removed

Lines of Context:
mysql-test/suite/sys_vars/r/myisam_use_mmap_basic.result
 
1
'#---------------------BS_STVARS_042_01----------------------#'
 
2
SELECT COUNT(@@GLOBAL.myisam_use_mmap);
 
3
COUNT(@@GLOBAL.myisam_use_mmap)
 
4
1
 
5
1 Expected
 
6
'#---------------------BS_STVARS_042_02----------------------#'
 
7
"BUG:It should give error on setting this variable as it is readonly variable"
 
8
Expected error 'Read only variable'
 
9
SELECT COUNT(@@GLOBAL.myisam_use_mmap);
 
10
COUNT(@@GLOBAL.myisam_use_mmap)
 
11
1
 
12
1 Expected
 
13
'#---------------------BS_STVARS_042_03----------------------#'
 
14
SELECT IF(@@GLOBAL.myisam_use_mmap, "ON", "OFF") = VARIABLE_VALUE
 
15
FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
 
16
WHERE VARIABLE_NAME='myisam_use_mmap';
 
17
IF(@@GLOBAL.myisam_use_mmap, "ON", "OFF") = VARIABLE_VALUE
 
18
1
 
19
1 Expected
 
20
SELECT COUNT(@@GLOBAL.myisam_use_mmap);
 
21
COUNT(@@GLOBAL.myisam_use_mmap)
 
22
1
 
23
1 Expected
 
24
SELECT COUNT(VARIABLE_VALUE)
 
25
FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 
 
26
WHERE VARIABLE_NAME='myisam_use_mmap';
 
27
COUNT(VARIABLE_VALUE)
 
28
1
 
29
1 Expected
 
30
'#---------------------BS_STVARS_042_04----------------------#'
 
31
SELECT @@myisam_use_mmap = @@GLOBAL.myisam_use_mmap;
 
32
@@myisam_use_mmap = @@GLOBAL.myisam_use_mmap
 
33
1
 
34
1 Expected
 
35
'#---------------------BS_STVARS_042_05----------------------#'
 
36
SELECT COUNT(@@myisam_use_mmap);
 
37
COUNT(@@myisam_use_mmap)
 
38
1
 
39
1 Expected
 
40
SELECT COUNT(@@local.myisam_use_mmap);
 
41
ERROR HY000: Variable 'myisam_use_mmap' is a GLOBAL variable
 
42
Expected error 'Variable is a GLOBAL variable'
 
43
SELECT COUNT(@@SESSION.myisam_use_mmap);
 
44
ERROR HY000: Variable 'myisam_use_mmap' is a GLOBAL variable
 
45
Expected error 'Variable is a GLOBAL variable'
 
46
SELECT COUNT(@@GLOBAL.myisam_use_mmap);
 
47
COUNT(@@GLOBAL.myisam_use_mmap)
 
48
1
 
49
1 Expected
 
50
SELECT myisam_use_mmap = @@SESSION.myisam_use_mmap;
 
51
ERROR 42S22: Unknown column 'myisam_use_mmap' in 'field list'
 
52
Expected error 'Readonly variable'