Debian Codegraph @

mysql-test/suite/innodb_i_s/innodb_trx.result

raw
1 SHOW CREATE TABLE INFORMATION_SCHEMA.INNODB_TRX;
2 Table Create Table
3 INNODB_TRX CREATE TEMPORARY TABLE `INNODB_TRX` (
4 `trx_id` bigint(21) unsigned NOT NULL,
5 `trx_state` varchar(13) NOT NULL,
6 `trx_started` datetime NOT NULL,
7 `trx_requested_lock_id` varchar(81),
8 `trx_wait_started` datetime,
9 `trx_weight` bigint(21) unsigned NOT NULL,
10 `trx_mysql_thread_id` bigint(21) unsigned NOT NULL,
11 `trx_query` varchar(1024),
12 `trx_operation_state` varchar(64),
13 `trx_tables_in_use` bigint(21) unsigned NOT NULL,
14 `trx_tables_locked` bigint(21) unsigned NOT NULL,
15 `trx_lock_structs` bigint(21) unsigned NOT NULL,
16 `trx_lock_memory_bytes` bigint(21) unsigned NOT NULL,
17 `trx_rows_locked` bigint(21) unsigned NOT NULL,
18 `trx_rows_modified` bigint(21) unsigned NOT NULL,
19 `trx_concurrency_tickets` bigint(21) unsigned NOT NULL,
20 `trx_isolation_level` enum('READ UNCOMMITTED','READ COMMITTED','REPEATABLE READ','SERIALIZABLE') NOT NULL,
21 `trx_unique_checks` int(1) NOT NULL,
22 `trx_foreign_key_checks` int(1) NOT NULL,
23 `trx_last_foreign_key_error` varchar(256),
24 `trx_is_read_only` int(1) NOT NULL,
25 `trx_autocommit_non_locking` int(1) NOT NULL
26 ) ENGINE=MEMORY DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci
27 CREATE TEMPORARY TABLE t1 LIKE INFORMATION_SCHEMA.INNODB_TRX;
28 DROP TEMPORARY TABLE t1;
29 CREATE TEMPORARY TABLE t1 AS SELECT * FROM INFORMATION_SCHEMA.INNODB_TRX LIMIT 0;
30 DROP TEMPORARY TABLE t1;
31 #
32 # Start of 10.5 tests
33 #
34 #
35 # MDEV-26507 Assertion `tmp != ((long long) 0x8000000000000000LL)' failed in TIME_from_longlong_datetime_packed
36 #
37 CREATE ALGORITHM=TEMPTABLE VIEW i AS
38 SELECT a.trx_started
39 FROM INFORMATION_SCHEMA.innodb_lock_waits w
40 JOIN INFORMATION_SCHEMA.innodb_trx a
41 ORDER BY a.trx_wait_started;
42 SET SESSION sql_mode='ALLOW_INVALID_DATES';
43 SELECT * FROM i;
44 SET SESSION sql_mode=DEFAULT;
45 DROP VIEW i;
46 #
47 # End of 10.5 tests
48 #