github.com/matrixorigin/matrixone@v1.2.0/test/distributed/cases/mo_cloud/mo_cloud.result (about) 1 create account if not exists test_tenant_1 admin_name 'test_account' identified by '111'; 2 CREATE DATABASE IF NOT EXISTS mo_mo; 3 USE mo_mo; 4 select count(*) from mo_catalog.mo_tables where reldatabase = 'mo_catalog' and relname = 'statement_mo' and relkind = 'cluster'; 5 count(*) 6 0 7 select count(*) from mo_catalog.mo_tables where reldatabase = 'mo_mo' and relname = 'stu' and relkind = 'r'; 8 count(*) 9 0 10 select count(*) from mo_catalog.mo_tables where reldatabase = 'mo_mo' and relname = 'statement_time' and relkind = 'r'; 11 count(*) 12 0 13 select count(*) from mo_catalog.mo_tables where reldatabase = 'mo_mo' and relname = 'moins' and relkind = 'r'; 14 count(*) 15 0 16 select count(*) from mo_catalog.mo_tables where reldatabase = 'mo_mo' and relname = 'storage' and relkind = 'r'; 17 count(*) 18 0 19 select count(*) from mo_catalog.mo_tables where reldatabase = 'mo_mo' and relname = 'storage_time' and relkind = 'r'; 20 count(*) 21 0 22 CREATE CLUSTER TABLE `mo_catalog`.`statement_mo` (`statement_id` varchar(36) NOT NULL,`account` VARCHAR(300) NOT NULL,`response_at` datetime(3) NULL,`stu` DECIMAL(23,3) NOT NULL,PRIMARY KEY (`statement_id`, `account_id`)); 23 internal error: do not have privilege to execute the statement 24 CREATE TABLE `statement_time` (`cluster` varchar(191) NOT NULL,`last_time` datetime(3) NOT NULL,PRIMARY KEY (`cluster`)); 25 CREATE TABLE `stu` (`account` VARCHAR(300) NOT NULL,`start_time` datetime(3) NOT NULL,`end_time` datetime(3) NOT NULL,`stu` decimal(23,3) NOT NULL,`type` longtext NOT NULL); 26 CREATE TABLE `mo_mo`.`wb_version` (`id` varchar(128),`wb_id` varchar(128),`sql_content` MEDIUMTEXT,`version` varchar(255),`status` tinyint(4),`created_at` datetime,`updated_at` datetime,PRIMARY KEY (`id`),INDEX `wb_id_idx` (`wb_id`)); 27 CREATE TABLE `mo_mo`.`wb` (`id` varchar(128),`account_id` varchar(128),`sql_user` varchar(128),`name` varchar(128),`created_at` datetime,`updated_at` datetime,PRIMARY KEY (`id`),UNIQUE INDEX `unq_account_name` (`account_id`,`sql_user`,`name`)); 28 CREATE TABLE `moins` (`id` varchar(128) NOT NULL,`name` VARCHAR(255) NOT NULL,`account_name` varchar(128) NOT NULL,`provider` longtext NOT NULL,`provider_id` longtext,`region` longtext NOT NULL,`pty` longtext NOT NULL,`version` longtext,`status` longtext,`qt` longtext,`policy` longtext,`created_by` longtext,`created_at` datetime(3) NULL,PRIMARY KEY (`id`)); 29 CREATE TABLE `operation` (`id` varchar(128) NOT NULL,`created_at` datetime(3) NULL,`statement_id` varchar(128) NOT NULL,`connection_id` bigint unsigned NOT NULL,`db` varchar(128) NOT NULL,`run_status` varchar(64) NOT NULL,`err_msg` text NOT NULL,`rows_affected` bigint,PRIMARY KEY (`id`),INDEX `idx_operation_created_at` (`created_at` asc)); 30 CREATE TABLE `storage_time` (`cluster` varchar(191) NOT NULL,`last_time` datetime(3) NOT NULL,PRIMARY KEY (`cluster`)); 31 CREATE TABLE `storage` (`collecttime` datetime NOT NULL,`value` double NOT NULL,`account` varchar(128) NOT NULL,`interval` int NOT NULL); 32 INSERT INTO `mo_mo`.`operation` (`id`,`created_at`,`statement_id`,`connection_id`,`db`,`run_status`,`err_msg`,`rows_affected`) VALUES ('fef17f18-d337-4f81-b5f5-3888690ac3a0','2023-07-28 05:01:57.296','',0,'','','',0); 33 SELECT * FROM (select `statement`,system.statement_info.statement_id,IF(`status`='Running', TIMESTAMPDIFF(MICROSECOND,`request_at`,now())*1000, `duration`) AS `duration`,`status`,`query_type`,`request_at`,system.statement_info.response_at,`user`,`database`,`transaction_id`,`session_id`,`rows_read`,`bytes_scan`,`result_count` from system.statement_info left join mo_catalog.statement_mo ON system.statement_info.statement_id = mo_catalog.statement_mo.statement_id where 1=1 AND `request_at` >= '2023-07-28 04:09:33' AND system.statement_info.statement_id LIKE '%cd%' AND system.statement_info.account = 'c3daefe4_2197_4192_a10e_d0acc5d9da30' AND `user` IN ('ab') AND `session_id` LIKE '%ef%' AND `duration` > 1000000000 AND `statement` LIKE '%show%' ESCAPE '\\\\' )t ORDER BY request_at DESC LIMIT 20; 34 SQL parser error: table "statement_mo" does not exist 35 SELECT * FROM `mo_mo`.`moins` WHERE id = 'c3daefe4-2197-4192-a10e-d0acc5d9da30'; 36 id name account_name provider provider_id region pty version status qt policy created_by created_at 37 SELECT * FROM `mo_mo`.`operation` WHERE `operation`.`id` = 'fef17f18-d337-4f81-b5f5-3888690ac3a0' ORDER BY `operation`.`id` LIMIT 1; 38 id created_at statement_id connection_id db run_status err_msg rows_affected 39 fef17f18-d337-4f81-b5f5-3888690ac3a0 2023-07-28 05:01:57.296000000 0 0 40 SELECT `stat_ts`, sum(`stu`) as value FROM(SELECT concat(DATE_FORMAT(date_add(`start_time`,Interval 1 MINUTE),'%Y-%m-%d %H'),':',LPAD(CAST(1 * floor(minute(date_add(`start_time`,Interval 1 MINUTE)) / 1) as int),2,0),':00') AS stat_ts, SUM(`stu`) AS stu FROM mo_mo.stu WHERE `start_time` >= '2023-07-28 03:04:53' AND `start_time` <= '2023-07-28 03:34:53' AND account = '863f0767_0361_4a8c_a3e8_73b2be140a74' GROUP BY concat(DATE_FORMAT(date_add(`start_time`,Interval 1 MINUTE),'%Y-%m-%d %H'),':',LPAD(CAST(1 * floor(minute(date_add(`start_time`,Interval 1 MINUTE)) / 1) as int),2,0),':00') ORDER BY concat(DATE_FORMAT(date_add(`start_time`,Interval 1 MINUTE),'%Y-%m-%d %H'),':',LPAD(CAST(1 * floor(minute(date_add(`start_time`,Interval 1 MINUTE)) / 1) as int),2,0),':00') LIMIT 100)t GROUP BY `stat_ts`; 41 stat_ts value 42 SELECT attname AS name, mo_show_visible_bin(atttyp,3) AS data_type, replace(mo_table_col_max(att_database,att_relname,attname),'\\0', '') AS `maximum`, mo_table_col_min(att_database,att_relname,attname) as minimum from mo_catalog.mo_columns where att_database='information_schema' and att_relname='engines' and attname NOT IN ('__mo_rowid', '__mo_cpkey_col', '__mo_fake_pk_col') ORDER BY attnum; 43 name data_type maximum minimum 44 engine VARCHAR(64) null null 45 support VARCHAR(8) null null 46 comment VARCHAR(160) null null 47 transactions VARCHAR(3) null null 48 xa VARCHAR(3) null null 49 savepoints VARCHAR(3) null null 50 SELECT attname AS name, mo_show_visible_bin(atttyp,3) AS data_type, replace(mo_table_col_max(att_database,att_relname,attname),'\\0', '') AS `maximum`, mo_table_col_min(att_database,att_relname,attname) as minimum from mo_catalog.mo_columns where att_database='information_schema' and att_relname='key_column_usage' and attname NOT IN ('__mo_rowid', '__mo_cpkey_col', '__mo_fake_pk_col') ORDER BY attnum; 51 name data_type maximum minimum 52 constraint_catalog VARCHAR(64) null null 53 constraint_schema VARCHAR(64) null null 54 constraint_name VARCHAR(64) null null 55 table_catalog VARCHAR(64) null null 56 table_schema VARCHAR(64) null null 57 table_name VARCHAR(64) null null 58 column_name VARCHAR(64) null null 59 ordinal_position INT UNSIGNED(32) null null 60 position_in_unique_constraint INT UNSIGNED(32) null null 61 referenced_table_schema VARCHAR(64) null null 62 referenced_table_name VARCHAR(64) null null 63 referenced_column_name VARCHAR(64) null null 64 SELECT attname AS name, mo_show_visible_bin(atttyp,3) AS data_type, replace(mo_table_col_max(att_database,att_relname,attname),'\\0', '') AS `maximum`, mo_table_col_min(att_database,att_relname,attname) as minimum from mo_catalog.mo_columns where att_database='information_schema' and att_relname='keywords' and attname NOT IN ('__mo_rowid', '__mo_cpkey_col', '__mo_fake_pk_col') ORDER BY attnum; 65 name data_type maximum minimum 66 word VARCHAR(64) null null 67 reserved INT UNSIGNED(32) null null 68 SELECT attname AS name, mo_show_visible_bin(atttyp,3) AS data_type, replace(mo_table_col_max(att_database,att_relname,attname),'\\0', '') AS `maximum`, mo_table_col_min(att_database,att_relname,attname) as minimum from mo_catalog.mo_columns where att_database='information_schema' and att_relname='parameters' and attname NOT IN ('__mo_rowid', '__mo_cpkey_col', '__mo_fake_pk_col') ORDER BY attnum; 69 name data_type maximum minimum 70 specific_catalog VARCHAR(64) null null 71 specific_schema VARCHAR(64) null null 72 specific_name VARCHAR(64) null null 73 ordinal_position BIGINT UNSIGNED(64) null null 74 parameter_mode VARCHAR(5) null null 75 parameter_name VARCHAR(64) null null 76 data_type TEXT(0) null null 77 character_maximum_length BIGINT(64) null null 78 character_octet_length BIGINT(64) null null 79 numeric_precision INT UNSIGNED(32) null null 80 numeric_scale BIGINT(64) null null 81 datetime_precision INT UNSIGNED(32) null null 82 character_set_name VARCHAR(64) null null 83 collation_name VARCHAR(64) null null 84 dtd_identifier TEXT(0) null null 85 routine_type VARCHAR(64) null null 86 SELECT attname AS name, mo_show_visible_bin(atttyp,3) AS data_type, replace(mo_table_col_max(att_database,att_relname,attname),'\\0', '') AS `maximum`, mo_table_col_min(att_database,att_relname,attname) as minimum from mo_catalog.mo_columns where att_database='mo_catalog' and att_relname='mo_columns' and attname NOT IN ('__mo_rowid', '__mo_cpkey_col', '__mo_fake_pk_col') ORDER BY attnum; 87 invalid input: mo_table_col_max has bad input table mo_columns 88 SELECT attname AS name, mo_show_visible_bin(atttyp,3) AS data_type, replace(mo_table_col_max(att_database,att_relname,attname),'\\0', '') AS `maximum`, mo_table_col_min(att_database,att_relname,attname) as minimum from mo_catalog.mo_columns where att_database='mo_sample_data_tpch_sf1' and att_relname='lineitem' and attname NOT IN ('__mo_rowid', '__mo_cpkey_col', '__mo_fake_pk_col') ORDER BY attnum; 89 name data_type maximum minimum 90 SELECT attname AS name, mo_show_visible_bin(atttyp,3) AS data_type, replace(mo_table_col_max(att_database,att_relname,attname),'\\0', '') AS `maximum`, mo_table_col_min(att_database,att_relname,attname) as minimum from mo_catalog.mo_columns where att_database='mo_sample_data_tpch_sf1' and att_relname='supplier' and attname NOT IN ('__mo_rowid', '__mo_cpkey_col', '__mo_fake_pk_col') ORDER BY attnum; 91 name data_type maximum minimum 92 SELECT attname AS name, mo_show_visible_bin(atttyp,3) AS data_type, replace(mo_table_col_max(att_database,att_relname,attname),'\\0', '') AS `maximum`, mo_table_col_min(att_database,att_relname,attname) as minimum from mo_catalog.mo_columns where att_database='mysql' and att_relname='columns_priv' and attname NOT IN ('__mo_rowid', '__mo_cpkey_col', '__mo_fake_pk_col') ORDER BY attnum; 93 name data_type maximum minimum 94 host CHAR(255) null null 95 db CHAR(64) null null 96 user CHAR(32) null null 97 table_name CHAR(64) null null 98 column_name CHAR(64) null null 99 timestamp TIMESTAMP(0) null null 100 column_priv VARCHAR(10) null null 101 SELECT attname AS name, mo_show_visible_bin(atttyp,3) AS data_type, replace(mo_table_col_max(att_database,att_relname,attname),'\\0', '') AS `maximum`, mo_table_col_min(att_database,att_relname,attname) as minimum from mo_catalog.mo_columns where att_database='mysql' and att_relname='db' and attname NOT IN ('__mo_rowid', '__mo_cpkey_col', '__mo_fake_pk_col') ORDER BY attnum; 102 name data_type maximum minimum 103 host CHAR(255) null null 104 db CHAR(64) null null 105 user CHAR(32) null null 106 select_priv VARCHAR(10) null null 107 insert_priv VARCHAR(10) null null 108 update_priv VARCHAR(10) null null 109 delete_priv VARCHAR(10) null null 110 create_priv VARCHAR(10) null null 111 drop_priv VARCHAR(10) null null 112 grant_priv VARCHAR(10) null null 113 references_priv VARCHAR(10) null null 114 index_priv VARCHAR(10) null null 115 alter_priv VARCHAR(10) null null 116 create_tmp_table_priv VARCHAR(10) null null 117 lock_tables_priv VARCHAR(10) null null 118 create_view_priv VARCHAR(10) null null 119 show_view_priv VARCHAR(10) null null 120 create_routine_priv VARCHAR(10) null null 121 alter_routine_priv VARCHAR(10) null null 122 execute_priv VARCHAR(10) null null 123 event_priv VARCHAR(10) null null 124 trigger_priv VARCHAR(10) null null 125 SELECT attname AS name, mo_show_visible_bin(atttyp,3) AS data_type, replace(mo_table_col_max(att_database,att_relname,attname),'\\0', '') AS `maximum`, mo_table_col_min(att_database,att_relname,attname) as minimum from mo_catalog.mo_columns where att_database='mysql' and att_relname='procs_priv' and attname NOT IN ('__mo_rowid', '__mo_cpkey_col', '__mo_fake_pk_col') ORDER BY attnum; 126 name data_type maximum minimum 127 host CHAR(255) null null 128 db CHAR(64) null null 129 user CHAR(32) null null 130 routine_name CHAR(64) null null 131 routine_type VARCHAR(10) null null 132 grantor VARCHAR(288) null null 133 proc_priv VARCHAR(10) null null 134 timestamp TIMESTAMP(0) null null 135 SELECT attname AS name, mo_show_visible_bin(atttyp,3) AS data_type, replace(mo_table_col_max(att_database,att_relname,attname),'\\0', '') AS `maximum`, mo_table_col_min(att_database,att_relname,attname) as minimum from mo_catalog.mo_columns where att_database='mysql' and att_relname='tables_priv' and attname NOT IN ('__mo_rowid', '__mo_cpkey_col', '__mo_fake_pk_col') ORDER BY attnum; 136 name data_type maximum minimum 137 host CHAR(255) null null 138 db CHAR(64) null null 139 user CHAR(32) null null 140 table_name CHAR(64) null null 141 grantor VARCHAR(288) null null 142 timestamp TIMESTAMP(0) null null 143 table_priv VARCHAR(10) null null 144 column_priv VARCHAR(10) null null 145 SELECT attname AS name, mo_show_visible_bin(atttyp,3) AS data_type, replace(mo_table_col_max(att_database,att_relname,attname),'\\0', '') AS `maximum`, mo_table_col_min(att_database,att_relname,attname) as minimum from mo_catalog.mo_columns where att_database='mysql' and att_relname='user' and attname NOT IN ('__mo_rowid', '__mo_cpkey_col', '__mo_fake_pk_col') ORDER BY attnum; 146 name data_type maximum minimum 147 host CHAR(255) null null 148 user CHAR(32) null null 149 select_priv VARCHAR(10) null null 150 insert_priv VARCHAR(10) null null 151 update_priv VARCHAR(10) null null 152 delete_priv VARCHAR(10) null null 153 create_priv VARCHAR(10) null null 154 drop_priv VARCHAR(10) null null 155 reload_priv VARCHAR(10) null null 156 shutdown_priv VARCHAR(10) null null 157 process_priv VARCHAR(10) null null 158 file_priv VARCHAR(10) null null 159 grant_priv VARCHAR(10) null null 160 references_priv VARCHAR(10) null null 161 index_priv VARCHAR(10) null null 162 alter_priv VARCHAR(10) null null 163 show_db_priv VARCHAR(10) null null 164 super_priv VARCHAR(10) null null 165 create_tmp_table_priv VARCHAR(10) null null 166 lock_tables_priv VARCHAR(10) null null 167 execute_priv VARCHAR(10) null null 168 repl_slave_priv VARCHAR(10) null null 169 repl_client_priv VARCHAR(10) null null 170 create_view_priv VARCHAR(10) null null 171 show_view_priv VARCHAR(10) null null 172 create_routine_priv VARCHAR(10) null null 173 alter_routine_priv VARCHAR(10) null null 174 create_user_priv VARCHAR(10) null null 175 event_priv VARCHAR(10) null null 176 trigger_priv VARCHAR(10) null null 177 create_tablespace_priv VARCHAR(10) null null 178 ssl_type VARCHAR(10) null null 179 ssl_cipher BLOB(0) null null 180 x509_issuer BLOB(0) null null 181 x509_subject BLOB(0) null null 182 max_questions INT UNSIGNED(32) null null 183 max_updates INT UNSIGNED(32) null null 184 max_connections INT UNSIGNED(32) null null 185 max_user_connections INT UNSIGNED(32) null null 186 plugin CHAR(64) null null 187 authentication_string TEXT(0) null null 188 password_expired VARCHAR(10) null null 189 password_last_changed TIMESTAMP(0) null null 190 password_lifetime SMALLINT UNSIGNED(16) null null 191 account_locked VARCHAR(10) null null 192 create_role_priv VARCHAR(10) null null 193 drop_role_priv VARCHAR(10) null null 194 password_reuse_history SMALLINT UNSIGNED(16) null null 195 password_reuse_time SMALLINT UNSIGNED(16) null null 196 password_require_current VARCHAR(10) null null 197 user_attributes JSON(0) null null 198 SELECT attname AS name, mo_show_visible_bin(atttyp,3) AS data_type, replace(mo_table_col_max(att_database,att_relname,attname),'\\0', '') AS `maximum`, mo_table_col_min(att_database,att_relname,attname) as minimum from mo_catalog.mo_columns where att_database='system_metrics' and att_relname='metric' and attname NOT IN ('__mo_rowid', '__mo_cpkey_col', '__mo_fake_pk_col') ORDER BY attnum; 199 name data_type maximum minimum 200 metric_name VARCHAR(1024) null null 201 collecttime DATETIME(6) null null 202 value DOUBLE(0) null null 203 node VARCHAR(1024) null null 204 role VARCHAR(1024) null null 205 account VARCHAR(1024) null null 206 type VARCHAR(1024) null null 207 __mo_cbkey_011collecttime011metric_name007account VARCHAR(65535) null null 208 SELECT concat(DATE_FORMAT(date_add(`request_at`,Interval 1 MINUTE),'%Y-%m-%d %H'),':',LPAD(CAST(1 * floor(minute(date_add(`request_at`,Interval 1 MINUTE)) / 1) as int),2,0),':00') AS stat_ts, AVG(duration) AS value, `query_type` AS type FROM `system`.`statement_info` WHERE request_at >= '2023-07-28 04:20:43' AND request_at <= '2023-07-28 04:50:43' AND `query_type` in ('DQL','DDL','DML','DCL','TCL','Other') GROUP BY `query_type`, concat(DATE_FORMAT(date_add(`request_at`,Interval 1 MINUTE),'%Y-%m-%d %H'),':',LPAD(CAST(1 * floor(minute(date_add(`request_at`,Interval 1 MINUTE)) / 1) as int),2,0),':00') ORDER BY concat(DATE_FORMAT(date_add(`request_at`,Interval 1 MINUTE),'%Y-%m-%d %H'),':',LPAD(CAST(1 * floor(minute(date_add(`request_at`,Interval 1 MINUTE)) / 1) as int),2,0),':00')LIMIT 100; 209 stat_ts value type 210 SELECT count(*) FROM (select `statement`,system.statement_info.statement_id,IF(`status`='Running', TIMESTAMPDIFF(MICROSECOND,`request_at`,now())*1000, `duration`) AS `duration`,`status`,`query_type`,`request_at`,system.statement_info.response_at,`user`,`database`,`transaction_id`,`session_id`,`rows_read`,`bytes_scan`,`result_count` from system.statement_info left join mo_catalog.statement_mo ON system.statement_info.statement_id = mo_catalog.statement_mo.statement_id where 1=1 AND `request_at` >= '2023-07-28 04:09:33' AND system.statement_info.statement_id LIKE '%cd%' AND system.statement_info.account = 'c3daefe4_2197_4192_a10e_d0acc5d9da30' AND `user` IN ('ab') AND `session_id` LIKE '%ef%' AND `duration` > 1000000000 AND `statement` LIKE '%show%' ESCAPE '\\\\' )t; 211 SQL parser error: table "statement_mo" does not exist 212 SELECT count(*) FROM `mo_catalog`.`mo_database`; 213 count(*) 214 6 215 SELECT count(*) FROM `system`.`statement_info` WHERE 1=1 AND `request_at` >= '2023-07-28 03:03:28' AND system.statement_info.account = '91731e77_49ea_4a8a_b1c7_d5512c7ae96e' AND sql_source_type IN ('ab','external_sql') ; 216 count(*) 217 0 218 SHOW CREATE TABLE information_schema.engines; 219 Table Create Table 220 engines CREATE TABLE `engines` (\n`engine` VARCHAR(64) DEFAULT NULL,\n`support` VARCHAR(8) DEFAULT NULL,\n`comment` VARCHAR(160) DEFAULT NULL,\n`transactions` VARCHAR(3) DEFAULT NULL,\n`xa` VARCHAR(3) DEFAULT NULL,\n`savepoints` VARCHAR(3) DEFAULT NULL\n) 221 SHOW CREATE TABLE information_schema.key_column_usage; 222 Table Create Table 223 key_column_usage CREATE TABLE `key_column_usage` (\n`constraint_catalog` VARCHAR(64) DEFAULT NULL,\n`constraint_schema` VARCHAR(64) DEFAULT NULL,\n`constraint_name` VARCHAR(64) DEFAULT NULL,\n`table_catalog` VARCHAR(64) DEFAULT NULL,\n`table_schema` VARCHAR(64) DEFAULT NULL,\n`table_name` VARCHAR(64) DEFAULT NULL,\n`column_name` VARCHAR(64) DEFAULT NULL,\n`ordinal_position` INT UNSIGNED DEFAULT NULL,\n`position_in_unique_constraint` INT UNSIGNED DEFAULT NULL,\n`referenced_table_schema` VARCHAR(64) DEFAULT NULL,\n`referenced_table_name` VARCHAR(64) DEFAULT NULL,\n`referenced_column_name` VARCHAR(64) DEFAULT NULL\n) 224 SHOW CREATE TABLE information_schema.keywords; 225 Table Create Table 226 keywords CREATE TABLE `keywords` (\n`word` VARCHAR(64) DEFAULT NULL,\n`reserved` INT UNSIGNED DEFAULT NULL\n) 227 SHOW CREATE TABLE information_schema.parameters; 228 Table Create Table 229 parameters CREATE TABLE `parameters` (\n`specific_catalog` VARCHAR(64) DEFAULT NULL,\n`specific_schema` VARCHAR(64) DEFAULT NULL,\n`specific_name` VARCHAR(64) DEFAULT NULL,\n`ordinal_position` BIGINT UNSIGNED DEFAULT NULL,\n`parameter_mode` VARCHAR(5) DEFAULT NULL,\n`parameter_name` VARCHAR(64) DEFAULT NULL,\n`data_type` TEXT DEFAULT NULL,\n`character_maximum_length` BIGINT DEFAULT NULL,\n`character_octet_length` BIGINT DEFAULT NULL,\n`numeric_precision` INT UNSIGNED DEFAULT NULL,\n`numeric_scale` BIGINT DEFAULT NULL,\n`datetime_precision` INT UNSIGNED DEFAULT NULL,\n`character_set_name` VARCHAR(64) DEFAULT NULL,\n`collation_name` VARCHAR(64) DEFAULT NULL,\n`dtd_identifier` TEXT DEFAULT NULL,\n`routine_type` VARCHAR(64) DEFAULT NULL\n) 230 SHOW CREATE TABLE mo_catalog.mo_columns; 231 Table Create Table 232 mo_columns CREATE TABLE `mo_columns` (\n`att_uniq_name` VARCHAR(256) DEFAULT NULL,\n`account_id` INT UNSIGNED DEFAULT NULL,\n`att_database_id` BIGINT UNSIGNED DEFAULT NULL,\n`att_database` VARCHAR(256) DEFAULT NULL,\n`att_relname_id` BIGINT UNSIGNED DEFAULT NULL,\n`att_relname` VARCHAR(256) DEFAULT NULL,\n`attname` VARCHAR(256) DEFAULT NULL,\n`atttyp` VARCHAR(256) DEFAULT NULL,\n`attnum` INT DEFAULT NULL,\n`att_length` INT DEFAULT NULL,\n`attnotnull` TINYINT DEFAULT NULL,\n`atthasdef` TINYINT DEFAULT NULL,\n`att_default` VARCHAR(2048) DEFAULT NULL,\n`attisdropped` TINYINT DEFAULT NULL,\n`att_constraint_type` CHAR(1) DEFAULT NULL,\n`att_is_unsigned` TINYINT DEFAULT NULL,\n`att_is_auto_increment` TINYINT DEFAULT NULL,\n`att_comment` VARCHAR(2048) DEFAULT NULL,\n`att_is_hidden` TINYINT DEFAULT NULL,\n`attr_has_update` TINYINT DEFAULT NULL,\n`attr_update` VARCHAR(2048) DEFAULT NULL,\n`attr_is_clusterby` TINYINT DEFAULT NULL,\n`attr_seqnum` SMALLINT UNSIGNED DEFAULT NULL,\n`attr_enum` VARCHAR(65535) DEFAULT NULL,\nPRIMARY KEY (`att_uniq_name`)\n) 233 SHOW CREATE TABLE mo_sample_data_tpch_sf1.lineitem; 234 invalid database mo_sample_data_tpch_sf1 235 SHOW CREATE TABLE mo_sample_data_tpch_sf1.supplier; 236 invalid database mo_sample_data_tpch_sf1 237 SHOW CREATE TABLE mysql.columns_priv; 238 Table Create Table 239 columns_priv CREATE TABLE `columns_priv` (\n`host` CHAR(255) DEFAULT '',\n`db` CHAR(64) DEFAULT '',\n`user` CHAR(32) DEFAULT '',\n`table_name` CHAR(64) DEFAULT '',\n`column_name` CHAR(64) DEFAULT '',\n`timestamp` TIMESTAMP DEFAULT current_timestamp() ON UPDATE current_timestamp(),\n`column_priv` VARCHAR(10) DEFAULT '',\nPRIMARY KEY (`host`,`db`,`user`,`table_name`,`column_name`)\n) 240 SHOW CREATE TABLE mysql.db; 241 Table Create Table 242 db CREATE TABLE `db` (\n`host` CHAR(255) DEFAULT '',\n`db` CHAR(64) DEFAULT '',\n`user` CHAR(32) DEFAULT '',\n`select_priv` VARCHAR(10) DEFAULT 'N',\n`insert_priv` VARCHAR(10) DEFAULT 'N',\n`update_priv` VARCHAR(10) DEFAULT 'N',\n`delete_priv` VARCHAR(10) DEFAULT 'N',\n`create_priv` VARCHAR(10) DEFAULT 'N',\n`drop_priv` VARCHAR(10) DEFAULT 'N',\n`grant_priv` VARCHAR(10) DEFAULT 'N',\n`references_priv` VARCHAR(10) DEFAULT 'N',\n`index_priv` VARCHAR(10) DEFAULT 'N',\n`alter_priv` VARCHAR(10) DEFAULT 'N',\n`create_tmp_table_priv` VARCHAR(10) DEFAULT 'N',\n`lock_tables_priv` VARCHAR(10) DEFAULT 'N',\n`create_view_priv` VARCHAR(10) DEFAULT 'N',\n`show_view_priv` VARCHAR(10) DEFAULT 'N',\n`create_routine_priv` VARCHAR(10) DEFAULT 'N',\n`alter_routine_priv` VARCHAR(10) DEFAULT 'N',\n`execute_priv` VARCHAR(10) DEFAULT 'N',\n`event_priv` VARCHAR(10) DEFAULT 'N',\n`trigger_priv` VARCHAR(10) DEFAULT 'N',\nPRIMARY KEY (`host`,`db`,`user`),\nKEY `user` (`user`)\n) 243 SHOW CREATE TABLE mysql.procs_priv; 244 Table Create Table 245 procs_priv CREATE TABLE `procs_priv` (\n`host` CHAR(255) DEFAULT '',\n`db` CHAR(64) DEFAULT '',\n`user` CHAR(32) DEFAULT '',\n`routine_name` CHAR(64) DEFAULT '',\n`routine_type` VARCHAR(10) NOT NULL,\n`grantor` VARCHAR(288) DEFAULT '',\n`proc_priv` VARCHAR(10) DEFAULT '',\n`timestamp` TIMESTAMP DEFAULT current_timestamp() ON UPDATE current_timestamp(),\nPRIMARY KEY (`host`,`db`,`user`,`routine_name`,`routine_type`),\nKEY `grantor` (`grantor`)\n) 246 SHOW CREATE TABLE mysql.tables_priv; 247 Table Create Table 248 tables_priv CREATE TABLE `tables_priv` (\n`host` CHAR(255) DEFAULT '',\n`db` CHAR(64) DEFAULT '',\n`user` CHAR(32) DEFAULT '',\n`table_name` CHAR(64) DEFAULT '',\n`grantor` VARCHAR(288) DEFAULT '',\n`timestamp` TIMESTAMP DEFAULT current_timestamp() ON UPDATE current_timestamp(),\n`table_priv` VARCHAR(10) DEFAULT '',\n`column_priv` VARCHAR(10) DEFAULT '',\nPRIMARY KEY (`host`,`db`,`user`,`table_name`),\nKEY `grantor` (`grantor`)\n) 249 SHOW CREATE TABLE mysql.user; 250 Table Create Table 251 user CREATE TABLE `user` (\n`host` CHAR(255) DEFAULT '',\n`user` CHAR(32) DEFAULT '',\n`select_priv` VARCHAR(10) DEFAULT 'N',\n`insert_priv` VARCHAR(10) DEFAULT 'N',\n`update_priv` VARCHAR(10) DEFAULT 'N',\n`delete_priv` VARCHAR(10) DEFAULT 'N',\n`create_priv` VARCHAR(10) DEFAULT 'N',\n`drop_priv` VARCHAR(10) DEFAULT 'N',\n`reload_priv` VARCHAR(10) DEFAULT 'N',\n`shutdown_priv` VARCHAR(10) DEFAULT 'N',\n`process_priv` VARCHAR(10) DEFAULT 'N',\n`file_priv` VARCHAR(10) DEFAULT 'N',\n`grant_priv` VARCHAR(10) DEFAULT 'N',\n`references_priv` VARCHAR(10) DEFAULT 'N',\n`index_priv` VARCHAR(10) DEFAULT 'N',\n`alter_priv` VARCHAR(10) DEFAULT 'N',\n`show_db_priv` VARCHAR(10) DEFAULT 'N',\n`super_priv` VARCHAR(10) DEFAULT 'N',\n`create_tmp_table_priv` VARCHAR(10) DEFAULT 'N',\n`lock_tables_priv` VARCHAR(10) DEFAULT 'N',\n`execute_priv` VARCHAR(10) DEFAULT 'N',\n`repl_slave_priv` VARCHAR(10) DEFAULT 'N',\n`repl_client_priv` VARCHAR(10) DEFAULT 'N',\n`create_view_priv` VARCHAR(10) DEFAULT 'N',\n`show_view_priv` VARCHAR(10) DEFAULT 'N',\n`create_routine_priv` VARCHAR(10) DEFAULT 'N',\n`alter_routine_priv` VARCHAR(10) DEFAULT 'N',\n`create_user_priv` VARCHAR(10) DEFAULT 'N',\n`event_priv` VARCHAR(10) DEFAULT 'N',\n`trigger_priv` VARCHAR(10) DEFAULT 'N',\n`create_tablespace_priv` VARCHAR(10) DEFAULT 'N',\n`ssl_type` VARCHAR(10) DEFAULT '',\n`ssl_cipher` BLOB NOT NULL,\n`x509_issuer` BLOB NOT NULL,\n`x509_subject` BLOB NOT NULL,\n`max_questions` INT UNSIGNED DEFAULT '0',\n`max_updates` INT UNSIGNED DEFAULT '0',\n`max_connections` INT UNSIGNED DEFAULT '0',\n`max_user_connections` INT UNSIGNED DEFAULT '0',\n`plugin` CHAR(64) DEFAULT 'caching_sha2_password',\n`authentication_string` TEXT DEFAULT NULL,\n`password_expired` VARCHAR(10) DEFAULT 'N',\n`password_last_changed` TIMESTAMP DEFAULT null,\n`password_lifetime` SMALLINT UNSIGNED DEFAULT null,\n`account_locked` VARCHAR(10) DEFAULT 'N',\n`create_role_priv` VARCHAR(10) DEFAULT 'N',\n`drop_role_priv` VARCHAR(10) DEFAULT 'N',\n`password_reuse_history` SMALLINT UNSIGNED DEFAULT null,\n`password_reuse_time` SMALLINT UNSIGNED DEFAULT null,\n`password_require_current` VARCHAR(10) DEFAULT null,\n`user_attributes` JSON DEFAULT null,\nPRIMARY KEY (`host`,`user`)\n) 252 SHOW CREATE TABLE system_metrics.metric; 253 Table Create Table 254 metric CREATE TABLE `metric` (\n`metric_name` VARCHAR(1024) DEFAULT 'sys' COMMENT 'metric name, like: sql_statement_total, server_connections, process_cpu_percent, sys_memory_used, ...',\n`collecttime` DATETIME NOT NULL COMMENT 'metric data collect time',\n`value` DOUBLE DEFAULT '0.0' COMMENT 'metric value',\n`node` VARCHAR(1024) DEFAULT 'monolithic' COMMENT 'mo node uuid',\n`role` VARCHAR(1024) DEFAULT 'monolithic' COMMENT 'mo node role, like: CN, DN, LOG',\n`account` VARCHAR(1024) DEFAULT 'sys' COMMENT 'account name',\n`type` VARCHAR(1024) NOT NULL COMMENT 'sql type, like: insert, select, ...'\n) CLUSTER BY (`collecttime`, `metric_name`, `account`) 255 SHOW CREATE TABLE system_metrics.server_connections; 256 View Create View character_set_client collation_connection 257 server_connections CREATE VIEW IF NOT EXISTS `system_metrics`.`server_connections` as select `collecttime`, `value`, `node`, `role`, `account` from `system_metrics`.`metric` where `metric_name` = "server_connections" utf8mb4 utf8mb4_general_ci 258 SHOW CREATE TABLE system_metrics.server_storage_usage; 259 View Create View character_set_client collation_connection 260 server_storage_usage CREATE VIEW IF NOT EXISTS `system_metrics`.`server_storage_usage` as select `collecttime`, `value`, `node`, `role`, `account` from `system_metrics`.`metric` where `metric_name` = "server_storage_usage" utf8mb4 utf8mb4_general_ci 261 SHOW CREATE TABLE system_metrics.sql_statement_errors; 262 View Create View character_set_client collation_connection 263 sql_statement_errors CREATE VIEW IF NOT EXISTS `system_metrics`.`sql_statement_errors` as select `collecttime`, `value`, `node`, `role`, `account`, `type` from `system_metrics`.`metric` where `metric_name` = "sql_statement_errors" utf8mb4 utf8mb4_general_ci 264 SHOW CREATE TABLE system_metrics.sql_transaction_total; 265 View Create View character_set_client collation_connection 266 sql_transaction_total CREATE VIEW IF NOT EXISTS `system_metrics`.`sql_transaction_total` as select `collecttime`, `value`, `node`, `role`, `account` from `system_metrics`.`metric` where `metric_name` = "sql_transaction_total" utf8mb4 utf8mb4_general_ci 267 SHOW GLOBAL VARIABLES LIKE 'save_query_result'; 268 Variable_name Value 269 save_query_result off 270 SHOW SUBSCRIPTIONS; 271 pub_name pub_account pub_database pub_time sub_name sub_time 272 SHOW TABLES FROM mo_sample_data_tpch_sf1; 273 invalid database mo_sample_data_tpch_sf1 274 UPDATE `mo_mo`.`operation` SET `created_at`='2023-07-28 05:00:13.704',`statement_id`='a3055a4e-2d03-11ee-9e81-96ce077ba0f3',`connection_id`=11349,`db`='mo_sample_data_tpch_sf10',`run_status`='success' WHERE `id` = '3b30a3c1-4dca-4ded-9576-51a99e47b53a'; 275 drop table if exists `mo_catalog`.`statement_mo`; 276 internal error: do not have privilege to execute the statement 277 drop table if exists `statement_time`; 278 drop table if exists `stu`; 279 drop table if exists `mo_mo`.`wb_version`; 280 drop table if exists `mo_mo`.`wb`; 281 drop table if exists `moins`; 282 drop table if exists `operation`; 283 drop table if exists `storage_time`; 284 drop table if exists `storage`; 285 USE system_metrics; 286 SELECT `stat_ts`, SUM(`value`) as value, `type` FROM(SELECT concat(DATE_FORMAT(date_add(`collecttime`,Interval 1 MINUTE),'%Y-%m-%d %H'),':',LPAD(CAST(1 * floor(minute(date_add(`collecttime`,Interval 1 MINUTE)) / 1) as int),2,0),':00') AS stat_ts, AVG(`value`)/15 AS value, `node`, `type` FROM sql_statement_total WHERE `collecttime` >= '2023-07-28 05:37:43' AND `collecttime` <= '2023-07-28 06:07:43' AND `type` in ('DQL','DDL','DML','DCL','TCL','Other') GROUP BY `node`,`type`, concat(DATE_FORMAT(date_add(`collecttime`,Interval 1 MINUTE),'%Y-%m-%d %H'),':',LPAD(CAST(1 * floor(minute(date_add(`collecttime`,Interval 1 MINUTE)) / 1) as int),2,0),':00') ORDER BY concat(DATE_FORMAT(date_add(`collecttime`,Interval 1 MINUTE),'%Y-%m-%d %H'),':',LPAD(CAST(1 * floor(minute(date_add(`collecttime`,Interval 1 MINUTE)) / 1) as int),2,0),':00') LIMIT 100)t GROUP BY `stat_ts`,`type`; 287 stat_ts value type 288 USE system_metrics; 289 SELECT `stat_ts`, SUM(`value`) as value, `type` FROM(SELECT concat(DATE_FORMAT(date_add(`collecttime`,Interval 1 MINUTE),'%Y-%m-%d %H'),':',LPAD(CAST(1 * floor(minute(date_add(`collecttime`,Interval 1 MINUTE)) / 1) as int),2,0),':00') AS stat_ts, SUM(`value`) AS value, `node`, `type` FROM sql_statement_errors WHERE `collecttime` >= '2023-07-28 05:37:43' AND `collecttime` <= '2023-07-28 06:07:43' AND `type` in ('DQL','DDL','DML','DCL','TCL','Other') GROUP BY `node`,`type`, concat(DATE_FORMAT(date_add(`collecttime`,Interval 1 MINUTE),'%Y-%m-%d %H'),':',LPAD(CAST(1 * floor(minute(date_add(`collecttime`,Interval 1 MINUTE)) / 1) as int),2,0),':00') ORDER BY concat(DATE_FORMAT(date_add(`collecttime`,Interval 1 MINUTE),'%Y-%m-%d %H'),':',LPAD(CAST(1 * floor(minute(date_add(`collecttime`,Interval 1 MINUTE)) / 1) as int),2,0),':00') LIMIT 100)t GROUP BY `stat_ts`,`type`; 290 stat_ts value type 291 USE system_metrics; 292 SELECT `stat_ts`, SUM(`value`) as value, `type` FROM(SELECT concat(DATE_FORMAT(date_add(`collecttime`,Interval 1 MINUTE),'%Y-%m-%d %H'),':',LPAD(CAST(1 * floor(minute(date_add(`collecttime`,Interval 1 MINUTE)) / 1) as int),2,0),':00') AS stat_ts, SUM(`value`) AS value, `node`, `type` FROM sql_statement_total WHERE `collecttime` >= '2023-07-28 05:37:43' AND `collecttime` <= '2023-07-28 06:07:43' AND `type` in ('DQL','DDL','DML','DCL','TCL','Other') GROUP BY `node`,`type`, concat(DATE_FORMAT(date_add(`collecttime`,Interval 1 MINUTE),'%Y-%m-%d %H'),':',LPAD(CAST(1 * floor(minute(date_add(`collecttime`,Interval 1 MINUTE)) / 1) as int),2,0),':00') ORDER BY concat(DATE_FORMAT(date_add(`collecttime`,Interval 1 MINUTE),'%Y-%m-%d %H'),':',LPAD(CAST(1 * floor(minute(date_add(`collecttime`,Interval 1 MINUTE)) / 1) as int),2,0),':00') LIMIT 100)t GROUP BY `stat_ts`,`type`; 293 stat_ts value type 294 USE system_metrics; 295 SELECT `stat_ts`, sum(`value`) as value FROM(SELECT concat(DATE_FORMAT(date_add(`collecttime`,Interval 1 MINUTE),'%Y-%m-%d %H'),':',LPAD(CAST(1 * floor(minute(date_add(`collecttime`,Interval 1 MINUTE)) / 1) as int),2,0),':00') AS stat_ts, AVG(`value`) AS value, `node` FROM server_connections WHERE `collecttime` >= '2023-07-28 03:23:31' AND `collecttime` <= '2023-07-28 03:53:31' AND account = '2ef38bf3_b821_4cab_879e_3b788f1e922f'GROUP BY `node`, concat(DATE_FORMAT(date_add(`collecttime`,Interval 1 MINUTE),'%Y-%m-%d %H'),':',LPAD(CAST(1 * floor(minute(date_add(`collecttime`,Interval 1 MINUTE)) / 1) as int),2,0),':00') ORDER BY concat(DATE_FORMAT(date_add(`collecttime`,Interval 1 MINUTE),'%Y-%m-%d %H'),':',LPAD(CAST(1 * floor(minute(date_add(`collecttime`,Interval 1 MINUTE)) / 1) as int),2,0),':00') LIMIT 100)t GROUP BY `stat_ts`; 296 stat_ts value 297 USE system_metrics; 298 SELECT `stat_ts`, sum(`value`) as value FROM(SELECT concat(DATE_FORMAT(date_add(`collecttime`,Interval 1 MINUTE),'%Y-%m-%d %H'),':',LPAD(CAST(1 * floor(minute(date_add(`collecttime`,Interval 1 MINUTE)) / 1) as int),2,0),':00') AS stat_ts, AVG(`value`) AS value, `node` FROM server_storage_usage WHERE `collecttime` >= '2023-07-28 05:36:55' AND `collecttime` <= '2023-07-28 06:06:55' AND account = 'c3daefe4_2197_4192_a10e_d0acc5d9da30'GROUP BY `node`, concat(DATE_FORMAT(date_add(`collecttime`,Interval 1 MINUTE),'%Y-%m-%d %H'),':',LPAD(CAST(1 * floor(minute(date_add(`collecttime`,Interval 1 MINUTE)) / 1) as int),2,0),':00') ORDER BY concat(DATE_FORMAT(date_add(`collecttime`,Interval 1 MINUTE),'%Y-%m-%d %H'),':',LPAD(CAST(1 * floor(minute(date_add(`collecttime`,Interval 1 MINUTE)) / 1) as int),2,0),':00') LIMIT 100)t GROUP BY `stat_ts`; 299 stat_ts value 300 USE system_metrics; 301 SELECT `stat_ts`, sum(`value`) as value FROM(SELECT concat(DATE_FORMAT(date_add(`collecttime`,Interval 1 MINUTE),'%Y-%m-%d %H'),':',LPAD(CAST(1 * floor(minute(date_add(`collecttime`,Interval 1 MINUTE)) / 1) as int),2,0),':00') AS stat_ts, SUM(`value`) AS value, `node` FROM sql_transaction_errors WHERE `collecttime` >= '2023-07-28 05:37:43' AND `collecttime` <= '2023-07-28 06:07:43' GROUP BY `node`, concat(DATE_FORMAT(date_add(`collecttime`,Interval 1 MINUTE),'%Y-%m-%d %H'),':',LPAD(CAST(1 * floor(minute(date_add(`collecttime`,Interval 1 MINUTE)) / 1) as int),2,0),':00') ORDER BY concat(DATE_FORMAT(date_add(`collecttime`,Interval 1 MINUTE),'%Y-%m-%d %H'),':',LPAD(CAST(1 * floor(minute(date_add(`collecttime`,Interval 1 MINUTE)) / 1) as int),2,0),':00') LIMIT 100)t GROUP BY `stat_ts`; 302 stat_ts value 303 USE system_metrics; 304 SELECT `stat_ts`, sum(`value`) as value FROM(SELECT concat(DATE_FORMAT(date_add(`collecttime`,Interval 1 MINUTE),'%Y-%m-%d %H'),':',LPAD(CAST(1 * floor(minute(date_add(`collecttime`,Interval 1 MINUTE)) / 1) as int),2,0),':00') AS stat_ts, SUM(`value`) AS value, `node` FROM sql_transaction_total WHERE `collecttime` >= '2023-07-28 05:37:43' AND `collecttime` <= '2023-07-28 06:07:43' GROUP BY `node`, concat(DATE_FORMAT(date_add(`collecttime`,Interval 1 MINUTE),'%Y-%m-%d %H'),':',LPAD(CAST(1 * floor(minute(date_add(`collecttime`,Interval 1 MINUTE)) / 1) as int),2,0),':00') ORDER BY concat(DATE_FORMAT(date_add(`collecttime`,Interval 1 MINUTE),'%Y-%m-%d %H'),':',LPAD(CAST(1 * floor(minute(date_add(`collecttime`,Interval 1 MINUTE)) / 1) as int),2,0),':00') LIMIT 100)t GROUP BY `stat_ts`; 305 stat_ts value 306 select count(*) from mo_catalog.mo_tables where reldatabase = 'mo_mo' and relname = 'operation' and relkind = 'r'; 307 count(*) 308 0 309 select count(*) from mo_catalog.mo_tables where reldatabase = 'mo_mo' and relname = 'wb' and relkind = 'r'; 310 count(*) 311 0 312 DESC `information_schema`.`character_sets` ; 313 Field Type Null Key Default Extra Comment 314 character_set_name VARCHAR(64) YES null 315 default_collate_name VARCHAR(64) YES null 316 description VARCHAR(2048) YES null 317 maxlen INT UNSIGNED(32) YES null 318 DESC `information_schema`.`engines` ; 319 Field Type Null Key Default Extra Comment 320 engine VARCHAR(64) YES null 321 support VARCHAR(8) YES null 322 comment VARCHAR(160) YES null 323 transactions VARCHAR(3) YES null 324 xa VARCHAR(3) YES null 325 savepoints VARCHAR(3) YES null 326 DESC `information_schema`.`key_column_usage` ; 327 Field Type Null Key Default Extra Comment 328 constraint_catalog VARCHAR(64) YES null 329 constraint_schema VARCHAR(64) YES null 330 constraint_name VARCHAR(64) YES null 331 table_catalog VARCHAR(64) YES null 332 table_schema VARCHAR(64) YES null 333 table_name VARCHAR(64) YES null 334 column_name VARCHAR(64) YES null 335 ordinal_position INT UNSIGNED(32) YES null 336 position_in_unique_constraint INT UNSIGNED(32) YES null 337 referenced_table_schema VARCHAR(64) YES null 338 referenced_table_name VARCHAR(64) YES null 339 referenced_column_name VARCHAR(64) YES null 340 DESC `information_schema`.`keywords` ; 341 Field Type Null Key Default Extra Comment 342 word VARCHAR(64) YES null 343 reserved INT UNSIGNED(32) YES null 344 DESC `information_schema`.`parameters` ; 345 Field Type Null Key Default Extra Comment 346 specific_catalog VARCHAR(64) YES null 347 specific_schema VARCHAR(64) YES null 348 specific_name VARCHAR(64) YES null 349 ordinal_position BIGINT UNSIGNED(64) YES null 350 parameter_mode VARCHAR(5) YES null 351 parameter_name VARCHAR(64) YES null 352 data_type TEXT(0) YES null 353 character_maximum_length BIGINT(64) YES null 354 character_octet_length BIGINT(64) YES null 355 numeric_precision INT UNSIGNED(32) YES null 356 numeric_scale BIGINT(64) YES null 357 datetime_precision INT UNSIGNED(32) YES null 358 character_set_name VARCHAR(64) YES null 359 collation_name VARCHAR(64) YES null 360 dtd_identifier TEXT(0) YES null 361 routine_type VARCHAR(64) YES null 362 DESC `mo_catalog`.`mo_columns` ; 363 Field Type Null Key Default Extra Comment 364 att_uniq_name VARCHAR(256) YES PRI null 365 account_id INT UNSIGNED(0) YES null 366 att_database_id BIGINT UNSIGNED(0) YES null 367 att_database VARCHAR(256) YES null 368 att_relname_id BIGINT UNSIGNED(0) YES null 369 att_relname VARCHAR(256) YES null 370 attname VARCHAR(256) YES null 371 atttyp VARCHAR(256) YES null 372 attnum INT(0) YES null 373 att_length INT(0) YES null 374 attnotnull TINYINT(0) YES null 375 atthasdef TINYINT(0) YES null 376 att_default VARCHAR(2048) YES null 377 attisdropped TINYINT(0) YES null 378 att_constraint_type CHAR(1) YES null 379 att_is_unsigned TINYINT(0) YES null 380 att_is_auto_increment TINYINT(0) YES null 381 att_comment VARCHAR(2048) YES null 382 att_is_hidden TINYINT(0) YES null 383 attr_has_update TINYINT(0) YES null 384 attr_update VARCHAR(2048) YES null 385 attr_is_clusterby TINYINT(0) YES null 386 attr_seqnum SMALLINT UNSIGNED(0) YES null 387 attr_enum VARCHAR(65535) YES null 388 DESC `mo_sample_data_tpch_sf10`.`region` ; 389 invalid database mo_sample_data_tpch_sf10 390 DESC `mo_sample_data_tpch_sf1`.`customer` ; 391 invalid database mo_sample_data_tpch_sf1 392 DESC `mo_sample_data_tpch_sf1`.`lineitem` ; 393 invalid database mo_sample_data_tpch_sf1 394 DESC `mo_sample_data_tpch_sf1`.`nation` ; 395 invalid database mo_sample_data_tpch_sf1 396 DESC `mo_sample_data_tpch_sf1`.`orders` ; 397 invalid database mo_sample_data_tpch_sf1 398 DESC `mo_sample_data_tpch_sf1`.`supplier` ; 399 invalid database mo_sample_data_tpch_sf1 400 DESC `mysql`.`columns_priv` ; 401 Field Type Null Key Default Extra Comment 402 host CHAR(255) NO PRI '' 403 db CHAR(64) NO PRI '' 404 user CHAR(32) NO PRI '' 405 table_name CHAR(64) NO PRI '' 406 column_name CHAR(64) NO PRI '' 407 timestamp TIMESTAMP(0) NO current_timestamp() 408 column_priv VARCHAR(10) NO '' 409 DESC `mysql`.`db` ; 410 Field Type Null Key Default Extra Comment 411 host CHAR(255) NO PRI '' 412 db CHAR(64) NO PRI '' 413 user CHAR(32) NO PRI '' 414 select_priv VARCHAR(10) NO 'N' 415 insert_priv VARCHAR(10) NO 'N' 416 update_priv VARCHAR(10) NO 'N' 417 delete_priv VARCHAR(10) NO 'N' 418 create_priv VARCHAR(10) NO 'N' 419 drop_priv VARCHAR(10) NO 'N' 420 grant_priv VARCHAR(10) NO 'N' 421 references_priv VARCHAR(10) NO 'N' 422 index_priv VARCHAR(10) NO 'N' 423 alter_priv VARCHAR(10) NO 'N' 424 create_tmp_table_priv VARCHAR(10) NO 'N' 425 lock_tables_priv VARCHAR(10) NO 'N' 426 create_view_priv VARCHAR(10) NO 'N' 427 show_view_priv VARCHAR(10) NO 'N' 428 create_routine_priv VARCHAR(10) NO 'N' 429 alter_routine_priv VARCHAR(10) NO 'N' 430 execute_priv VARCHAR(10) NO 'N' 431 event_priv VARCHAR(10) NO 'N' 432 trigger_priv VARCHAR(10) NO 'N' 433 DESC `mysql`.`procs_priv` ; 434 Field Type Null Key Default Extra Comment 435 host CHAR(255) NO PRI '' 436 db CHAR(64) NO PRI '' 437 user CHAR(32) NO PRI '' 438 routine_name CHAR(64) NO PRI '' 439 routine_type VARCHAR(10) NO PRI null 440 grantor VARCHAR(288) NO MUL '' 441 proc_priv VARCHAR(10) NO '' 442 timestamp TIMESTAMP(0) NO current_timestamp() 443 DESC `mysql`.`tables_priv` ; 444 Field Type Null Key Default Extra Comment 445 host CHAR(255) NO PRI '' 446 db CHAR(64) NO PRI '' 447 user CHAR(32) NO PRI '' 448 table_name CHAR(64) NO PRI '' 449 grantor VARCHAR(288) NO MUL '' 450 timestamp TIMESTAMP(0) NO current_timestamp() 451 table_priv VARCHAR(10) NO '' 452 column_priv VARCHAR(10) NO '' 453 DESC `mysql`.`user` ; 454 Field Type Null Key Default Extra Comment 455 host CHAR(255) NO PRI '' 456 user CHAR(32) NO PRI '' 457 select_priv VARCHAR(10) NO 'N' 458 insert_priv VARCHAR(10) NO 'N' 459 update_priv VARCHAR(10) NO 'N' 460 delete_priv VARCHAR(10) NO 'N' 461 create_priv VARCHAR(10) NO 'N' 462 drop_priv VARCHAR(10) NO 'N' 463 reload_priv VARCHAR(10) NO 'N' 464 shutdown_priv VARCHAR(10) NO 'N' 465 process_priv VARCHAR(10) NO 'N' 466 file_priv VARCHAR(10) NO 'N' 467 grant_priv VARCHAR(10) NO 'N' 468 references_priv VARCHAR(10) NO 'N' 469 index_priv VARCHAR(10) NO 'N' 470 alter_priv VARCHAR(10) NO 'N' 471 show_db_priv VARCHAR(10) NO 'N' 472 super_priv VARCHAR(10) NO 'N' 473 create_tmp_table_priv VARCHAR(10) NO 'N' 474 lock_tables_priv VARCHAR(10) NO 'N' 475 execute_priv VARCHAR(10) NO 'N' 476 repl_slave_priv VARCHAR(10) NO 'N' 477 repl_client_priv VARCHAR(10) NO 'N' 478 create_view_priv VARCHAR(10) NO 'N' 479 show_view_priv VARCHAR(10) NO 'N' 480 create_routine_priv VARCHAR(10) NO 'N' 481 alter_routine_priv VARCHAR(10) NO 'N' 482 create_user_priv VARCHAR(10) NO 'N' 483 event_priv VARCHAR(10) NO 'N' 484 trigger_priv VARCHAR(10) NO 'N' 485 create_tablespace_priv VARCHAR(10) NO 'N' 486 ssl_type VARCHAR(10) NO '' 487 ssl_cipher BLOB(0) NO null 488 x509_issuer BLOB(0) NO null 489 x509_subject BLOB(0) NO null 490 max_questions INT UNSIGNED(32) NO '0' 491 max_updates INT UNSIGNED(32) NO '0' 492 max_connections INT UNSIGNED(32) NO '0' 493 max_user_connections INT UNSIGNED(32) NO '0' 494 plugin CHAR(64) NO 'caching_sha2_password' 495 authentication_string TEXT(0) YES null 496 password_expired VARCHAR(10) NO 'N' 497 password_last_changed TIMESTAMP(0) YES null 498 password_lifetime SMALLINT UNSIGNED(16) YES null 499 account_locked VARCHAR(10) NO 'N' 500 create_role_priv VARCHAR(10) NO 'N' 501 drop_role_priv VARCHAR(10) NO 'N' 502 password_reuse_history SMALLINT UNSIGNED(16) YES null 503 password_reuse_time SMALLINT UNSIGNED(16) YES null 504 password_require_current VARCHAR(10) YES null 505 user_attributes JSON(0) YES null 506 DESC `system_metrics`.`metric` ; 507 Field Type Null Key Default Extra Comment 508 metric_name VARCHAR(1024) YES 'sys' metric name, like: sql_statement_total, server_connections, process_cpu_percent, sys_memory_used, ... 509 collecttime DATETIME(6) NO null metric data collect time 510 value DOUBLE(0) YES '0.0' metric value 511 node VARCHAR(1024) YES 'monolithic' mo node uuid 512 role VARCHAR(1024) YES 'monolithic' mo node role, like: CN, DN, LOG 513 account VARCHAR(1024) YES 'sys' account name 514 type VARCHAR(1024) NO null sql type, like: insert, select, ... 515 DESC `system_metrics`.`server_connections` ; 516 Field Type Null Key Default Extra Comment 517 collecttime DATETIME(6) NO null 518 value DOUBLE(0) YES null 519 node VARCHAR(1024) YES null 520 role VARCHAR(1024) YES null 521 account VARCHAR(1024) YES null 522 DESC `system_metrics`.`server_storage_usage` ; 523 Field Type Null Key Default Extra Comment 524 collecttime DATETIME(6) NO null 525 value DOUBLE(0) YES null 526 node VARCHAR(1024) YES null 527 role VARCHAR(1024) YES null 528 account VARCHAR(1024) YES null 529 DESC `system_metrics`.`sql_statement_errors` ; 530 Field Type Null Key Default Extra Comment 531 collecttime DATETIME(6) NO null 532 value DOUBLE(0) YES null 533 node VARCHAR(1024) YES null 534 role VARCHAR(1024) YES null 535 account VARCHAR(1024) YES null 536 type VARCHAR(1024) NO null 537 DESC `system_metrics`.`sql_transaction_total` ; 538 Field Type Null Key Default Extra Comment 539 collecttime DATETIME(6) NO null 540 value DOUBLE(0) YES null 541 node VARCHAR(1024) YES null 542 role VARCHAR(1024) YES null 543 account VARCHAR(1024) YES null 544 INSERT INTO `mo_catalog`.`statement_mo` (`statement_id`,`account`,`response_at`,`stu`,`account_id`) VALUES ('057247c5-2d0c-11ee-9e81-96ce077ba0f3','91731e77_49ea_4a8a_b1c7_d5512c7ae96e','2023-07-28 06:00:20','0.0003963262009632',2); 545 no such table mo_catalog.statement_mo 546 INSERT INTO `mo_mo`.`statement_time` (`cluster`,`last_time`) VALUES ('ab','2023-07-28 04:50:00'); 547 no such table mo_mo.statement_time 548 INSERT INTO `mo_mo`.`stu` (`account`,`start_time`,`end_time`,`stu`,`type`) VALUES ('2ef38bf3_b821_4cab_879e_3b788f1e922f','2023-07-28 07:19:00','2023-07-28 07:20:00','0.0002629868102331','ab'); 549 no such table mo_mo.stu 550 INSERT INTO `mo_mo`.`stu` (`account`,`start_time`,`end_time`,`stu`,`type`) VALUES ('2ef38bf3_b821_4cab_879e_3b788f1e922f','2023-07-28 07:52:00','2023-07-28 07:53:00','0.0056437809323943','cd'); 551 no such table mo_mo.stu 552 INSERT INTO `mo_mo`.`moins` (`id`,`name`,`account_name`,`provider`,`provider_id`,`region`,`pty`,`version`,`status`,`qt`,`policy`,`created_by`,`created_at`) VALUES ('c3daefe4-2197-4192-a10e-d0acc5d9da30','free0','c3daefe4_2197_4192_a10e_d0acc5d9da30','ab','1527','cd','ef','nightly-2257011e','','{\stu\:1000,\storage\:53687}','{\allow_list\:[\0.0.0.0/0\]}','154b8231-cc1d-4629-88c6-d007cf4f4af8','2023-07-28 06:06:03.608'); 553 no such table mo_mo.moins 554 INSERT INTO `mo_mo`.`storage_time` (`cluster`,`last_time`) VALUES ('ab','2023-07-28 03:30:00'); 555 no such table mo_mo.storage_time 556 INSERT INTO `mo_mo`.`storage` (`collecttime`,`value`,`account`,`interval`) VALUES ('2023-07-28 03:30:00',0.075000,'301b1fe7_0d51_404e_9e18_33fe2f1d29b2',10); 557 no such table mo_mo.storage 558 INSERT INTO `mo_mo`.`wb_version` (`id`,`wb_id`,`sql_content`,`version`,`status`,`created_at`,`updated_at`) VALUES ('6c1eede6-70d9-4185-82fe-f5341777d27d','ba8f2a64-3396-465c-a770-77600865d6c2','create database hx;','2023-07-28T05:01:41Z',1,'2023-07-28 05:01:41.047','2023-07-28 05:01:41.047'); 559 no such table mo_mo.wb_version 560 INSERT INTO `mo_mo`.`wb` (`id`,`account_id`,`sql_user`,`name`,`created_at`,`updated_at`) VALUES ('30415473-5276-42c5-8302-4e9a7e605900','91731e77_49ea_4a8a_b1c7_d5512c7ae96e','admin','New sql wb 2','2023-07-28 06:21:56.89','2023-07-28 06:21:56.89'); 561 no such table mo_mo.wb 562 SELECT * FROM `mo_catalog`.`mo_account` WHERE `mo_account`.`account_name` = 'c3daefe4_2197_4192_a10e_d0acc5d9da30' ORDER BY `mo_account`.`account_name` LIMIT 1; 563 SQL parser error: table "mo_account" does not exist 564 SELECT * FROM `mo_mo`.`statement_time` WHERE cluster = 'ab' LIMIT 1; 565 SQL parser error: table "statement_time" does not exist 566 SELECT * FROM `mo_mo`.`storage_time` WHERE cluster = 'ab' LIMIT 1; 567 SQL parser error: table "storage_time" does not exist 568 SELECT * FROM `mo_mo`.`wb_version` WHERE wb_id = '9579cf34-2faf-4b9b-83dc-09638c39265a' AND id = '06945b61-372b-4289-964b-0a6b098e2c4e' ORDER BY updated_at DESC; 569 SQL parser error: table "wb_version" does not exist 570 SELECT * FROM `mo_mo`.`wb` WHERE 1=1 AND account_id = '91731e77_49ea_4a8a_b1c7_d5512c7ae96e' AND sql_user = 'admin' AND name LIKE '%New sql wb %' ORDER BY updated_at DESC LIMIT 100; 571 SQL parser error: table "wb" does not exist 572 SELECT SCHEMA_NAME from Information_schema.SCHEMATA where SCHEMA_NAME LIKE 'mo_mo%' ORDER BY SCHEMA_NAME='mo_mo' DESC,SCHEMA_NAME limit 1; 573 schema_name 574 mo_mo 575 SELECT `collecttime`,`value`,`account` FROM `system_metrics`.`server_storage_usage` WHERE account != 'sys' and account != 'ob' and collectTime >= '2023-07-28 03:23:00' and collectTime < '2023-07-28 03:30:00'; 576 collecttime value account 577 SELECT `statement_id`,`stats`,`duration`,`sql_source_type`,`account`,`response_at` FROM `system`.`statement_info` WHERE status != 'Running' and account != 'sys' and account != 'ob' and response_at >= '2023-07-28 04:49:00' and response_at < '2023-07-28 04:50:00'; 578 statement_id stats duration sql_source_type account response_at 579 SELECT `value` FROM `system_metrics`.`server_storage_usage` WHERE account = '863f0767_0361_4a8c_a3e8_73b2be140a74' and collecttime > '2023-07-28 06:07:53' and collecttime <= '2023-07-28 06:10:53' ORDER BY collecttime DESC LIMIT 1; 580 value 581 SELECT count(*) FROM `mo_mo`.`moins` WHERE id = '2ef38bf3-b821-4cab-879e-3b788f1e922f'; 582 SQL parser error: table "moins" does not exist 583 SELECT count(*) FROM `mo_mo`.`wb_version` WHERE wb_id = 'd457fd59-a865-4a5b-80b0-6e19a6059f1f'; 584 SQL parser error: table "wb_version" does not exist 585 SELECT count(*) FROM `mo_mo`.`wb` WHERE account_id = '91731e77_49ea_4a8a_b1c7_d5512c7ae96e' AND sql_user = 'admin' AND id = '30415473-5276-42c5-8302-4e9a7e605900'; 586 SQL parser error: table "wb" does not exist 587 SELECT count(*) FROM information_schema.tables WHERE table_schema = '' AND table_name = 'moins' AND table_type = 'BASE TABLE'; 588 count(*) 589 0 590 SELECT datname AS name, IF (table_cnt IS NULL, 0, table_cnt) AS tables, role_name AS owner FROM (SELECT dat_id, datname, mo_database.created_time, IF(role_name IS NULL, '-', role_name) AS role_name FROM mo_catalog.mo_database LEFT JOIN mo_catalog.mo_role ON mo_database.owner = role_id) AS x LEFT JOIN(SELECT count(*) AS table_cnt, reldatabase_id FROM mo_catalog.mo_tables WHERE relkind IN ('r','v','e','cluster') GROUP BY reldatabase_id) AS y ON x.dat_id = y.reldatabase_id order by name; 591 name tables owner 592 information_schema 23 accountadmin 593 mo_catalog 23 - 594 mo_mo 0 accountadmin 595 mysql 6 accountadmin 596 system 1 accountadmin 597 system_metrics 9 accountadmin 598 SELECT mo_catalog.mo_database.datname,mo_catalog.mo_tables.relname,mo_catalog.mo_tables.relkind, if (role_name IS NULL,'-', role_name) AS `owner` FROM mo_catalog.mo_database LEFT JOIN mo_catalog.mo_tables ON mo_catalog.mo_database.datname = mo_catalog.mo_tables.reldatabase LEFT JOIN mo_catalog.mo_role ON mo_catalog.mo_tables.owner=role_id WHERE (relname NOT LIKE "__mo_index_secondary_%" AND relname NOT LIKE "__mo_index_unique_%" OR relname IS NULL) ORDER BY reldatabase, relname; 599 datname relname relkind owner 600 mo_mo null null - 601 information_schema character_sets r accountadmin 602 information_schema collations r accountadmin 603 information_schema column_privileges r accountadmin 604 information_schema columns v accountadmin 605 information_schema engines r accountadmin 606 information_schema events r accountadmin 607 information_schema key_column_usage r accountadmin 608 information_schema keywords r accountadmin 609 information_schema parameters r accountadmin 610 information_schema partitions v accountadmin 611 information_schema processlist v accountadmin 612 information_schema profiling r accountadmin 613 information_schema referential_constraints v accountadmin 614 information_schema routines r accountadmin 615 information_schema schema_privileges r accountadmin 616 information_schema schemata v accountadmin 617 information_schema statistics v accountadmin 618 information_schema table_constraints r accountadmin 619 information_schema table_privileges r accountadmin 620 information_schema tables v accountadmin 621 information_schema triggers r accountadmin 622 information_schema user_privileges r accountadmin 623 information_schema views v accountadmin 624 mo_catalog mo_cache v accountadmin 625 mo_catalog mo_columns r - 626 mo_catalog mo_configurations v accountadmin 627 mo_catalog mo_database r - 628 mo_catalog mo_foreign_keys r accountadmin 629 mo_catalog mo_increment_columns accountadmin 630 mo_catalog mo_indexes r accountadmin 631 mo_catalog mo_locks v accountadmin 632 mo_catalog mo_mysql_compatibility_mode r accountadmin 633 mo_catalog mo_pubs r accountadmin 634 mo_catalog mo_role r accountadmin 635 mo_catalog mo_role_grant r accountadmin 636 mo_catalog mo_role_privs r accountadmin 637 mo_catalog mo_sessions v accountadmin 638 mo_catalog mo_snapshots r accountadmin 639 mo_catalog mo_stages r accountadmin 640 mo_catalog mo_stored_procedure r accountadmin 641 mo_catalog mo_table_partitions r accountadmin 642 mo_catalog mo_tables r - 643 mo_catalog mo_transactions v accountadmin 644 mo_catalog mo_user r accountadmin 645 mo_catalog mo_user_defined_function r accountadmin 646 mo_catalog mo_user_grant r accountadmin 647 mo_catalog mo_variables v accountadmin 648 mysql columns_priv r accountadmin 649 mysql db r accountadmin 650 mysql procs_priv r accountadmin 651 mysql role_edges r accountadmin 652 mysql tables_priv r accountadmin 653 mysql user r accountadmin 654 system statement_info r accountadmin 655 system_metrics metric r accountadmin 656 system_metrics server_connections v accountadmin 657 system_metrics server_storage_usage v accountadmin 658 system_metrics sql_statement_cu r accountadmin 659 system_metrics sql_statement_duration_total v accountadmin 660 system_metrics sql_statement_errors v accountadmin 661 system_metrics sql_statement_total v accountadmin 662 system_metrics sql_transaction_errors v accountadmin 663 system_metrics sql_transaction_total v accountadmin 664 SELECT relname AS `name`, IF (role_name IS NULL, '-', role_name) AS `owner` FROM mo_catalog.mo_tables LEFT JOIN mo_catalog.mo_role ON mo_catalog.mo_tables.owner=role_id WHERE relkind IN ('v') AND reldatabase='information_schema'; 665 name owner 666 columns accountadmin 667 processlist accountadmin 668 schemata accountadmin 669 tables accountadmin 670 partitions accountadmin 671 views accountadmin 672 statistics accountadmin 673 referential_constraints accountadmin 674 SELECT relname AS `name`, IF (role_name IS NULL, '-', role_name) AS `owner` FROM mo_catalog.mo_tables LEFT JOIN mo_catalog.mo_role ON mo_catalog.mo_tables.owner=role_id WHERE relkind IN ('v') AND reldatabase='mo_sample_data_tpch_sf1'; 675 name owner 676 SELECT relname AS `name`, IF (role_name IS NULL, '-', role_name) AS `owner` FROM mo_catalog.mo_tables LEFT JOIN mo_catalog.mo_role ON mo_catalog.mo_tables.owner=role_id WHERE relkind IN ('v') AND reldatabase='mysql'; 677 name owner 678 SELECT relname AS `name`, IF (role_name IS NULL, '-', role_name) AS `owner` FROM mo_catalog.mo_tables LEFT JOIN mo_catalog.mo_role ON mo_catalog.mo_tables.owner=role_id WHERE relkind IN ('v') AND reldatabase='system'; 679 name owner 680 SELECT relname AS `name`, IF (role_name IS NULL, '-', role_name) AS `owner` FROM mo_catalog.mo_tables LEFT JOIN mo_catalog.mo_role ON mo_catalog.mo_tables.owner=role_id WHERE relkind IN ('v') AND reldatabase='system_metrics'; 681 name owner 682 sql_statement_total accountadmin 683 sql_statement_errors accountadmin 684 sql_transaction_total accountadmin 685 sql_transaction_errors accountadmin 686 sql_statement_duration_total accountadmin 687 server_connections accountadmin 688 server_storage_usage accountadmin 689 SELECT relname AS `name`, mo_table_rows(reldatabase, relname) AS `rows`, mo_table_size(reldatabase, relname) AS `size`, if (role_name IS NULL, '-', role_name) AS `owner` FROM mo_catalog.mo_tables LEFT JOIN mo_catalog.mo_role ON mo_catalog.mo_tables.owner=role_id WHERE relkind IN ('r','e','cluster') AND reldatabase='information_schema'; 690 name rows size owner 691 key_column_usage 0 0 accountadmin 692 profiling 0 0 accountadmin 693 user_privileges 0 0 accountadmin 694 character_sets 0 0 accountadmin 695 triggers 0 0 accountadmin 696 engines 0 0 accountadmin 697 routines 0 0 accountadmin 698 parameters 0 0 accountadmin 699 keywords 747 45171 accountadmin 700 schema_privileges 0 0 accountadmin 701 table_privileges 0 0 accountadmin 702 column_privileges 0 0 accountadmin 703 collations 0 0 accountadmin 704 table_constraints 0 0 accountadmin 705 events 0 0 accountadmin 706 SELECT relname AS `name`, mo_table_rows(reldatabase, relname) AS `rows`, mo_table_size(reldatabase, relname) AS `size`, if (role_name IS NULL, '-', role_name) AS `owner` FROM mo_catalog.mo_tables LEFT JOIN mo_catalog.mo_role ON mo_catalog.mo_tables.owner=role_id WHERE relkind IN ('r','e','cluster') AND reldatabase='mo_sample_data_tpch_sf1'; 707 name rows size owner 708 SELECT relname AS `name`, mo_table_rows(reldatabase, relname) AS `rows`, mo_table_size(reldatabase, relname) AS `size`, if (role_name IS NULL, '-', role_name) AS `owner` FROM mo_catalog.mo_tables LEFT JOIN mo_catalog.mo_role ON mo_catalog.mo_tables.owner=role_id WHERE relkind IN ('r','e','cluster') AND reldatabase='mysql'; 709 name rows size owner 710 user 0 0 accountadmin 711 db 0 0 accountadmin 712 procs_priv 0 0 accountadmin 713 columns_priv 0 0 accountadmin 714 tables_priv 0 0 accountadmin 715 role_edges 0 0 accountadmin 716 SELECT relname AS `name`, mo_table_rows(reldatabase, relname) AS `rows`, mo_table_size(reldatabase, relname) AS `size`, if (role_name IS NULL, '-', role_name) AS `owner` FROM mo_catalog.mo_tables LEFT JOIN mo_catalog.mo_role ON mo_catalog.mo_tables.owner=role_id WHERE relkind IN ('r','e','cluster') AND reldatabase='system'; 717 name rows size owner 718 statement_info 0 0 accountadmin 719 SELECT relname AS `name`, mo_table_rows(reldatabase, relname) AS `rows`, mo_table_size(reldatabase, relname) AS `size`, if (role_name IS NULL, '-', role_name) AS `owner` FROM mo_catalog.mo_tables LEFT JOIN mo_catalog.mo_role ON mo_catalog.mo_tables.owner=role_id WHERE relkind IN ('r','e','cluster') AND reldatabase='system_metrics' order by name; 720 name rows size owner 721 metric 0 0 accountadmin 722 sql_statement_cu 0 0 accountadmin 723 SELECT count(*) FROM `system`.`statement_info` WHERE status != 'Running' and account != 'sys' and account != 'ob' ORDER BY response_at asc LIMIT 1; 724 SQL syntax error: column "statement_info.response_at" must appear in the GROUP BY clause or be used in an aggregate function 725 SELECT role_name AS owner FROM (SELECT dat_id, datname, mo_database.created_time, IF(role_name IS NULL, '-', role_name) AS role_name FROM mo_catalog.mo_database LEFT JOIN mo_catalog.mo_role ON mo_database.owner = role_id) AS x WHERE datname='information_schema'; 726 owner 727 accountadmin 728 SELECT role_name AS owner FROM (SELECT dat_id, datname, mo_database.created_time, IF(role_name IS NULL, '-', role_name) AS role_name FROM mo_catalog.mo_database LEFT JOIN mo_catalog.mo_role ON mo_database.owner = role_id) AS x WHERE datname='mo_sample_data_tpch_sf1'; 729 owner 730 SELECT role_name AS owner FROM (SELECT dat_id, datname, mo_database.created_time, IF(role_name IS NULL, '-', role_name) AS role_name FROM mo_catalog.mo_database LEFT JOIN mo_catalog.mo_role ON mo_database.owner = role_id) AS x WHERE datname='mysql'; 731 owner 732 accountadmin 733 SELECT role_name AS owner FROM (SELECT dat_id, datname, mo_database.created_time, IF(role_name IS NULL, '-', role_name) AS role_name FROM mo_catalog.mo_database LEFT JOIN mo_catalog.mo_role ON mo_database.owner = role_id) AS x WHERE datname='system'; 734 owner 735 accountadmin 736 SELECT role_name AS owner FROM (SELECT dat_id, datname, mo_database.created_time, IF(role_name IS NULL, '-', role_name) AS role_name FROM mo_catalog.mo_database LEFT JOIN mo_catalog.mo_role ON mo_database.owner = role_id) AS x WHERE datname='system_metrics'; 737 owner 738 accountadmin 739 SELECT sum(`value`*`interval`) FROM `mo_mo`.`storage` WHERE collecttime > '2023-07-28 00:00:00' AND collecttime <= '2023-07-28 03:54:39' AND account = '91731e77_49ea_4a8a_b1c7_d5512c7ae96e'; 740 SQL parser error: table "storage" does not exist 741 UPDATE `mo_mo`.`statement_time` SET `last_time`='2023-07-28 09:00:00' WHERE `cluster` = 'ab'; 742 no such table mo_mo.statement_time 743 UPDATE `mo_mo`.`storage_time` SET `last_time`='2023-07-28 03:30:00' WHERE `cluster` = 'ab'; 744 no such table mo_mo.storage_time 745 UPDATE `mo_mo`.`wb_version` SET `status`=2,`version`='2023-07-28T05:00:35Z',`updated_at`='2023-07-28 05:00:35.752' WHERE wb_id = 'ba8f2a64-3396-465c-a770-77600865d6c2' AND id = '7f660329-a51b-4b17-b981-fc9acd9b492a'; 746 no such table mo_mo.wb_version 747 UPDATE `mo_mo`.`wb` SET `updated_at`='2023-07-28 06:02:41.452' WHERE id = '9579cf34-2faf-4b9b-83dc-09638c39265a'; 748 no such table mo_mo.wb 749 alter account `2ef38bf3_b821_4cab_879e_3b788f1e922f` admin_name 'admin' identified by 'abcd'; 750 internal error: do not have privilege to execute the statement 751 delete from mo_mo.operation where created_at <= '2023-07-21 13:42:02'; 752 no such table mo_mo.operation 753 select distinct IF(relkind = 'v', 0, mo_table_rows('information_schema','character_sets')) as `rows` from mo_catalog.mo_tables where reldatabase='information_schema' and relname='character_sets'; 754 rows 755 0 756 select distinct IF(relkind = 'v', 0, mo_table_rows('mo_sample_data_tpch_sf1','customer')) as `rows` from mo_catalog.mo_tables where reldatabase='mo_sample_data_tpch_sf1' and relname='customer'; 757 rows 758 select distinct IF(relkind = 'v', 0, mo_table_rows('mo_sample_data_tpch_sf1','lineitem')) as `rows` from mo_catalog.mo_tables where reldatabase='mo_sample_data_tpch_sf1' and relname='lineitem'; 759 rows 760 select distinct IF(relkind = 'v', 0, mo_table_rows('mo_sample_data_tpch_sf1','nation')) as `rows` from mo_catalog.mo_tables where reldatabase='mo_sample_data_tpch_sf1' and relname='nation'; 761 rows 762 select distinct IF(relkind = 'v', 0, mo_table_rows('mo_sample_data_tpch_sf1','orders')) as `rows` from mo_catalog.mo_tables where reldatabase='mo_sample_data_tpch_sf1' and relname='orders'; 763 rows 764 select distinct IF(relkind = 'v', 0, mo_table_rows('mo_sample_data_tpch_sf1','supplier')) as `rows` from mo_catalog.mo_tables where reldatabase='mo_sample_data_tpch_sf1' and relname='supplier'; 765 rows 766 select distinct IF(relkind = 'v', 0, mo_table_rows('mo_sample_data_tpch_sf10','region')) as `rows` from mo_catalog.mo_tables where reldatabase='mo_sample_data_tpch_sf10' and relname='region'; 767 rows 768 select sum(stu) from mo_mo.stu where account = '863f0767_0361_4a8c_a3e8_73b2be140a74' and start_time >= '2023-07-28 03:34:59' and start_time <= '2023-07-28 06:10:52'; 769 SQL parser error: table "stu" does not exist 770 drop database if exists mo_mo; 771 drop account test_tenant_1; 772 select table_name from information_schema.tables where table_schema collate utf8_general_ci = 'information_schema' and table_name collate utf8_general_ci = 'parameters'; 773 table_name 774 parameters