mysql-test/suite/perfschema/r/innodb_events_transactions_history_long.result
raw| 1 | # |
| 2 | # MDEV-24600 performance_schema.events_transactions_history_long.trx_id |
| 3 | # reports garbage |
| 4 | # |
| 5 | TRUNCATE performance_schema.events_transactions_history_long; |
| 6 | START TRANSACTION WITH CONSISTENT SNAPSHOT; |
| 7 | COMMIT; |
| 8 | BEGIN; |
| 9 | SELECT table_name FROM mysql.innodb_table_stats LIMIT 0 LOCK IN SHARE MODE; |
| 10 | table_name |
| 11 | COMMIT; |
| 12 | SELECT state,trx_id,gtid |
| 13 | FROM performance_schema.events_transactions_history_long; |
| 14 | state trx_id gtid |
| 15 | COMMITTED NULL 0-0-0 |
| 16 | COMMITTED NULL 0-0-0 |