← Back to branch summary

~ubuntu-branches/ubuntu/utopic/mariadb-5.5/utopic-security

« back to all changes in this revision

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

  • Committer: Package Import Robot
  • Author(s): Otto Kekäläinen
  • Date: 2014-08-27 21:12:36 UTC
  • mfrom: (2.1.6 sid)
  • Revision ID: package-import@ubuntu.com-20140827211236-se41hwfe4xy0hpef
http://bugs.debian.org/759309
http://bugs.debian.org/759813
* d/control: Removed Provides: libmysqlclient-dev (Closes: #759309)
* d/control: Removed Provides: libmysqld-dev with same motivation
* Re-introduced tha HPPA build patch as the upstream fix wasn't complete
* Fixed all kFreeBSD build and test suite issues
* Added Italian translation (Closes: #759813)

Show diffs side-by-side

added added

removed removed

Lines of Context:
mysql-test/suite/sys_vars/r/innodb_simulate_comp_failures_basic.result
 
1
SET @start_global_value = @@global.innodb_simulate_comp_failures;
 
2
SELECT @start_global_value;
 
3
@start_global_value
 
4
0
 
5
Valid values are between 0 and 99
 
6
select @@global.innodb_simulate_comp_failures between 0 and 99;
 
7
@@global.innodb_simulate_comp_failures between 0 and 99
 
8
1
 
9
select @@global.innodb_simulate_comp_failures;
 
10
@@global.innodb_simulate_comp_failures
 
11
0
 
12
select @@session.innodb_simulate_comp_failures;
 
13
ERROR HY000: Variable 'innodb_simulate_comp_failures' is a GLOBAL variable
 
14
show global variables like 'innodb_simulate_comp_failures';
 
15
Variable_name   Value
 
16
innodb_simulate_comp_failures   0
 
17
show session variables like 'innodb_simulate_comp_failures';
 
18
Variable_name   Value
 
19
innodb_simulate_comp_failures   0
 
20
select * from information_schema.global_variables where variable_name='innodb_simulate_comp_failures';
 
21
VARIABLE_NAME   VARIABLE_VALUE
 
22
INNODB_SIMULATE_COMP_FAILURES   0
 
23
select * from information_schema.session_variables where variable_name='innodb_simulate_comp_failures';
 
24
VARIABLE_NAME   VARIABLE_VALUE
 
25
INNODB_SIMULATE_COMP_FAILURES   0
 
26
set global innodb_simulate_comp_failures=10;
 
27
select @@global.innodb_simulate_comp_failures;
 
28
@@global.innodb_simulate_comp_failures
 
29
10
 
30
select * from information_schema.global_variables where variable_name='innodb_simulate_comp_failures';
 
31
VARIABLE_NAME   VARIABLE_VALUE
 
32
INNODB_SIMULATE_COMP_FAILURES   10
 
33
select * from information_schema.session_variables where variable_name='innodb_simulate_comp_failures';
 
34
VARIABLE_NAME   VARIABLE_VALUE
 
35
INNODB_SIMULATE_COMP_FAILURES   10
 
36
set session innodb_simulate_comp_failures=1;
 
37
ERROR HY000: Variable 'innodb_simulate_comp_failures' is a GLOBAL variable and should be set with SET GLOBAL
 
38
set global innodb_simulate_comp_failures=1.1;
 
39
ERROR 42000: Incorrect argument type to variable 'innodb_simulate_comp_failures'
 
40
set global innodb_simulate_comp_failures=1e1;
 
41
ERROR 42000: Incorrect argument type to variable 'innodb_simulate_comp_failures'
 
42
set global innodb_simulate_comp_failures="foo";
 
43
ERROR 42000: Incorrect argument type to variable 'innodb_simulate_comp_failures'
 
44
set global innodb_simulate_comp_failures=-7;
 
45
Warnings:
 
46
Warning 1292    Truncated incorrect innodb_simulate_comp_failures value: '-7'
 
47
select @@global.innodb_simulate_comp_failures;
 
48
@@global.innodb_simulate_comp_failures
 
49
0
 
50
select * from information_schema.global_variables where variable_name='innodb_simulate_comp_failures';
 
51
VARIABLE_NAME   VARIABLE_VALUE
 
52
INNODB_SIMULATE_COMP_FAILURES   0
 
53
set global innodb_simulate_comp_failures=106;
 
54
Warnings:
 
55
Warning 1292    Truncated incorrect innodb_simulate_comp_failures value: '106'
 
56
select @@global.innodb_simulate_comp_failures;
 
57
@@global.innodb_simulate_comp_failures
 
58
99
 
59
select * from information_schema.global_variables where variable_name='innodb_simulate_comp_failures';
 
60
VARIABLE_NAME   VARIABLE_VALUE
 
61
INNODB_SIMULATE_COMP_FAILURES   99
 
62
set global innodb_simulate_comp_failures=0;
 
63
select @@global.innodb_simulate_comp_failures;
 
64
@@global.innodb_simulate_comp_failures
 
65
0
 
66
set global innodb_simulate_comp_failures=99;
 
67
select @@global.innodb_simulate_comp_failures;
 
68
@@global.innodb_simulate_comp_failures
 
69
99
 
70
set global innodb_simulate_comp_failures=DEFAULT;
 
71
select @@global.innodb_simulate_comp_failures;
 
72
@@global.innodb_simulate_comp_failures
 
73
0
 
74
SET @@global.innodb_simulate_comp_failures = @start_global_value;
 
75
SELECT @@global.innodb_simulate_comp_failures;
 
76
@@global.innodb_simulate_comp_failures
 
77
0