summaryrefslogtreecommitdiff
path: root/mysql-test/suite/perfschema/r/innodb_events_transactions_history_long.result
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/suite/perfschema/r/innodb_events_transactions_history_long.result')
-rw-r--r--mysql-test/suite/perfschema/r/innodb_events_transactions_history_long.result16
1 files changed, 16 insertions, 0 deletions
diff --git a/mysql-test/suite/perfschema/r/innodb_events_transactions_history_long.result b/mysql-test/suite/perfschema/r/innodb_events_transactions_history_long.result
new file mode 100644
index 00000000000..1d8c372fa39
--- /dev/null
+++ b/mysql-test/suite/perfschema/r/innodb_events_transactions_history_long.result
@@ -0,0 +1,16 @@
+#
+# MDEV-24600 performance_schema.events_transactions_history_long.trx_id
+# reports garbage
+#
+TRUNCATE performance_schema.events_transactions_history_long;
+START TRANSACTION WITH CONSISTENT SNAPSHOT;
+COMMIT;
+BEGIN;
+SELECT table_name FROM mysql.innodb_table_stats LIMIT 0 LOCK IN SHARE MODE;
+table_name
+COMMIT;
+SELECT state,trx_id,gtid
+FROM performance_schema.events_transactions_history_long;
+state trx_id gtid
+COMMITTED NULL 0-0-0
+COMMITTED NULL 0-0-0