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
56
57
58
59
60
61
|
#
# Check if event exists for table
#
# Arguments:
# check_event_tabname - name of table
# check_event_dbname - db of table
# [check_event_full - expect a full event]
#
#
if (!$check_event_tabname)
{
die Need the name of table to check event for;
}
if (!$check_event_dbname)
{
die Need the db of table to check event for;
}
#
# The name for an event has form REPL[F]$<db>/<table_name>
# - the additional F is used when table should be binlogged
# with "full" rows
#
let $event_prefix = REPL;
if ($check_event_full)
{
let $event_prefix = REPLF;
}
# Expected event name, includes extra escape for the dollar
# sign avoiding that mysqltest evaluates it before sending the query
let $expected_event_name =
$event_prefix\\\$$check_event_dbname/$check_event_tabname;
#echo expected_event_name: $expected_event_name;
let $found_event = `SELECT count(*) FROM ndbinfo.events
WHERE name = '$expected_event_name'`;
if ($found_event)
{
echo Found event for '$check_event_dbname.$check_event_tabname';
#
# Check how report options for the event is configured. Use the 'reporting'
# column of ndbinfo.events which is a SET that correspond to the flags
# describing what should be reported
let $reporting = `SELECT reporting FROM ndbinfo.events
WHERE name = '$expected_event_name'`;
echo Report flags: '$reporting';
}
if (!$found_event)
{
echo No event found for '$check_event_dbname.$check_event_tabname';
}
# Reset args
let $check_event_tabname = ;
let $check_event_dbname = ;
let $check_event_full = ;
--enable_query_log
|
