github.com/matrixorigin/matrixone@v1.2.0/test/distributed/cases/table/system_table_cases.result (about) 1 USE system; 2 SELECT COUNT(*) FROM (SELECT * FROM statement_info LIMIT 10) AS temp; 3 count(*) 4 10 5 SELECT COUNT(0) FROM (SELECT * FROM statement_info LIMIT 10) AS temp; 6 count(0) 7 10 8 SELECT COUNT('') FROM (SELECT * FROM statement_info LIMIT 10) AS temp; 9 count() 10 10 11 SELECT COUNT(NULL) FROM (SELECT * FROM statement_info LIMIT 10) AS temp; 12 count(null) 13 0 14 (SELECT * FROM statement_info LIMIT 1) UNION ALL (SELECT * FROM statement_info LIMIT 1); 15 statement_id transaction_id session_id account user host database statement statement_tag statement_fingerprint node_uuid node_type request_at response_at duration status err_code error exec_plan rows_read bytes_scan 16 f435783f-602c-11ed-bb7f-000c29847904 00000000-0000-0000-0000-000000000000 f4350b5b-602c-11ed-bb7f-000c29847904 sys 0a1264f1-fb77-4f3b-8b6e-1611dd0f8438 0.0.0.0 use mo_task 7c4dccb4-4d3c-41f8-b482-5251dc7a41bf ALL 2022-11-09 20:49:31.032463000 2022-11-09 20:49:31.033148000 685200 Failed 20402 invalid database mo_task {"code": 200, "message": "sql query no record execution plan", "steps": null, "success": false, "uuid": "f435783f-602c-11ed-bb7f-000c29847904"} 0 0 17 f435783f-602c-11ed-bb7f-000c29847904 00000000-0000-0000-0000-000000000000 f4350b5b-602c-11ed-bb7f-000c29847904 sys 0a1264f1-fb77-4f3b-8b6e-1611dd0f8438 0.0.0.0 use mo_task 7c4dccb4-4d3c-41f8-b482-5251dc7a41bf ALL 2022-11-09 20:49:31.032463000 2022-11-09 20:49:31.033148000 685200 Failed 20402 invalid database mo_task {"code": 200, "message": "sql query no record execution plan", "steps": null, "success": false, "uuid": "f435783f-602c-11ed-bb7f-000c29847904"} 0 0 18 SELECT COUNT(*) FROM (SELECT * FROM rawlog LIMIT 10) AS temp; 19 count(*) 20 10 21 SELECT COUNT(0) FROM (SELECT * FROM rawlog LIMIT 10) AS temp; 22 count(0) 23 10 24 SELECT COUNT('') FROM (SELECT * FROM rawlog LIMIT 10) AS temp; 25 count() 26 10 27 SELECT COUNT(NULL) FROM (SELECT * FROM rawlog LIMIT 10) AS temp; 28 count(null) 29 0 30 SELECT COUNT(*) FROM (SELECT * FROM log_info LIMIT 10) AS temp; 31 count(*) 32 10 33 SELECT COUNT(0) FROM (SELECT * FROM log_info LIMIT 10) AS temp; 34 count(0) 35 10 36 SELECT COUNT('') FROM (SELECT * FROM log_info LIMIT 10) AS temp; 37 count() 38 10 39 SELECT COUNT(NULL) FROM (SELECT * FROM log_info LIMIT 10) AS temp; 40 count(null) 41 0 42 SELECT COUNT(*) FROM (SELECT * FROM error_info LIMIT 10) AS temp; 43 count(*) 44 10 45 SELECT COUNT(0) FROM (SELECT * FROM error_info LIMIT 10) AS temp; 46 count(0) 47 10 48 SELECT COUNT('') FROM (SELECT * FROM error_info LIMIT 10) AS temp; 49 count() 50 10 51 SELECT COUNT(NULL) FROM (SELECT * FROM error_info LIMIT 10) AS temp; 52 count(null) 53 0 54 SELECT COUNT(*) FROM (SELECT * FROM span_info LIMIT 0) AS temp; 55 count(*) 56 0 57 SELECT COUNT(0) FROM (SELECT * FROM span_info LIMIT 0) AS temp; 58 count(0) 59 0 60 SELECT COUNT('') FROM (SELECT * FROM span_info LIMIT 0) AS temp; 61 count('') 62 0 63 SELECT COUNT(NULL) FROM (SELECT * FROM span_info LIMIT 0) AS temp; 64 count(NULL) 65 0 66 USE system_metrics; 67 SELECT COUNT(*) FROM (SELECT * FROM metric LIMIT 10) AS temp; 68 count(*) 69 10 70 SELECT COUNT(0) FROM (SELECT * FROM metric LIMIT 10) AS temp; 71 count(0) 72 10 73 SELECT COUNT('') FROM (SELECT * FROM metric LIMIT 10) AS temp; 74 count() 75 10 76 SELECT COUNT(NULL) FROM (SELECT * FROM metric LIMIT 10) AS temp; 77 count(null) 78 0 79 SELECT COUNT(*) FROM (SELECT * FROM sql_statement_total LIMIT 10) AS temp; 80 count(*) 81 10 82 SELECT COUNT(0) FROM (SELECT * FROM sql_statement_total LIMIT 10) AS temp; 83 count(0) 84 10 85 SELECT COUNT('') FROM (SELECT * FROM sql_statement_total LIMIT 10) AS temp; 86 count() 87 10 88 SELECT COUNT(NULL) FROM (SELECT * FROM sql_statement_total LIMIT 10) AS temp; 89 count(null) 90 0 91 SELECT COUNT(NULL) FROM (SELECT * FROM sql_statement_errors LIMIT 10) AS temp; 92 count(null) 93 0 94 SELECT COUNT(*) FROM (SELECT * FROM sql_transaction_total LIMIT 10) AS temp; 95 count(*) 96 10 97 SELECT COUNT(0) FROM (SELECT * FROM sql_transaction_total LIMIT 10) AS temp; 98 count(0) 99 10 100 SELECT COUNT('') FROM (SELECT * FROM sql_transaction_total LIMIT 10) AS temp; 101 count() 102 10 103 SELECT COUNT(NULL) FROM (SELECT * FROM sql_transaction_total LIMIT 10) AS temp; 104 count(null) 105 0 106 SELECT COUNT(*) FROM (SELECT * FROM sql_transaction_errors LIMIT 10) AS temp; 107 count(*) 108 10 109 SELECT COUNT(0) FROM (SELECT * FROM sql_transaction_errors LIMIT 10) AS temp; 110 count(0) 111 10 112 SELECT COUNT('') FROM (SELECT * FROM sql_transaction_errors LIMIT 10) AS temp; 113 count() 114 10 115 SELECT COUNT(NULL) FROM (SELECT * FROM sql_transaction_errors LIMIT 10) AS temp; 116 count(null) 117 0 118 SELECT COUNT(*) FROM (SELECT * FROM server_connections LIMIT 10) AS temp; 119 count(*) 120 10 121 SELECT COUNT(0) FROM (SELECT * FROM server_connections LIMIT 10) AS temp; 122 count(0) 123 10 124 SELECT COUNT('') FROM (SELECT * FROM server_connections LIMIT 10) AS temp; 125 count() 126 10 127 SELECT COUNT(NULL) FROM (SELECT * FROM server_connections LIMIT 10) AS temp; 128 count(null) 129 0 130 SELECT COUNT(*) FROM (SELECT * FROM process_cpu_percent LIMIT 10) AS temp; 131 count(*) 132 10 133 SELECT COUNT(0) FROM (SELECT * FROM process_cpu_percent LIMIT 10) AS temp; 134 count(0) 135 10 136 SELECT COUNT('') FROM (SELECT * FROM process_cpu_percent LIMIT 10) AS temp; 137 count() 138 10 139 SELECT COUNT(NULL) FROM (SELECT * FROM process_cpu_percent LIMIT 10) AS temp; 140 count(null) 141 0 142 SELECT COUNT(*) FROM (SELECT * FROM process_resident_memory_bytes LIMIT 10) AS temp; 143 count(*) 144 10 145 SELECT COUNT(0) FROM (SELECT * FROM process_resident_memory_bytes LIMIT 10) AS temp; 146 count(0) 147 10 148 SELECT COUNT('') FROM (SELECT * FROM process_resident_memory_bytes LIMIT 10) AS temp; 149 count() 150 10 151 SELECT COUNT(NULL) FROM (SELECT * FROM process_resident_memory_bytes LIMIT 10) AS temp; 152 count(null) 153 0 154 SELECT COUNT(*) FROM (SELECT * FROM sys_cpu_seconds_total LIMIT 10) AS temp; 155 count(*) 156 10 157 SELECT COUNT(0) FROM (SELECT * FROM sys_cpu_seconds_total LIMIT 10) AS temp; 158 count(0) 159 10 160 SELECT COUNT('') FROM (SELECT * FROM sys_cpu_seconds_total LIMIT 10) AS temp; 161 count() 162 10 163 SELECT COUNT(NULL) FROM (SELECT * FROM sys_cpu_seconds_total LIMIT 10) AS temp; 164 count(null) 165 0 166 SELECT COUNT(*) FROM (SELECT * FROM sys_cpu_combined_percent LIMIT 10) AS temp; 167 count(*) 168 10 169 SELECT COUNT(0) FROM (SELECT * FROM sys_cpu_combined_percent LIMIT 10) AS temp; 170 count(0) 171 10 172 SELECT COUNT('') FROM (SELECT * FROM sys_cpu_combined_percent LIMIT 10) AS temp; 173 count() 174 10 175 SELECT COUNT(NULL) FROM (SELECT * FROM sys_cpu_combined_percent LIMIT 10) AS temp; 176 count(null) 177 0 178 SELECT COUNT(*) FROM (SELECT * FROM sys_memory_used LIMIT 10) AS temp; 179 count(*) 180 10 181 SELECT COUNT(0) FROM (SELECT * FROM sys_memory_used LIMIT 10) AS temp; 182 count(0) 183 10 184 SELECT COUNT('') FROM (SELECT * FROM sys_memory_used LIMIT 10) AS temp; 185 count() 186 10 187 SELECT COUNT(NULL) FROM (SELECT * FROM sys_memory_used LIMIT 10) AS temp; 188 count(null) 189 0 190 SELECT COUNT(*) FROM (SELECT * FROM sys_memory_available LIMIT 10) AS temp; 191 count(*) 192 10 193 SELECT COUNT(0) FROM (SELECT * FROM sys_memory_available LIMIT 10) AS temp; 194 count(0) 195 10 196 SELECT COUNT('') FROM (SELECT * FROM sys_memory_available LIMIT 10) AS temp; 197 count() 198 10 199 SELECT COUNT(NULL) FROM (SELECT * FROM sys_memory_available LIMIT 10) AS temp; 200 count(null) 201 0 202 SELECT COUNT(*) FROM (SELECT * FROM sys_disk_read_bytes LIMIT 10) AS temp; 203 count(*) 204 10 205 SELECT COUNT(0) FROM (SELECT * FROM sys_disk_read_bytes LIMIT 10) AS temp; 206 count(0) 207 10 208 SELECT COUNT('') FROM (SELECT * FROM sys_disk_read_bytes LIMIT 10) AS temp; 209 count() 210 10 211 SELECT COUNT(NULL) FROM (SELECT * FROM sys_disk_read_bytes LIMIT 10) AS temp; 212 count(null) 213 0 214 SELECT COUNT(*) FROM (SELECT * FROM sys_disk_write_bytes LIMIT 10) AS temp; 215 count(*) 216 10 217 SELECT COUNT(0) FROM (SELECT * FROM sys_disk_write_bytes LIMIT 10) AS temp; 218 count(0) 219 10 220 SELECT COUNT('') FROM (SELECT * FROM sys_disk_write_bytes LIMIT 10) AS temp; 221 count() 222 10 223 SELECT COUNT(NULL) FROM (SELECT * FROM sys_disk_write_bytes LIMIT 10) AS temp; 224 count(null) 225 0 226 SELECT COUNT(*) FROM (SELECT * FROM sys_net_recv_bytes LIMIT 10) AS temp; 227 count(*) 228 10 229 SELECT COUNT(0) FROM (SELECT * FROM sys_net_recv_bytes LIMIT 10) AS temp; 230 count(0) 231 10 232 SELECT COUNT('') FROM (SELECT * FROM sys_net_recv_bytes LIMIT 10) AS temp; 233 count() 234 10 235 SELECT COUNT(NULL) FROM (SELECT * FROM sys_net_recv_bytes LIMIT 10) AS temp; 236 count(null) 237 0 238 SELECT COUNT(*) FROM (SELECT * FROM sys_net_sent_bytes LIMIT 10) AS temp; 239 count(*) 240 10 241 SELECT COUNT(0) FROM (SELECT * FROM sys_net_sent_bytes LIMIT 10) AS temp; 242 count(0) 243 10 244 SELECT COUNT('') FROM (SELECT * FROM sys_net_sent_bytes LIMIT 10) AS temp; 245 count() 246 10 247 SELECT COUNT(NULL) FROM (SELECT * FROM sys_net_sent_bytes LIMIT 10) AS temp; 248 count(null) 249 0 250 USE mysql; 251 SELECT COUNT(*) FROM (SELECT * FROM user LIMIT 10) AS temp; 252 count(*) 253 0 254 SELECT COUNT(0) FROM (SELECT * FROM user LIMIT 10) AS temp; 255 count(0) 256 0 257 SELECT COUNT('') FROM (SELECT * FROM user LIMIT 10) AS temp; 258 count() 259 0 260 SELECT COUNT(NULL) FROM (SELECT * FROM user LIMIT 10) AS temp; 261 count(null) 262 0 263 SELECT COUNT(*) FROM (SELECT * FROM db LIMIT 10) AS temp; 264 count(*) 265 0 266 SELECT COUNT(0) FROM (SELECT * FROM db LIMIT 10) AS temp; 267 count(0) 268 0 269 SELECT COUNT('') FROM (SELECT * FROM db LIMIT 10) AS temp; 270 count() 271 0 272 SELECT COUNT(NULL) FROM (SELECT * FROM db LIMIT 10) AS temp; 273 count(null) 274 0 275 SELECT COUNT(*) FROM (SELECT * FROM procs_priv LIMIT 10) AS temp; 276 count(*) 277 0 278 SELECT COUNT(0) FROM (SELECT * FROM procs_priv LIMIT 10) AS temp; 279 count(0) 280 0 281 SELECT COUNT('') FROM (SELECT * FROM procs_priv LIMIT 10) AS temp; 282 count() 283 0 284 SELECT COUNT(NULL) FROM (SELECT * FROM procs_priv LIMIT 10) AS temp; 285 count(null) 286 0 287 SELECT COUNT(*) FROM (SELECT * FROM columns_priv LIMIT 10) AS temp; 288 count(*) 289 0 290 SELECT COUNT(0) FROM (SELECT * FROM columns_priv LIMIT 10) AS temp; 291 count(0) 292 0 293 SELECT COUNT('') FROM (SELECT * FROM columns_priv LIMIT 10) AS temp; 294 count() 295 0 296 SELECT COUNT(NULL) FROM (SELECT * FROM columns_priv LIMIT 10) AS temp; 297 count(null) 298 0 299 SELECT COUNT(*) FROM (SELECT * FROM tables_priv LIMIT 10) AS temp; 300 count(*) 301 0 302 SELECT COUNT(0) FROM (SELECT * FROM tables_priv LIMIT 10) AS temp; 303 count(0) 304 0 305 SELECT COUNT('') FROM (SELECT * FROM tables_priv LIMIT 10) AS temp; 306 count() 307 0 308 SELECT COUNT(NULL) FROM (SELECT * FROM tables_priv LIMIT 10) AS temp; 309 count(null) 310 0 311 USE information_schema; 312 SELECT COUNT(*) FROM (SELECT * FROM key_column_usage LIMIT 10) AS temp; 313 count(*) 314 0 315 SELECT COUNT(0) FROM (SELECT * FROM key_column_usage LIMIT 10) AS temp; 316 count(0) 317 0 318 SELECT COUNT('') FROM (SELECT * FROM key_column_usage LIMIT 10) AS temp; 319 count() 320 0 321 SELECT COUNT(NULL) FROM (SELECT * FROM key_column_usage LIMIT 10) AS temp; 322 count(null) 323 0 324 SELECT COUNT(*) FROM (SELECT * FROM columns LIMIT 10) AS temp; 325 count(*) 326 10 327 SELECT COUNT(0) FROM (SELECT * FROM columns LIMIT 10) AS temp; 328 count(0) 329 10 330 SELECT COUNT('') FROM (SELECT * FROM columns LIMIT 10) AS temp; 331 count() 332 10 333 SELECT COUNT(NULL) FROM (SELECT * FROM columns LIMIT 10) AS temp; 334 count(null) 335 0 336 SELECT COUNT(*) FROM (SELECT * FROM profiling LIMIT 10) AS temp; 337 count(*) 338 0 339 SELECT COUNT(0) FROM (SELECT * FROM profiling LIMIT 10) AS temp; 340 count(0) 341 0 342 SELECT COUNT('') FROM (SELECT * FROM profiling LIMIT 10) AS temp; 343 count() 344 0 345 SELECT COUNT(NULL) FROM (SELECT * FROM profiling LIMIT 10) AS temp; 346 count(null) 347 0 348 SELECT COUNT(*) FROM (SELECT * FROM user_privileges LIMIT 10) AS temp; 349 count(*) 350 0 351 SELECT COUNT(0) FROM (SELECT * FROM user_privileges LIMIT 10) AS temp; 352 count(0) 353 0 354 SELECT COUNT('') FROM (SELECT * FROM user_privileges LIMIT 10) AS temp; 355 count() 356 0 357 SELECT COUNT(NULL) FROM (SELECT * FROM user_privileges LIMIT 10) AS temp; 358 count(null) 359 0 360 SELECT COUNT(*) FROM (SELECT * FROM schemata where schema_name = 'mo_catalog' or schema_name = 'mo_task' LIMIT 10) AS temp; 361 count(*) 362 2 363 SELECT COUNT(0) FROM (SELECT * FROM schemata where schema_name = 'mo_catalog' or schema_name = 'mo_task' LIMIT 10) AS temp; 364 count(0) 365 2 366 SELECT COUNT('') FROM (SELECT * FROM schemata where schema_name = 'mo_catalog' or schema_name = 'mo_task' LIMIT 10) AS temp; 367 count() 368 2 369 SELECT COUNT(NULL) FROM (SELECT * FROM schemata where schema_name = 'mo_catalog' or schema_name = 'mo_task' LIMIT 10) AS temp; 370 count(null) 371 0 372 SELECT COUNT(*) FROM (SELECT * FROM character_sets LIMIT 10) AS temp; 373 count(*) 374 0 375 SELECT COUNT(0) FROM (SELECT * FROM character_sets LIMIT 10) AS temp; 376 count(0) 377 0 378 SELECT COUNT('') FROM (SELECT * FROM character_sets LIMIT 10) AS temp; 379 count() 380 0 381 SELECT COUNT(NULL) FROM (SELECT * FROM character_sets LIMIT 10) AS temp; 382 count(null) 383 0 384 SELECT COUNT(*) FROM (SELECT * FROM triggers LIMIT 10) AS temp; 385 count(*) 386 0 387 SELECT COUNT(0) FROM (SELECT * FROM triggers LIMIT 10) AS temp; 388 count(0) 389 0 390 SELECT COUNT('') FROM (SELECT * FROM triggers LIMIT 10) AS temp; 391 count() 392 0 393 SELECT COUNT(NULL) FROM (SELECT * FROM triggers LIMIT 10) AS temp; 394 count(null) 395 0 396 SELECT COUNT(*) FROM (SELECT * FROM tables LIMIT 10) AS temp; 397 count(*) 398 10 399 SELECT COUNT(0) FROM (SELECT * FROM tables LIMIT 10) AS temp; 400 count(0) 401 10 402 SELECT COUNT('') FROM (SELECT * FROM tables LIMIT 10) AS temp; 403 count() 404 10 405 SELECT COUNT(NULL) FROM (SELECT * FROM tables LIMIT 10) AS temp; 406 count(null) 407 0 408 USE mo_catalog; 409 SHOW CREATE TABLE mo_columns; 410 Table Create Table 411 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) 412 SHOW CREATE TABLE mo_database; 413 Table Create Table 414 mo_database CREATE TABLE `mo_database` (\n`dat_id` BIGINT UNSIGNED DEFAULT NULL,\n`datname` VARCHAR(5000) DEFAULT NULL,\n`dat_catalog_name` VARCHAR(5000) DEFAULT NULL,\n`dat_createsql` VARCHAR(5000) DEFAULT NULL,\n`owner` INT UNSIGNED DEFAULT NULL,\n`creator` INT UNSIGNED DEFAULT NULL,\n`created_time` TIMESTAMP DEFAULT NULL,\n`account_id` INT UNSIGNED DEFAULT NULL,\n`dat_type` VARCHAR(32) DEFAULT NULL,\nPRIMARY KEY (`dat_id`)\n) 415 SHOW CREATE TABLE mo_tables; 416 Table Create Table 417 mo_tables CREATE TABLE `mo_tables` (\n`rel_id` BIGINT UNSIGNED DEFAULT NULL,\n`relname` VARCHAR(5000) DEFAULT NULL,\n`reldatabase` VARCHAR(5000) DEFAULT NULL,\n`reldatabase_id` BIGINT UNSIGNED DEFAULT NULL,\n`relpersistence` VARCHAR(5000) DEFAULT NULL,\n`relkind` VARCHAR(5000) DEFAULT NULL,\n`rel_comment` VARCHAR(5000) DEFAULT NULL,\n`rel_createsql` TEXT DEFAULT NULL,\n`created_time` TIMESTAMP DEFAULT NULL,\n`creator` INT UNSIGNED DEFAULT NULL,\n`owner` INT UNSIGNED DEFAULT NULL,\n`account_id` INT UNSIGNED DEFAULT NULL,\n`partitioned` TINYINT DEFAULT NULL,\n`partition_info` BLOB DEFAULT NULL,\n`viewdef` VARCHAR(5000) DEFAULT NULL,\n`constraint` VARCHAR(5000) DEFAULT NULL,\n`rel_version` INT UNSIGNED DEFAULT NULL,\n`catalog_version` INT UNSIGNED DEFAULT NULL,\nPRIMARY KEY (`rel_id`)\n)