Debian Codegraph @

mysql-test/suite/binlog/r/binlog_reset_master_to_option.result

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