github.com/matrixorigin/matrixone@v1.2.0/test/distributed/cases/database/system_variables.result (about) 1 set interactive_timeout = default; 2 set net_write_timeout = default; 3 set wait_timeout = default; 4 set sql_select_limit = default; 5 set max_allowed_packet = default; 6 set wait_timeout = default; 7 set tx_isolation = default; 8 set tx_isolation = default; 9 show variables like 'auto%'; 10 Variable_name Value 11 auto_generate_certs on 12 auto_increment_increment 1 13 auto_increment_offset 1 14 autocommit on 15 automatic_sp_privileges on 16 show variables like 'auto_increment_increment'; 17 Variable_name Value 18 auto_increment_increment 1 19 set auto_increment_increment = 2; 20 show variables like 'auto_increment_increment'; 21 Variable_name Value 22 auto_increment_increment 2 23 set auto_increment_increment = 1+1; 24 show variables like 'auto_increment_increment'; 25 Variable_name Value 26 auto_increment_increment 2 27 set auto_increment_increment = 2*3; 28 show variables like 'auto_increment_increment'; 29 Variable_name Value 30 auto_increment_increment 6 31 show variables like 'init%'; 32 Variable_name Value 33 init_connect 34 init_file 35 show variables like 'init_connect'; 36 Variable_name Value 37 init_connect 38 show variables like 'interactive%'; 39 Variable_name Value 40 interactive_timeout 28800 41 show variables like 'interactive_timeout'; 42 Variable_name Value 43 interactive_timeout 28800 44 set interactive_timeout = 36600; 45 show variables like 'interactive_timeout'; 46 Variable_name Value 47 interactive_timeout 36600 48 set interactive_timeout = 30000+100; 49 show variables like 'interactive_timeout'; 50 Variable_name Value 51 interactive_timeout 30100 52 set global interactive_timeout = 30000+100; 53 show variables like 'interactive_timeout'; 54 Variable_name Value 55 interactive_timeout 30100 56 show variables like 'lower%'; 57 Variable_name Value 58 lower_case_file_system off 59 lower_case_table_names 1 60 show variables like 'lower_case_table_names'; 61 Variable_name Value 62 lower_case_table_names 1 63 show variables like 'net_write_timeout'; 64 Variable_name Value 65 net_write_timeout 60 66 set net_write_timeout = 70; 67 show variables like 'net_write_timeout'; 68 Variable_name Value 69 net_write_timeout 70 70 set net_write_timeout = 20*20; 71 show variables like 'net_write_timeout'; 72 Variable_name Value 73 net_write_timeout 400 74 set net_write_timeout = 60; 75 show variables like 'net_write_timeout'; 76 Variable_name Value 77 net_write_timeout 60 78 show variables where variable_name like 'system%' and variable_name != 'system_time_zone'; 79 Variable_name Value 80 select @@system_time_zone != ''; 81 @@system_time_zone != 82 true 83 show variables like 'trans%'; 84 Variable_name Value 85 transaction_alloc_block_size 8192 86 transaction_isolation REPEATABLE-READ 87 transaction_operator_open_log off 88 transaction_prealloc_size 4096 89 transaction_read_only 0 90 transferred off 91 show variables like 'transaction_isolation'; 92 Variable_name Value 93 transaction_isolation REPEATABLE-READ 94 show variables like 'wait%'; 95 Variable_name Value 96 wait_timeout 28800 97 show variables like 'wait_timeout'; 98 Variable_name Value 99 wait_timeout 28800 100 set wait_timeout = 33600; 101 show variables like 'wait_timeout'; 102 Variable_name Value 103 wait_timeout 33600 104 set wait_timeout = 10; 105 show variables like 'wait_timeout'; 106 Variable_name Value 107 wait_timeout 10 108 drop table if exists t; 109 create table t( 110 a int, 111 b int, 112 c int, 113 primary key(a) 114 ); 115 show indexes from t; 116 Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_comment Index_params Visible Expression 117 t 0 PRIMARY 1 a A 0 NULL NULL YES NULL 118 create account acc_idx ADMIN_NAME 'root' IDENTIFIED BY '123456'; 119 create database db1; 120 use db1; 121 drop table if exists t; 122 create table t( 123 a int, 124 b int, 125 c int, 126 primary key(a) 127 ); 128 show indexes from t; 129 Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_comment Index_params Visible Expression 130 t 0 PRIMARY 1 a A 0 NULL NULL YES NULL 131 drop database db1; 132 drop account acc_idx; 133 use information_schema; 134 show tables; 135 Tables_in_information_schema 136 character_sets 137 collations 138 column_privileges 139 columns 140 engines 141 events 142 key_column_usage 143 keywords 144 parameters 145 partitions 146 processlist 147 profiling 148 referential_constraints 149 routines 150 schema_privileges 151 schemata 152 statistics 153 table_constraints 154 table_privileges 155 tables 156 triggers 157 user_privileges 158 views 159 desc key_column_usage; 160 Field Type Null Key Default Extra Comment 161 constraint_catalog VARCHAR(64) YES null 162 constraint_schema VARCHAR(64) YES null 163 constraint_name VARCHAR(64) YES null 164 table_catalog VARCHAR(64) YES null 165 table_schema VARCHAR(64) YES null 166 table_name VARCHAR(64) YES null 167 column_name VARCHAR(64) YES null 168 ordinal_position INT UNSIGNED(32) YES null 169 position_in_unique_constraint INT UNSIGNED(32) YES null 170 referenced_table_schema VARCHAR(64) YES null 171 referenced_table_name VARCHAR(64) YES null 172 referenced_column_name VARCHAR(64) YES null 173 select table_name, column_name from key_column_usage limit 2; 174 table_name column_name 175 desc columns; 176 Field Type Null Key Default Extra Comment 177 table_catalog VARCHAR(3) NO null 178 table_schema VARCHAR(256) YES null 179 table_name VARCHAR(256) YES null 180 column_name VARCHAR(256) YES null 181 ordinal_position INT(0) YES null 182 column_default VARCHAR(65535) YES null 183 is_nullable VARCHAR(3) YES null 184 data_type VARCHAR(65535) YES null 185 character_maximum_length BIGINT(0) YES null 186 character_octet_length BIGINT(0) YES null 187 numeric_precision BIGINT(0) YES null 188 numeric_scale BIGINT(0) YES null 189 datetime_precision BIGINT(0) YES null 190 character_set_name VARCHAR(4) YES null 191 collation_name VARCHAR(8) YES null 192 column_type VARCHAR(65535) YES null 193 column_key VARCHAR(3) YES null 194 extra VARCHAR(14) YES null 195 privileges VARCHAR(31) NO null 196 column_comment VARCHAR(2048) YES null 197 generation_expression VARCHAR(500) NO null 198 srs_id BIGINT(0) YES null 199 select table_name, column_name from columns where table_schema = 'mo_catalog' and column_name != '__mo_index_idx_col' and column_name != '__mo_index_pri_col' order by table_name, column_name limit 5; 200 table_name column_name 201 mo_account account_id 202 mo_account account_name 203 mo_account admin_name 204 mo_account comments 205 mo_account create_version 206 desc views; 207 Field Type Null Key Default Extra Comment 208 table_catalog VARCHAR(3) NO null 209 table_schema VARCHAR(5000) YES null 210 table_name VARCHAR(5000) YES null 211 view_definition TEXT(0) YES null 212 check_option VARCHAR(4) NO null 213 is_updatable VARCHAR(3) NO null 214 definer VARCHAR(65535) YES null 215 security_type VARCHAR(7) NO null 216 character_set_client VARCHAR(7) NO null 217 collation_connection VARCHAR(18) NO null 218 select table_schema, table_name, definer from views where table_schema = 'system' order by table_name; 219 table_schema table_name definer 220 system error_info root@localhost 221 system log_info root@localhost 222 system span_info root@localhost 223 system sql_statement_hotspot root@localhost 224 desc profiling; 225 Field Type Null Key Default Extra Comment 226 query_id INT(32) NO '0' 227 seq INT(32) NO '0' 228 state VARCHAR(30) NO '' 229 duration DECIMAL64(9) NO '0.000000' 230 cpu_user DECIMAL64(9) YES null 231 cpu_system DECIMAL64(9) YES null 232 context_voluntary INT(32) YES null 233 context_involuntary INT(32) YES null 234 block_ops_in INT(32) YES null 235 block_ops_out INT(32) YES null 236 messages_sent INT(32) YES null 237 messages_received INT(32) YES null 238 page_faults_major INT(32) YES null 239 page_faults_minor INT(32) YES null 240 swaps INT(32) YES null 241 source_function VARCHAR(30) YES null 242 source_file VARCHAR(20) YES null 243 source_line INT(32) YES null 244 select seq, state from profiling; 245 seq state 246 desc user_privileges; 247 Field Type Null Key Default Extra Comment 248 grantee VARCHAR(292) NO '' 249 table_catalog VARCHAR(512) NO '' 250 privilege_type VARCHAR(64) NO '' 251 is_grantable VARCHAR(3) NO '' 252 select grantee, table_catalog from user_privileges limit 2; 253 grantee table_catalog 254 desc schemata; 255 Field Type Null Key Default Extra Comment 256 catalog_name VARCHAR(5000) YES null 257 schema_name VARCHAR(5000) YES null 258 default_character_set_name VARCHAR(7) NO null 259 default_collation_name VARCHAR(18) NO null 260 sql_path CHAR(0) YES null 261 default_encryption VARCHAR(3) NO null 262 select catalog_name, schema_name from schemata where schema_name = 'mo_catalog' or schema_name = 'mo_task' order by catalog_name, schema_name; 263 catalog_name schema_name 264 def mo_task 265 mo_catalog mo_catalog 266 desc character_sets; 267 Field Type Null Key Default Extra Comment 268 character_set_name VARCHAR(64) YES null 269 default_collate_name VARCHAR(64) YES null 270 description VARCHAR(2048) YES null 271 maxlen INT UNSIGNED(32) YES null 272 select character_set_name, description, maxlen from character_sets limit 5; 273 character_set_name description maxlen 274 desc triggers; 275 Field Type Null Key Default Extra Comment 276 trigger_catalog VARCHAR(64) YES null 277 trigger_schema VARCHAR(64) YES null 278 trigger_name VARCHAR(64) YES null 279 event_manipulation VARCHAR(10) YES null 280 event_object_catalog VARCHAR(64) YES null 281 event_object_schema VARCHAR(64) YES null 282 event_object_table VARCHAR(64) YES null 283 action_order INT UNSIGNED(32) YES null 284 action_condition BINARY(0) YES null 285 action_statement TEXT(0) YES null 286 action_orientation VARCHAR(3) YES null 287 action_timing VARCHAR(10) YES null 288 action_reference_old_table BINARY(0) YES null 289 action_reference_new_table BINARY(0) YES null 290 action_reference_old_row VARCHAR(3) YES null 291 action_reference_new_row VARCHAR(3) YES null 292 created TIMESTAMP(2) YES null 293 sql_mode VARCHAR(10) YES null 294 definer VARCHAR(288) YES null 295 character_set_client VARCHAR(64) YES null 296 collation_connection VARCHAR(64) YES null 297 database_collation VARCHAR(64) YES null 298 select trigger_name, action_order from triggers limit 3; 299 trigger_name action_order 300 use mysql; 301 desc user; 302 Field Type Null Key Default Extra Comment 303 host CHAR(255) NO PRI '' 304 user CHAR(32) NO PRI '' 305 select_priv VARCHAR(10) NO 'N' 306 insert_priv VARCHAR(10) NO 'N' 307 update_priv VARCHAR(10) NO 'N' 308 delete_priv VARCHAR(10) NO 'N' 309 create_priv VARCHAR(10) NO 'N' 310 drop_priv VARCHAR(10) NO 'N' 311 reload_priv VARCHAR(10) NO 'N' 312 shutdown_priv VARCHAR(10) NO 'N' 313 process_priv VARCHAR(10) NO 'N' 314 file_priv VARCHAR(10) NO 'N' 315 grant_priv VARCHAR(10) NO 'N' 316 references_priv VARCHAR(10) NO 'N' 317 index_priv VARCHAR(10) NO 'N' 318 alter_priv VARCHAR(10) NO 'N' 319 show_db_priv VARCHAR(10) NO 'N' 320 super_priv VARCHAR(10) NO 'N' 321 create_tmp_table_priv VARCHAR(10) NO 'N' 322 lock_tables_priv VARCHAR(10) NO 'N' 323 execute_priv VARCHAR(10) NO 'N' 324 repl_slave_priv VARCHAR(10) NO 'N' 325 repl_client_priv VARCHAR(10) NO 'N' 326 create_view_priv VARCHAR(10) NO 'N' 327 show_view_priv VARCHAR(10) NO 'N' 328 create_routine_priv VARCHAR(10) NO 'N' 329 alter_routine_priv VARCHAR(10) NO 'N' 330 create_user_priv VARCHAR(10) NO 'N' 331 event_priv VARCHAR(10) NO 'N' 332 trigger_priv VARCHAR(10) NO 'N' 333 create_tablespace_priv VARCHAR(10) NO 'N' 334 ssl_type VARCHAR(10) NO '' 335 ssl_cipher BLOB(0) NO null 336 x509_issuer BLOB(0) NO null 337 x509_subject BLOB(0) NO null 338 max_questions INT UNSIGNED(32) NO '0' 339 max_updates INT UNSIGNED(32) NO '0' 340 max_connections INT UNSIGNED(32) NO '0' 341 max_user_connections INT UNSIGNED(32) NO '0' 342 plugin CHAR(64) NO 'caching_sha2_password' 343 authentication_string TEXT(0) YES null 344 password_expired VARCHAR(10) NO 'N' 345 password_last_changed TIMESTAMP(0) YES null 346 password_lifetime SMALLINT UNSIGNED(16) YES null 347 account_locked VARCHAR(10) NO 'N' 348 create_role_priv VARCHAR(10) NO 'N' 349 drop_role_priv VARCHAR(10) NO 'N' 350 password_reuse_history SMALLINT UNSIGNED(16) YES null 351 password_reuse_time SMALLINT UNSIGNED(16) YES null 352 password_require_current VARCHAR(10) YES null 353 user_attributes JSON(0) YES null 354 select host, user from user limit 2; 355 host user 356 desc db; 357 Field Type Null Key Default Extra Comment 358 host CHAR(255) NO PRI '' 359 db CHAR(64) NO PRI '' 360 user CHAR(32) NO PRI '' 361 select_priv VARCHAR(10) NO 'N' 362 insert_priv VARCHAR(10) NO 'N' 363 update_priv VARCHAR(10) NO 'N' 364 delete_priv VARCHAR(10) NO 'N' 365 create_priv VARCHAR(10) NO 'N' 366 drop_priv VARCHAR(10) NO 'N' 367 grant_priv VARCHAR(10) NO 'N' 368 references_priv VARCHAR(10) NO 'N' 369 index_priv VARCHAR(10) NO 'N' 370 alter_priv VARCHAR(10) NO 'N' 371 create_tmp_table_priv VARCHAR(10) NO 'N' 372 lock_tables_priv VARCHAR(10) NO 'N' 373 create_view_priv VARCHAR(10) NO 'N' 374 show_view_priv VARCHAR(10) NO 'N' 375 create_routine_priv VARCHAR(10) NO 'N' 376 alter_routine_priv VARCHAR(10) NO 'N' 377 execute_priv VARCHAR(10) NO 'N' 378 event_priv VARCHAR(10) NO 'N' 379 trigger_priv VARCHAR(10) NO 'N' 380 select db, user from db limit 5; 381 db user 382 desc procs_priv; 383 Field Type Null Key Default Extra Comment 384 host CHAR(255) NO PRI '' 385 db CHAR(64) NO PRI '' 386 user CHAR(32) NO PRI '' 387 routine_name CHAR(64) NO PRI '' 388 routine_type VARCHAR(10) NO PRI null 389 grantor VARCHAR(288) NO MUL '' 390 proc_priv VARCHAR(10) NO '' 391 timestamp TIMESTAMP(0) NO current_timestamp() 392 select routine_name, routine_type from procs_priv limit 5; 393 routine_name routine_type 394 desc columns_priv; 395 Field Type Null Key Default Extra Comment 396 host CHAR(255) NO PRI '' 397 db CHAR(64) NO PRI '' 398 user CHAR(32) NO PRI '' 399 table_name CHAR(64) NO PRI '' 400 column_name CHAR(64) NO PRI '' 401 timestamp TIMESTAMP(0) NO current_timestamp() 402 column_priv VARCHAR(10) NO '' 403 select table_name, column_name from columns_priv limit 5; 404 table_name column_name 405 desc tables_priv; 406 Field Type Null Key Default Extra Comment 407 host CHAR(255) NO PRI '' 408 db CHAR(64) NO PRI '' 409 user CHAR(32) NO PRI '' 410 table_name CHAR(64) NO PRI '' 411 grantor VARCHAR(288) NO MUL '' 412 timestamp TIMESTAMP(0) NO current_timestamp() 413 table_priv VARCHAR(10) NO '' 414 column_priv VARCHAR(10) NO '' 415 select host, table_name from tables_priv limit 5; 416 host table_name 417 show variables like 'sql_select_limit'; 418 Variable_name Value 419 sql_select_limit 18446744073709551615 420 set sql_select_limit = 100000; 421 show variables like 'sql_select_limit'; 422 Variable_name Value 423 sql_select_limit 100000 424 set sql_select_limit = 1; 425 show variables like 'sql_select_limit'; 426 Variable_name Value 427 sql_select_limit 1 428 SET SQL_SELECT_LIMIT = Default; 429 show variables like 'sql_select_limit'; 430 Variable_name Value 431 sql_select_limit 18446744073709551615 432 show variables like 'max_allowed_packet'; 433 Variable_name Value 434 max_allowed_packet 67108864 435 set max_allowed_packet = 10000; 436 show variables like 'max_allowed_packet'; 437 Variable_name Value 438 max_allowed_packet 10000 439 set max_allowed_packet = default; 440 show variables like 'max_allowed_packet'; 441 Variable_name Value 442 max_allowed_packet 67108864 443 show variables like 'wait_timeout'; 444 Variable_name Value 445 wait_timeout 10 446 set wait_timeout = 10000; 447 show variables like 'wait_timeout'; 448 Variable_name Value 449 wait_timeout 10000 450 set wait_timeout = default; 451 show variables like 'wait_timeout'; 452 Variable_name Value 453 wait_timeout 28800 454 show variables like 'character_set_results'; 455 Variable_name Value 456 character_set_results utf8 457 set character_set_server = default; 458 show variables like 'character_set_results'; 459 Variable_name Value 460 character_set_results utf8 461 show variables like 'character_set_server'; 462 Variable_name Value 463 character_set_server utf8mb4 464 set character_set_server = default; 465 show variables like 'character_set_server'; 466 Variable_name Value 467 character_set_server utf8mb4 468 show variables like 'transaction_isolation'; 469 Variable_name Value 470 transaction_isolation REPEATABLE-READ 471 set transaction_isolation = default; 472 show variables like 'transaction_isolation'; 473 Variable_name Value 474 transaction_isolation REPEATABLE-READ 475 show variables like 'tx_isolation'; 476 Variable_name Value 477 tx_isolation REPEATABLE-READ 478 set tx_isolation = default; 479 show variables like 'tx_isolation'; 480 Variable_name Value 481 tx_isolation REPEATABLE-READ 482 select @@sql_mode; 483 @@sql_mode 484 ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION,NO_ZERO_DATE,NO_ZERO_IN_DATE,ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES 485 set @@sql_mode =''; 486 select @@sql_mode; 487 @@sql_mode 488 489 set @@sql_mode = 'ONLY_FULL_GROUP_BY'; 490 select @@sql_mode; 491 @@sql_mode 492 ONLY_FULL_GROUP_BY 493 set @@sql_mode = "ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES"; 494 select @@sql_mode; 495 @@sql_mode 496 ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES 497 set @@sql_mode = default; 498 set global long_query_time = 1.1; 499 show global variables like 'long_query_time'; 500 Variable_name Value 501 long_query_time 1.1 502 set global long_query_time = default; 503 show global variables like 'long_query_time'; 504 Variable_name Value 505 long_query_time 10 506 create account acc_idx ADMIN_NAME 'root' IDENTIFIED BY '123456'; 507 create database test_for_navicat; 508 create database test_for_navicat; 509 SELECT SCHEMA_NAME, DEFAULT_CHARACTER_SET_NAME, DEFAULT_COLLATION_NAME FROM information_schema.SCHEMATA where SCHEMA_NAME = 'test_for_navicat'; 510 schema_name default_character_set_name default_collation_name 511 test_for_navicat utf8mb4 utf8mb4_0900_ai_ci 512 drop database test_for_navicat; 513 drop account acc_idx;