Debian Codegraph @

mysql-test/suite/sysschema/r/fn_ps_thread_trx_info.result

raw
1 SELECT sys.ps_thread_trx_info(234623462376);
2 sys.ps_thread_trx_info(234623462376)
3 NULL
4 SELECT JSON_VALID(sys.ps_thread_trx_info(ps_current_thread_id()));
5 JSON_VALID(sys.ps_thread_trx_info(ps_current_thread_id()))
6 1
7 CREATE DATABASE trx;
8 CREATE TABLE trx.info (id INT PRIMARY KEY, info VARCHAR(20));
9 # Warm-up data-dictionary cache.
10 USE trx;
11 START TRANSACTION;
12 INSERT INTO info VALUES (1, 'foo');
13 COMMIT;
14 START TRANSACTION;
15 INSERT INTO info VALUES (2, 'bar');
16 COMMIT;
17 SET @json_doc := sys.ps_thread_trx_info(@ps_thread_id);
18 SELECT JSON_VALID(@json_doc);
19 JSON_VALID(@json_doc)
20 1
21 SELECT JSON_LENGTH(@json_doc);
22 JSON_LENGTH(@json_doc)
23 2
24 SELECT JSON_KEYS(JSON_EXTRACT(@json_doc, '$[0]'));
25 JSON_KEYS(JSON_EXTRACT(@json_doc, '$[0]'))
26 ["gtid", "mode", "time", "state", "isolation", "autocommitted", "statements_executed"]
27 SELECT JSON_CONTAINS_PATH(@json_doc, 'one', '$[0].time');
28 JSON_CONTAINS_PATH(@json_doc, 'one', '$[0].time')
29 1
30 SELECT JSON_CONTAINS(@json_doc, '"COMMITTED"', '$[0].state');
31 JSON_CONTAINS(@json_doc, '"COMMITTED"', '$[0].state')
32 1
33 SELECT JSON_CONTAINS(@json_doc, '"READ WRITE"', '$[0].mode');
34 JSON_CONTAINS(@json_doc, '"READ WRITE"', '$[0].mode')
35 1
36 SELECT JSON_CONTAINS(@json_doc, '"NO"', '$[0].autocommitted');
37 JSON_CONTAINS(@json_doc, '"NO"', '$[0].autocommitted')
38 1
39 SELECT JSON_EXTRACT(@json_doc, '$[0].gtid');
40 JSON_EXTRACT(@json_doc, '$[0].gtid')
41 "GTID"
42 SELECT JSON_CONTAINS(@json_doc, '"REPEATABLE READ"', '$[0].isolation');
43 JSON_CONTAINS(@json_doc, '"REPEATABLE READ"', '$[0].isolation')
44 1
45 SELECT JSON_KEYS(JSON_EXTRACT(@json_doc, '$[0].statements_executed[0]'));
46 JSON_KEYS(JSON_EXTRACT(@json_doc, '$[0].statements_executed[0]'))
47 ["time", "schema", "sql_text", "rows_sent", "sort_rows", "tmp_tables", "rows_affected", "rows_examined", "tmp_disk_tables", "sort_merge_passes"]
48 SELECT JSON_CONTAINS_PATH(@json_doc, 'one', '$[0].statements_executed[0].time');
49 JSON_CONTAINS_PATH(@json_doc, 'one', '$[0].statements_executed[0].time')
50 1
51 SELECT JSON_CONTAINS(@json_doc, '"INSERT INTO info VALUES (1, \'foo\')"', '$[0].statements_executed[0].sql_text');
52 JSON_CONTAINS(@json_doc, '"INSERT INTO info VALUES (1, \'foo\')"', '$[0].statements_executed[0].sql_text')
53 1
54 SELECT JSON_CONTAINS(@json_doc, '"trx"', '$[0].statements_executed[0].schema');
55 JSON_CONTAINS(@json_doc, '"trx"', '$[0].statements_executed[0].schema')
56 1
57 SELECT JSON_CONTAINS(@json_doc, '0', '$[0].statements_executed[0].rows_examined');
58 JSON_CONTAINS(@json_doc, '0', '$[0].statements_executed[0].rows_examined')
59 1
60 SELECT JSON_CONTAINS(@json_doc, '1', '$[0].statements_executed[0].rows_affected');
61 JSON_CONTAINS(@json_doc, '1', '$[0].statements_executed[0].rows_affected')
62 1
63 SELECT JSON_CONTAINS(@json_doc, '0', '$[0].statements_executed[0].rows_sent');
64 JSON_CONTAINS(@json_doc, '0', '$[0].statements_executed[0].rows_sent')
65 1
66 SELECT JSON_CONTAINS(@json_doc, '0', '$[0].statements_executed[0].tmp_tables');
67 JSON_CONTAINS(@json_doc, '0', '$[0].statements_executed[0].tmp_tables')
68 1
69 SELECT JSON_CONTAINS(@json_doc, '0', '$[0].statements_executed[0].tmp_disk_tables');
70 JSON_CONTAINS(@json_doc, '0', '$[0].statements_executed[0].tmp_disk_tables')
71 1
72 SELECT JSON_CONTAINS(@json_doc, '0', '$[0].statements_executed[0].sort_rows');
73 JSON_CONTAINS(@json_doc, '0', '$[0].statements_executed[0].sort_rows')
74 1
75 SELECT JSON_CONTAINS(@json_doc, '0', '$[0].statements_executed[0].sort_merge_passes');
76 JSON_CONTAINS(@json_doc, '0', '$[0].statements_executed[0].sort_merge_passes')
77 1
78 SELECT JSON_CONTAINS(@json_doc, '"COMMIT"', '$[0].statements_executed[1].sql_text');
79 JSON_CONTAINS(@json_doc, '"COMMIT"', '$[0].statements_executed[1].sql_text')
80 1
81 SET @sys.ps_thread_trx_info.max_length = 100;
82 SELECT sys.ps_thread_trx_info(@ps_thread_id);
83 sys.ps_thread_trx_info(@ps_thread_id)
84 { "error": "Trx info truncated: Row 4 was cut by GROUP_CONCAT()" }
85 SET @sys.ps_thread_trx_info.max_length = NULL;
86 SELECT JSON_VALID(sys.ps_thread_trx_info(@ps_thread_id));
87 JSON_VALID(sys.ps_thread_trx_info(@ps_thread_id))
88 1
89 DROP DATABASE trx;