← Back to branch summary

~ubuntu-branches/ubuntu/natty/mysql-5.1/natty-proposed

« back to all changes in this revision

Viewing changes to mysql-test/suite/binlog/r/binlog_sf.result

  • Committer: Package Import Robot
  • Author(s): Marc Deslauriers
  • Date: 2012-02-22 08:30:45 UTC
  • mfrom: (1.4.1)
  • Revision ID: package-import@ubuntu.com-20120222083045-2rd53r4bnyx7qus4
Tags: 5.1.61-0ubuntu0.11.04.1
https://launchpad.net/bugs/937869
* SECURITY UPDATE: Update to 5.1.61 to fix multiple security issues
  (LP: #937869)
  - http://www.oracle.com/technetwork/topics/security/cpujan2012-366304.html
  - CVE-2011-2262
  - CVE-2012-0075
  - CVE-2012-0112
  - CVE-2012-0113
  - CVE-2012-0114
  - CVE-2012-0115
  - CVE-2012-0116
  - CVE-2012-0117
  - CVE-2012-0118
  - CVE-2012-0119
  - CVE-2012-0120
  - CVE-2012-0484
  - CVE-2012-0485
  - CVE-2012-0486
  - CVE-2012-0487
  - CVE-2012-0488
  - CVE-2012-0489
  - CVE-2012-0490
  - CVE-2012-0491
  - CVE-2012-0492
  - CVE-2012-0493
  - CVE-2012-0494
  - CVE-2012-0495
  - CVE-2012-0496

Show diffs side-by-side

added added

removed removed

Lines of Context:
mysql-test/suite/binlog/r/binlog_sf.result
 
1
set global log_bin_trust_function_creators=0;
 
2
set binlog_format=STATEMENT;
 
3
create function fn16456()
 
4
returns int
 
5
begin
 
6
return unix_timestamp();
 
7
end|
 
8
ERROR HY000: This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable)
 
9
set global log_bin_trust_function_creators=1;
 
10
create function fn16456()
 
11
returns int
 
12
begin
 
13
return unix_timestamp();
 
14
end|
 
15
set global log_bin_trust_function_creators=0;
 
16
set binlog_format=ROW;
 
17
select fn16456();
 
18
fn16456()
 
19
timestamp
 
20
set binlog_format=STATEMENT;
 
21
select fn16456();
 
22
ERROR HY000: This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable)
 
23
drop function fn16456;
 
24
set global log_bin_trust_function_creators=0;
 
25
create function fn16456()
 
26
returns int deterministic
 
27
begin
 
28
return unix_timestamp();
 
29
end|
 
30
set binlog_format=ROW;
 
31
select fn16456();
 
32
fn16456()
 
33
timestamp
 
34
set binlog_format=STATEMENT;
 
35
select fn16456();
 
36
fn16456()
 
37
timestamp
 
38
drop function fn16456;
 
39
set global log_bin_trust_function_creators=0;
 
40
create function fn16456()
 
41
returns int no sql
 
42
begin
 
43
return unix_timestamp();
 
44
end|
 
45
set binlog_format=ROW;
 
46
select fn16456();
 
47
fn16456()
 
48
timestamp
 
49
set binlog_format=STATEMENT;
 
50
select fn16456();
 
51
fn16456()
 
52
timestamp
 
53
drop function fn16456;
 
54
set global log_bin_trust_function_creators=0;
 
55
create function fn16456()
 
56
returns int reads sql data
 
57
begin
 
58
return unix_timestamp();
 
59
end|
 
60
set binlog_format=ROW;
 
61
select fn16456();
 
62
fn16456()
 
63
timestamp
 
64
set binlog_format=STATEMENT;
 
65
select fn16456();
 
66
fn16456()
 
67
timestamp
 
68
drop function fn16456;