1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
|
call mtr.add_suppression("Next log extension.* Remaining log filename extensions.");
RESET MASTER;
include/assert.inc [Assert that filename is same in both file system and show binary logs]
include/assert.inc [Assert that file is created and opened]
RESET MASTER TO 1234;
include/assert.inc [Assert that filename is same in both file system and show binary logs]
include/assert.inc [Assert that file is created and opened]
RESET MASTER TO 1.023;
ERROR 42000: Only integers allowed as number here near '1.023' at line 1
RESET MASTER TO -123;
ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-123' at line 1
RESET MASTER TO 2000000000;
include/assert.inc [Assert that filename is same in both file system and show binary logs]
include/assert.inc [Assert that file is created and opened]
RESET MASTER TO 2000000001;
ERROR HY000: The requested value '2000000001' for the next binary log index is out of range. Please use a value between '1' and '2000000000'.
RESET MASTER TO 5000000000;
ERROR HY000: The requested value '5000000000' for the next binary log index is out of range. Please use a value between '1' and '2000000000'.
RESET MASTER TO 20000000000000000000;
ERROR 42000: Only integers allowed as number here near '20000000000000000000' at line 1
RESET MASTER TO 0;
ERROR HY000: The requested value '0' for the next binary log index is out of range. Please use a value between '1' and '2000000000'.
RESET MASTER TO q;
ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'q' at line 1
RESET MASTER TO "qwe";
ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '"qwe"' at line 1
RESET MASTER TO @;
ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '@' at line 1
CREATE USER user1@localhost IDENTIFIED BY 'pass1';
RESET MASTER TO 100;
ERROR 42000: Access denied; you need (at least one of) the RELOAD or FLUSH_TABLES privilege(s) for this operation
GRANT RELOAD ON *.* TO 'user1'@'localhost';
RESET MASTER TO 100;
include/assert.inc [Assert that filename is same in both file system and show binary logs]
include/assert.inc [Assert that file is created and opened]
RESET MASTER TO 0xF;
include/assert.inc [Assert that filename is same in both file system and show binary logs]
include/assert.inc [Assert that file is created and opened]
RESET MASTER TO 0x0;
ERROR HY000: The requested value '0' for the next binary log index is out of range. Please use a value between '1' and '2000000000'.
RESET MASTER TO 0xFFFF;
include/assert.inc [Assert that filename is same in both file system and show binary logs]
include/assert.inc [Assert that file is created and opened]
RESET MASTER TO 0x7FFFFFFF;
ERROR HY000: The requested value '2147483647' for the next binary log index is out of range. Please use a value between '1' and '2000000000'.
CREATE FUNCTION f1(a int) RETURNS INT RETURN (a+10);
RESET MASTER TO f1(3);
ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'f1(3)' at line 1
RESET MASTER TO 2000000000;
FLUSH BINARY LOGS;
FLUSH BINARY LOGS;
include/assert_grep.inc [Found the expected log exhaustion warnings in the error log.]
DROP USER 'user1'@'localhost';
DROP FUNCTION f1;
RESET MASTER;
|
