-
Notifications
You must be signed in to change notification settings - Fork 4k
/
Copy pathgtid_drop_table.inc
48 lines (45 loc) · 1.1 KB
/
gtid_drop_table.inc
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
# ==== Purpose ====
#
# This include will try to issue the $statement after setting GTID_NEXT to the
# $next_gtid variable expecting $expected_error if it is defined and non-zero.
#
# If the $expected_error is defined and non-zero, this include will also
# rollback the statement to release the ownership of the previously set GTID.
#
# ==== Usage ====
#
# --let $statement= XXX
# --let $next_gtid= 'UUID:NUMBER'
# [--$expected_error= ER_XXX]
# --source common/rpl/gtid_drop_table.inc
#
# Parameters:
# $statement
# The SQL statement to be executed.
#
# $next_gtid
# The GTID to be set as GTID_NEXT.
#
# $expected_error
# The error expected when issuing the command.
# Optional, not set means no expected error.
if (!$statement)
{
--die ERROR IN TEST: the "statement" variable must be set
}
if (!$next_gtid)
{
--die ERROR IN TEST: the "next_gtid" variable must be set
}
--eval SET GTID_NEXT= $next_gtid
if ($expected_error)
{
--echo ## Expecting error $expected_error after the statement
--error $expected_error
--eval $statement
ROLLBACK;
}
if (!$expected_error)
{
--eval $statement
}