summaryrefslogtreecommitdiff
path: root/mysql-test/suite/perfschema/include/show_transaction_gtid.inc
blob: 758354ea2b853c7162737b66d9caab81e2040a51 (plain)
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
# ==== Purpose ====
#
# Auxiliary file used by transaction_gtid.test
#
# Invoked to check the contents of the
# performance_schema.events_transaction_[current|history] tables and
# write the result to the result log.  This is executed on the
# 'server_1' connection and shows only status of transactions on the
# 'default' connection.

--connection server_1

--replace_result $server_uuid SERVER_UUID aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa A
--let $history_result= `SELECT GTID FROM performance_schema.events_transactions_history WHERE THREAD_ID = $thread_id`
if ($history_result == '')
{
  --let $history_result= none
}

--replace_result $server_uuid SERVER_UUID aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa A
--let $current_result= `SELECT GTID FROM performance_schema.events_transactions_current WHERE THREAD_ID = $thread_id`
if ($current_result == '')
{
  --let $current_result= none
}

--echo - history=$history_result current=$current_result

--connection default