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