github.com/matrixorigin/matrixone@v1.2.0/test/distributed/cases/pessimistic_transaction/catalog.result (about) 1 use mo_catalog; 2 desc mo_locks; 3 Field Type Null Key Default Extra Comment 4 cn_id VARCHAR(65535) YES null 5 txn_id VARCHAR(65535) YES null 6 table_id VARCHAR(65535) YES null 7 lock_key VARCHAR(65535) YES null 8 lock_content VARCHAR(65535) YES null 9 lock_mode VARCHAR(65535) YES null 10 lock_status VARCHAR(65535) YES null 11 lock_wait VARCHAR(65535) YES null 12 desc mo_cache; 13 Field Type Null Key Default Extra Comment 14 node_type VARCHAR(65535) YES null 15 node_id VARCHAR(65535) YES null 16 type VARCHAR(65535) YES null 17 used BIGINT UNSIGNED(0) YES null 18 free BIGINT UNSIGNED(0) YES null 19 hit_ratio FLOAT(0) YES null 20 desc mo_transactions; 21 Field Type Null Key Default Extra Comment 22 cn_id VARCHAR(65535) YES null 23 txn_id VARCHAR(65535) YES null 24 create_ts VARCHAR(65535) YES null 25 snapshot_ts VARCHAR(65535) YES null 26 prepared_ts VARCHAR(65535) YES null 27 commit_ts VARCHAR(65535) YES null 28 txn_mode VARCHAR(65535) YES null 29 isolation VARCHAR(65535) YES null 30 user_txn VARCHAR(65535) YES null 31 txn_status VARCHAR(65535) YES null 32 table_id VARCHAR(65535) YES null 33 lock_key VARCHAR(65535) YES null 34 lock_content VARCHAR(65535) YES null 35 lock_mode VARCHAR(65535) YES null 36 desc mo_variables; 37 Field Type Null Key Default Extra Comment 38 configuration_id INT(32) NO null 39 account_id INT(32) YES null 40 account_name VARCHAR(300) YES null 41 dat_name VARCHAR(5000) YES null 42 variable_name VARCHAR(300) YES null 43 variable_value VARCHAR(5000) YES null 44 system_variables BOOL(0) YES null 45 desc mo_configurations; 46 Field Type Null Key Default Extra Comment 47 node_type VARCHAR(65535) YES null 48 node_id VARCHAR(65535) YES null 49 name VARCHAR(65535) YES null 50 current_value VARCHAR(65535) YES null 51 default_value VARCHAR(65535) YES null 52 internal VARCHAR(65535) YES null 53 desc mo_sessions; 54 Field Type Null Key Default Extra Comment 55 node_id VARCHAR(65535) YES null 56 conn_id INT UNSIGNED(0) YES null 57 session_id VARCHAR(65535) YES null 58 account VARCHAR(65535) YES null 59 user VARCHAR(65535) YES null 60 host VARCHAR(65535) YES null 61 db VARCHAR(65535) YES null 62 session_start VARCHAR(65535) YES null 63 command VARCHAR(65535) YES null 64 info VARCHAR(65535) YES null 65 txn_id VARCHAR(65535) YES null 66 statement_id VARCHAR(65535) YES null 67 statement_type VARCHAR(65535) YES null 68 query_type VARCHAR(65535) YES null 69 sql_source_type VARCHAR(65535) YES null 70 query_start VARCHAR(65535) YES null 71 client_host VARCHAR(65535) YES null 72 role VARCHAR(65535) YES null 73 proxy_host VARCHAR(65535) YES null 74 create account acc100 admin_name='root' identified by '123456'; 75 use mo_catalog; 76 desc mo_locks; 77 Field Type Null Key Default Extra Comment 78 cn_id VARCHAR(65535) YES null 79 txn_id VARCHAR(65535) YES null 80 table_id VARCHAR(65535) YES null 81 lock_key VARCHAR(65535) YES null 82 lock_content VARCHAR(65535) YES null 83 lock_mode VARCHAR(65535) YES null 84 lock_status VARCHAR(65535) YES null 85 lock_wait VARCHAR(65535) YES null 86 desc mo_cache; 87 Field Type Null Key Default Extra Comment 88 node_type VARCHAR(65535) YES null 89 node_id VARCHAR(65535) YES null 90 type VARCHAR(65535) YES null 91 used BIGINT UNSIGNED(0) YES null 92 free BIGINT UNSIGNED(0) YES null 93 hit_ratio FLOAT(0) YES null 94 desc mo_transactions; 95 Field Type Null Key Default Extra Comment 96 cn_id VARCHAR(65535) YES null 97 txn_id VARCHAR(65535) YES null 98 create_ts VARCHAR(65535) YES null 99 snapshot_ts VARCHAR(65535) YES null 100 prepared_ts VARCHAR(65535) YES null 101 commit_ts VARCHAR(65535) YES null 102 txn_mode VARCHAR(65535) YES null 103 isolation VARCHAR(65535) YES null 104 user_txn VARCHAR(65535) YES null 105 txn_status VARCHAR(65535) YES null 106 table_id VARCHAR(65535) YES null 107 lock_key VARCHAR(65535) YES null 108 lock_content VARCHAR(65535) YES null 109 lock_mode VARCHAR(65535) YES null 110 desc mo_variables; 111 Field Type Null Key Default Extra Comment 112 configuration_id INT(32) NO null 113 account_id INT(32) YES null 114 account_name VARCHAR(300) YES null 115 dat_name VARCHAR(5000) YES null 116 variable_name VARCHAR(300) YES null 117 variable_value VARCHAR(5000) YES null 118 system_variables BOOL(0) YES null 119 desc mo_configurations; 120 Field Type Null Key Default Extra Comment 121 node_type VARCHAR(65535) YES null 122 node_id VARCHAR(65535) YES null 123 name VARCHAR(65535) YES null 124 current_value VARCHAR(65535) YES null 125 default_value VARCHAR(65535) YES null 126 internal VARCHAR(65535) YES null 127 desc mo_sessions; 128 Field Type Null Key Default Extra Comment 129 node_id VARCHAR(65535) YES null 130 conn_id INT UNSIGNED(0) YES null 131 session_id VARCHAR(65535) YES null 132 account VARCHAR(65535) YES null 133 user VARCHAR(65535) YES null 134 host VARCHAR(65535) YES null 135 db VARCHAR(65535) YES null 136 session_start VARCHAR(65535) YES null 137 command VARCHAR(65535) YES null 138 info VARCHAR(65535) YES null 139 txn_id VARCHAR(65535) YES null 140 statement_id VARCHAR(65535) YES null 141 statement_type VARCHAR(65535) YES null 142 query_type VARCHAR(65535) YES null 143 sql_source_type VARCHAR(65535) YES null 144 query_start VARCHAR(65535) YES null 145 client_host VARCHAR(65535) YES null 146 role VARCHAR(65535) YES null 147 proxy_host VARCHAR(65535) YES null 148 drop account acc100;