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