github.com/matrixorigin/matrixone@v1.2.0/test/distributed/cases/dml/show/database_statistics.result (about) 1 show table_number from mo_task; 2 Number of tables in mo_task 3 3 4 show table_number from information_schema; 5 Number of tables in information_schema 6 23 7 show table_number from mysql; 8 Number of tables in mysql 9 6 10 show table_number from mo_catalog; 11 Number of tables in mo_catalog 12 27 13 show table_number from system_metrics; 14 Number of tables in system_metrics 15 22 16 show table_number from system; 17 Number of tables in system 18 6 19 use mo_task; 20 show column_number from sys_async_task; 21 Number of columns in sys_async_task 22 14 23 show column_number from sys_cron_task; 24 Number of columns in sys_cron_task 25 10 26 use information_schema; 27 show column_number from key_column_usage; 28 Number of columns in key_column_usage 29 12 30 show column_number from columns; 31 Number of columns in columns 32 22 33 show column_number from profiling; 34 Number of columns in profiling 35 18 36 show column_number from processlist; 37 Number of columns in processlist 38 19 39 show column_number from schemata; 40 Number of columns in schemata 41 6 42 show column_number from character_sets; 43 Number of columns in character_sets 44 4 45 show column_number from triggers; 46 Number of columns in triggers 47 22 48 show column_number from tables; 49 Number of columns in tables 50 21 51 show column_number from engines; 52 Number of columns in engines 53 6 54 show column_number from routines; 55 Number of columns in routines 56 31 57 show column_number from parameters; 58 Number of columns in parameters 59 16 60 show column_number from keywords; 61 Number of columns in keywords 62 2 63 use mysql; 64 show column_number from user; 65 Number of columns in user 66 51 67 show column_number from db; 68 Number of columns in db 69 22 70 show column_number from procs_priv; 71 Number of columns in procs_priv 72 8 73 show column_number from columns_priv; 74 Number of columns in columns_priv 75 7 76 show column_number from tables_priv; 77 Number of columns in tables_priv 78 8 79 use mo_catalog; 80 show column_number from mo_user; 81 Number of columns in mo_user 82 11 83 show column_number from mo_account; 84 Number of columns in mo_account 85 9 86 show column_number from mo_role; 87 Number of columns in mo_role 88 6 89 show column_number from mo_user_grant; 90 Number of columns in mo_user_grant 91 4 92 show column_number from mo_role_grant; 93 Number of columns in mo_role_grant 94 6 95 show column_number from mo_role_privs; 96 Number of columns in mo_role_privs 97 10 98 show column_number from mo_user_defined_function; 99 Number of columns in mo_user_defined_function 100 17 101 show column_number from mo_tables; 102 Number of columns in mo_tables 103 18 104 show column_number from mo_database; 105 Number of columns in mo_database 106 9 107 show column_number from mo_columns; 108 Number of columns in mo_columns 109 24 110 show column_number from mo_indexes; 111 Number of columns in mo_indexes 112 15 113 show column_number from mo_table_partitions; 114 Number of columns in mo_table_partitions 115 10 116 use system_metrics; 117 show column_number from metric; 118 Number of columns in metric 119 7 120 show column_number from sql_statement_total; 121 Number of columns in sql_statement_total 122 6 123 show column_number from sql_statement_errors; 124 Number of columns in sql_statement_errors 125 6 126 show column_number from sql_statement_cu; 127 Number of columns in sql_statement_cu 128 6 129 show column_number from sql_transaction_total; 130 Number of columns in sql_transaction_total 131 5 132 show column_number from sql_transaction_errors; 133 Number of columns in sql_transaction_errors 134 6 135 show column_number from server_connections; 136 Number of columns in server_connections 137 5 138 show column_number from process_cpu_percent; 139 Number of columns in process_cpu_percent 140 5 141 show column_number from process_resident_memory_bytes; 142 Number of columns in process_resident_memory_bytes 143 5 144 show column_number from process_open_fds; 145 Number of columns in process_open_fds 146 5 147 show column_number from sys_cpu_seconds_total; 148 Number of columns in sys_cpu_seconds_total 149 5 150 show column_number from sys_cpu_combined_percent; 151 Number of columns in sys_cpu_combined_percent 152 5 153 show column_number from sys_memory_used; 154 Number of columns in sys_memory_used 155 5 156 show column_number from sys_memory_available; 157 Number of columns in sys_memory_available 158 5 159 show column_number from sys_disk_read_bytes; 160 Number of columns in sys_disk_read_bytes 161 5 162 show column_number from sys_disk_write_bytes; 163 Number of columns in sys_disk_write_bytes 164 5 165 show column_number from sys_net_recv_bytes; 166 Number of columns in sys_net_recv_bytes 167 5 168 show column_number from sys_net_sent_bytes; 169 Number of columns in sys_net_sent_bytes 170 5 171 use system; 172 show column_number from statement_info; 173 Number of columns in statement_info 174 28 175 show column_number from rawlog; 176 Number of columns in rawlog 177 23 178 show column_number from log_info; 179 Number of columns in log_info 180 12 181 show column_number from error_info; 182 Number of columns in error_info 183 9 184 show column_number from span_info; 185 Number of columns in span_info 186 12 187 show column_number from sql_statement_hotspot; 188 Number of columns in sql_statement_hotspot 189 9 190 drop database if exists test_db; 191 create database test_db; 192 show table_number from test_db; 193 Number of tables in test_db 194 0 195 use test_db; 196 drop table if exists t1; 197 create table t1( 198 col1 int, 199 col2 float, 200 col3 varchar, 201 col4 blob, 202 col6 date, 203 col7 bool 204 ); 205 show table_number from test_db; 206 Number of tables in test_db 207 1 208 show table_values from t1; 209 max(col1) min(col1) max(col2) min(col2) max(col3) min(col3) max(col4) min(col4) max(col6) min(col6) max(col7) min(col7) 210 null null null null null null null null null null null null 211 select mo_table_rows("test_db","t1"),mo_table_size("test_db","t1"); 212 mo_table_rows(test_db, t1) mo_table_size(test_db, t1) 213 0 0 214 insert into t1 values(100,10.34,"你好",'aaa','2011-10-10',0); 215 show table_values from t1; 216 max(col1) min(col1) max(col2) min(col2) max(col3) min(col3) max(col4) min(col4) max(col6) min(col6) max(col7) min(col7) 217 100 100 10.34 10.34 你好 你好 aaa aaa 2011-10-10 2011-10-10 false false 218 insert into t1 values(10,1.34,"你",'aa','2011-10-11',1); 219 show table_values from t1; 220 max(col1) min(col1) max(col2) min(col2) max(col3) min(col3) max(col4) min(col4) max(col6) min(col6) max(col7) min(col7) 221 100 10 10.34 1.34 你好 你 aaa aa 2011-10-11 2011-10-10 true false 222 select mo_table_rows("test_db","t1"),mo_table_size("test_db","t1"); 223 mo_table_rows(test_db, t1) mo_table_size(test_db, t1) 224 2 186 225 drop table if exists t11; 226 create table t11( 227 col1 int primary key, 228 col2 float, 229 col3 varchar, 230 col4 blob, 231 col6 date, 232 col7 bool 233 ); 234 show table_number from test_db; 235 Number of tables in test_db 236 2 237 show table_values from t11; 238 max(col1) min(col1) max(col2) min(col2) max(col3) min(col3) max(col4) min(col4) max(col6) min(col6) max(col7) min(col7) 239 null null null null null null null null null null null null 240 select mo_table_rows("test_db","t11"),mo_table_size("test_db","t11"); 241 mo_table_rows(test_db, t11) mo_table_size(test_db, t11) 242 0 0 243 insert into t11 values(100,10.34,"你好",'aaa','2011-10-10',0); 244 show table_values from t11; 245 max(col1) min(col1) max(col2) min(col2) max(col3) min(col3) max(col4) min(col4) max(col6) min(col6) max(col7) min(col7) 246 100 100 10.34 10.34 你好 你好 aaa aaa 2011-10-10 2011-10-10 false false 247 insert into t11 values(10,1.34,"你",'aa','2011-10-11',1); 248 show table_values from t11; 249 max(col1) min(col1) max(col2) min(col2) max(col3) min(col3) max(col4) min(col4) max(col6) min(col6) max(col7) min(col7) 250 100 10 10.34 1.34 你好 你 aaa aa 2011-10-11 2011-10-10 true false 251 select mo_table_rows("test_db","t11"),mo_table_size("test_db","t11"); 252 mo_table_rows(test_db, t11) mo_table_size(test_db, t11) 253 2 170 254 create external table external_table( 255 col1 int, 256 col2 float, 257 col3 varchar, 258 col4 blob, 259 col6 date, 260 col7 bool 261 )infile{"filepath"='$resources/external_table_file/external_table.csv'} fields terminated by ',' enclosed by '\"' lines terminated by '\n'; 262 select * from external_table; 263 col1 col2 col3 col4 col6 col7 264 null null null null 265 100 10.34 你好 aaa 2011-10-10 false 266 10 1.34 你 aa 2011-10-11 true 267 show table_number from test_db; 268 Number of tables in test_db 269 3 270 show table_values from external_table; 271 max(col1) min(col1) max(col2) min(col2) max(col3) min(col3) max(col4) min(col4) max(col6) min(col6) max(col7) min(col7) 272 100 10 10.34 1.34 你好 aaa 2011-10-11 2011-10-10 true false 273 DROP TABLE IF EXISTS partition_table; 274 create table partition_table( 275 empno int unsigned auto_increment, 276 ename varchar(15), 277 job varchar(10), 278 mgr int unsigned , 279 hiredate date, 280 sal decimal(7,2), 281 comm decimal(7,2), 282 deptno int unsigned, 283 primary key(empno, deptno) 284 ) 285 PARTITION BY KEY(deptno) 286 PARTITIONS 4; 287 show table_number from test_db; 288 Number of tables in test_db 289 8 290 show table_values from partition_table; 291 max(empno) min(empno) max(ename) min(ename) max(job) min(job) max(mgr) min(mgr) max(hiredate) min(hiredate) max(sal) min(sal) max(comm) min(comm) max(deptno) min(deptno) 292 null null null null null null null null null null null null null null null null 293 select mo_table_rows("test_db", "partition_table"),mo_table_size("test_db", "partition_table"); 294 mo_table_rows(test_db, partition_table) mo_table_size(test_db, partition_table) 295 0 0 296 INSERT INTO partition_table VALUES (7369,'SMITH','CLERK',7902,'1980-12-17',800,NULL,20); 297 INSERT INTO partition_table VALUES (7499,'ALLEN','SALESMAN',7698,'1981-02-20',1600,300,30); 298 show table_values from partition_table; 299 max(empno) min(empno) max(ename) min(ename) max(job) min(job) max(mgr) min(mgr) max(hiredate) min(hiredate) max(sal) min(sal) max(comm) min(comm) max(deptno) min(deptno) 300 7499 7369 SMITH ALLEN SALESMAN CLERK 7902 7698 1981-02-20 1980-12-17 1600.00 800.00 300.00 300.00 30 20 301 INSERT INTO partition_table VALUES (7521,'WARD','SALESMAN',7698,'1981-02-22',1250,500,30); 302 INSERT INTO partition_table VALUES (7566,'JONES','MANAGER',7839,'1981-04-02',2975,NULL,20); 303 show table_values from partition_table; 304 max(empno) min(empno) max(ename) min(ename) max(job) min(job) max(mgr) min(mgr) max(hiredate) min(hiredate) max(sal) min(sal) max(comm) min(comm) max(deptno) min(deptno) 305 7566 7369 WARD ALLEN SALESMAN CLERK 7902 7698 1981-04-02 1980-12-17 2975.00 800.00 500.00 300.00 30 20 306 select mo_table_rows("test_db", "partition_table"),mo_table_size("test_db", "partition_table"); 307 mo_table_rows(test_db, partition_table) mo_table_size(test_db, partition_table) 308 4 512 309 create table t2( 310 col1 json 311 ); 312 show table_values from t2; 313 max(col1) min(col1) 314 insert into t2 values(); 315 show table_values from t2; 316 max(col1) min(col1) 317 null null 318 insert into t2 values(('{"x": 17}')); 319 show table_values from t2; 320 max(col1) min(col1) 321 null null 322 insert into t2 values (('{"x": [18]}')); 323 show table_values from t2; 324 max(col1) min(col1) 325 null null 326 create table t3( 327 col1 decimal(5,2) 328 ); 329 show table_values from t3; 330 max(col1) min(col1) 331 null null 332 insert into t3 values(); 333 show table_values from t3; 334 max(col1) min(col1) 335 null null 336 insert into t3 values(3.3); 337 show table_values from t3; 338 max(col1) min(col1) 339 3.30 3.30 340 insert into t3 values(3.2); 341 show table_values from t3; 342 max(col1) min(col1) 343 3.30 3.20 344 drop database test_db; 345 drop account if exists test_account; 346 create account test_account admin_name = 'test_user' identified by '111'; 347 show table_number from information_schema; 348 Number of tables in information_schema 349 23 350 show table_number from mysql; 351 Number of tables in mysql 352 6 353 show table_number from mo_catalog; 354 Number of tables in mo_catalog 355 23 356 show table_number from system_metrics; 357 Number of tables in system_metrics 358 9 359 show table_number from system; 360 Number of tables in system 361 1 362 use information_schema; 363 show column_number from key_column_usage; 364 Number of columns in key_column_usage 365 12 366 show column_number from columns; 367 Number of columns in columns 368 22 369 show column_number from profiling; 370 Number of columns in profiling 371 18 372 show column_number from processlist; 373 Number of columns in processlist 374 19 375 show column_number from schemata; 376 Number of columns in schemata 377 6 378 show column_number from character_sets; 379 Number of columns in character_sets 380 4 381 show column_number from triggers; 382 Number of columns in triggers 383 22 384 show column_number from tables; 385 Number of columns in tables 386 21 387 show column_number from engines; 388 Number of columns in engines 389 6 390 show column_number from routines; 391 Number of columns in routines 392 31 393 show column_number from parameters; 394 Number of columns in parameters 395 16 396 show column_number from keywords; 397 Number of columns in keywords 398 2 399 show column_number from partitions; 400 Number of columns in partitions 401 25 402 use mysql; 403 show column_number from user; 404 Number of columns in user 405 51 406 show column_number from db; 407 Number of columns in db 408 22 409 show column_number from procs_priv; 410 Number of columns in procs_priv 411 8 412 show column_number from columns_priv; 413 Number of columns in columns_priv 414 7 415 show column_number from tables_priv; 416 Number of columns in tables_priv 417 8 418 use mo_catalog; 419 show column_number from mo_user; 420 Number of columns in mo_user 421 11 422 show column_number from mo_role; 423 Number of columns in mo_role 424 6 425 show column_number from mo_user_grant; 426 Number of columns in mo_user_grant 427 4 428 show column_number from mo_role_grant; 429 Number of columns in mo_role_grant 430 6 431 show column_number from mo_role_privs; 432 Number of columns in mo_role_privs 433 10 434 show column_number from mo_user_defined_function; 435 Number of columns in mo_user_defined_function 436 17 437 show column_number from mo_tables; 438 Number of columns in mo_tables 439 18 440 show column_number from mo_database; 441 Number of columns in mo_database 442 9 443 show column_number from mo_columns; 444 Number of columns in mo_columns 445 24 446 use system; 447 show column_number from statement_info; 448 Number of columns in statement_info 449 28 450 drop database if exists test_db; 451 create database test_db; 452 show table_number from test_db; 453 Number of tables in test_db 454 0 455 use test_db; 456 drop table if exists t1; 457 create table t1( 458 col1 int, 459 col2 float, 460 col3 varchar, 461 col4 blob, 462 col6 date, 463 col7 bool 464 ); 465 show table_number from test_db; 466 Number of tables in test_db 467 1 468 show table_values from t1; 469 max(col1) min(col1) max(col2) min(col2) max(col3) min(col3) max(col4) min(col4) max(col6) min(col6) max(col7) min(col7) 470 null null null null null null null null null null null null 471 select mo_table_rows("test_db","t1"),mo_table_size("test_db","t1"); 472 mo_table_rows(test_db, t1) mo_table_size(test_db, t1) 473 0 0 474 insert into t1 values(100,10.34,"你好",'aaa','2011-10-10',0); 475 show table_values from t1; 476 max(col1) min(col1) max(col2) min(col2) max(col3) min(col3) max(col4) min(col4) max(col6) min(col6) max(col7) min(col7) 477 100 100 10.34 10.34 你好 你好 aaa aaa 2011-10-10 2011-10-10 false false 478 insert into t1 values(10,1.34,"你",'aa','2011-10-11',1); 479 show table_values from t1; 480 max(col1) min(col1) max(col2) min(col2) max(col3) min(col3) max(col4) min(col4) max(col6) min(col6) max(col7) min(col7) 481 100 10 10.34 1.34 你好 你 aaa aa 2011-10-11 2011-10-10 true false 482 select mo_table_rows("test_db","t1"),mo_table_size("test_db","t1"); 483 mo_table_rows(test_db, t1) mo_table_size(test_db, t1) 484 2 186 485 drop table if exists t11; 486 create table t11( 487 col1 int primary key, 488 col2 float, 489 col3 varchar, 490 col4 blob, 491 col6 date, 492 col7 bool 493 ); 494 show table_number from test_db; 495 Number of tables in test_db 496 2 497 show table_values from t11; 498 max(col1) min(col1) max(col2) min(col2) max(col3) min(col3) max(col4) min(col4) max(col6) min(col6) max(col7) min(col7) 499 null null null null null null null null null null null null 500 select mo_table_rows("test_db","t11"),mo_table_size("test_db","t11"); 501 mo_table_rows(test_db, t11) mo_table_size(test_db, t11) 502 0 0 503 insert into t11 values(100,10.34,"你好",'aaa','2011-10-10',0); 504 show table_values from t11; 505 max(col1) min(col1) max(col2) min(col2) max(col3) min(col3) max(col4) min(col4) max(col6) min(col6) max(col7) min(col7) 506 100 100 10.34 10.34 你好 你好 aaa aaa 2011-10-10 2011-10-10 false false 507 insert into t11 values(10,1.34,"你",'aa','2011-10-11',1); 508 show table_values from t11; 509 max(col1) min(col1) max(col2) min(col2) max(col3) min(col3) max(col4) min(col4) max(col6) min(col6) max(col7) min(col7) 510 100 10 10.34 1.34 你好 你 aaa aa 2011-10-11 2011-10-10 true false 511 select mo_table_rows("test_db","t11"),mo_table_size("test_db","t11"); 512 mo_table_rows(test_db, t11) mo_table_size(test_db, t11) 513 2 170 514 create external table external_table( 515 col1 int, 516 col2 float, 517 col3 varchar, 518 col4 blob, 519 col6 date, 520 col7 bool 521 )infile{"filepath"='$resources/external_table_file/external_table.csv'} fields terminated by ',' enclosed by '\"' lines terminated by '\n'; 522 select * from external_table; 523 col1 col2 col3 col4 col6 col7 524 null null null null 525 100 10.34 你好 aaa 2011-10-10 false 526 10 1.34 你 aa 2011-10-11 true 527 show table_number from test_db; 528 Number of tables in test_db 529 3 530 show table_values from external_table; 531 max(col1) min(col1) max(col2) min(col2) max(col3) min(col3) max(col4) min(col4) max(col6) min(col6) max(col7) min(col7) 532 100 10 10.34 1.34 你好 aaa 2011-10-11 2011-10-10 true false 533 create table t2( 534 col1 json 535 ); 536 show table_values from t2; 537 max(col1) min(col1) 538 insert into t2 values(); 539 show table_values from t2; 540 max(col1) min(col1) 541 null null 542 insert into t2 values(('{"x": 17}')); 543 show table_values from t2; 544 max(col1) min(col1) 545 null null 546 insert into t2 values (('{"x": [18]}')); 547 show table_values from t2; 548 max(col1) min(col1) 549 null null 550 create table t3( 551 col1 decimal 552 ); 553 show table_values from t3; 554 max(col1) min(col1) 555 null null 556 insert into t3 values(); 557 show table_values from t3; 558 max(col1) min(col1) 559 null null 560 insert into t3 values(3.3); 561 show table_values from t3; 562 max(col1) min(col1) 563 3 3 564 insert into t3 values(3.2); 565 show table_values from t3; 566 max(col1) min(col1) 567 3 3 568 drop database test_db; 569 drop account if exists test_account;