Debian Codegraph @

mysql-test/suite/rpl/r/rpl_source_pos_wait.result

raw
1 include/master-slave.inc
2 Warnings:
3 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
4 Note #### Storing MySQL user name or password information in the connection metadata repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START REPLICA; see the 'START REPLICA Syntax' in the MySQL Manual for more information.
5 [connection master]
6 SELECT source_pos_wait('master-bin.999999', 0, 1);
7 source_pos_wait('master-bin.999999', 0, 1)
8 -1
9 EXPLAIN select source_pos_wait('master-bin.999999', 0, 1);
10 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
11 1 SIMPLE NULL NULL NULL NULL NULL NULL NULL NULL NULL No tables used
12 Warnings:
13 Note 1003 /* select#1 */ select source_pos_wait('master-bin.999999',0,1) AS `source_pos_wait('master-bin.999999', 0, 1)`
14 SELECT source_pos_wait('master-bin.999999',0);
15 include/stop_slave_sql.inc
16 source_pos_wait('master-bin.999999',0)
17 NULL
18 "*** must be empty ***"
19 SHOW REPLICA STATUS;
20 "*** must be NULL ***"
21 select source_pos_wait('foo', 98);
22 source_pos_wait('foo', 98)
23 NULL
24 include/start_slave_sql.inc
25 Test SOURCE_POS_WAIT function with negative timeout value.
26 When SQL_MODE is strict, then it will throw WRONG_ARGUMENTS
27 error.
28 SET @save_sql_mode = @@SESSION.SQL_MODE;
29 SET @@SESSION.SQL_MODE = "STRICT_ALL_TABLES";
30 Warnings:
31 Warning 3135 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release.
32 SELECT source_pos_wait('master-bin.999999', 4, -1);
33 ERROR HY000: Incorrect arguments to SOURCE_POS_WAIT.
34 SET @@session.sql_mode = "";
35 SELECT source_pos_wait('master-bin.999999', 4, -1);
36 source_pos_wait('master-bin.999999', 4, -1)
37 NULL
38 Warnings:
39 Warning 1210 Incorrect arguments to SOURCE_POS_WAIT.
40 SET @@session.sql_mode = @save_sql_mode;
41 Test WAIT_FOR_EXECUTED_GTID_SET function with fractional timeout value.
42 Earlier(before fix), 0.4 is read as integer value '0' and the function
43 hanged forever (or till all the specified gtids are executed).
44 Now(after fix) 0.4 will be read as doube 0.4 and will waitfor
45 atleast 0.4 seconds (or till all the specified gtids are executed).
46 Also check that in case of timeout, function returns -1.
47 include/assert.inc [source_pos_wait returns -1 if the timeout has been exceeded.]
48 SELECT source_pos_wait('master-bin.999999', 4, 1, "non_existent");
49 source_pos_wait('master-bin.999999', 4, 1, "non_existent")
50 NULL
51 SELECT master_pos_wait('master-bin.999999', 0, 1);
52 master_pos_wait('master-bin.999999', 0, 1)
53 -1
54 Warnings:
55 Warning 1287 'MASTER_POS_WAIT' is deprecated and will be removed in a future release. Please use SOURCE_POS_WAIT instead
56 EXPLAIN select master_pos_wait('master-bin.999999', 0, 1);
57 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
58 1 SIMPLE NULL NULL NULL NULL NULL NULL NULL NULL NULL No tables used
59 Warnings:
60 Note 1003 /* select#1 */ select source_pos_wait('master-bin.999999',0,1) AS `master_pos_wait('master-bin.999999', 0, 1)`
61 SELECT master_pos_wait('master-bin.999999',0);
62 include/stop_slave_sql.inc
63 master_pos_wait('master-bin.999999',0)
64 NULL
65 Warnings:
66 Warning 1287 'MASTER_POS_WAIT' is deprecated and will be removed in a future release. Please use SOURCE_POS_WAIT instead
67 "*** must be empty ***"
68 SHOW REPLICA STATUS;
69 "*** must be NULL ***"
70 select master_pos_wait('foo', 98);
71 master_pos_wait('foo', 98)
72 NULL
73 Warnings:
74 Warning 1287 'MASTER_POS_WAIT' is deprecated and will be removed in a future release. Please use SOURCE_POS_WAIT instead
75 include/start_slave_sql.inc
76 Test SOURCE_POS_WAIT function with negative timeout value.
77 When SQL_MODE is strict, then it will throw WRONG_ARGUMENTS
78 error.
79 SET @save_sql_mode = @@SESSION.SQL_MODE;
80 SET @@SESSION.SQL_MODE = "STRICT_ALL_TABLES";
81 Warnings:
82 Warning 3135 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release.
83 SELECT master_pos_wait('master-bin.999999', 4, -1);
84 ERROR HY000: Incorrect arguments to SOURCE_POS_WAIT.
85 SET @@session.sql_mode = "";
86 SELECT master_pos_wait('master-bin.999999', 4, -1);
87 master_pos_wait('master-bin.999999', 4, -1)
88 NULL
89 Warnings:
90 Warning 1287 'MASTER_POS_WAIT' is deprecated and will be removed in a future release. Please use SOURCE_POS_WAIT instead
91 Warning 1210 Incorrect arguments to SOURCE_POS_WAIT.
92 SET @@session.sql_mode = @save_sql_mode;
93 Test WAIT_FOR_EXECUTED_GTID_SET function with fractional timeout value.
94 Earlier(before fix), 0.4 is read as integer value '0' and the function
95 hanged forever (or till all the specified gtids are executed).
96 Now(after fix) 0.4 will be read as doube 0.4 and will waitfor
97 atleast 0.4 seconds (or till all the specified gtids are executed).
98 Also check that in case of timeout, function returns -1.
99 include/assert.inc [master_pos_wait returns -1 if the timeout has been exceeded.]
100 SELECT master_pos_wait('master-bin.999999', 4, 1, "non_existent");
101 master_pos_wait('master-bin.999999', 4, 1, "non_existent")
102 NULL
103 Warnings:
104 Warning 1287 'MASTER_POS_WAIT' is deprecated and will be removed in a future release. Please use SOURCE_POS_WAIT instead
105 include/rpl_end.inc