diff options
| author | antony@ltantony.rdg.cyberkinetica.homeunix.net <> | 2003-12-17 22:52:03 +0000 |
|---|---|---|
| committer | antony@ltantony.rdg.cyberkinetica.homeunix.net <> | 2003-12-17 22:52:03 +0000 |
| commit | 2b53eef5f00364464652847065a81a32571cc73f (patch) | |
| tree | c639b3a159120373264b2f97623f8759e2226d61 /mysql-test/t/variables.test | |
| parent | abaaa0f37b6e9b24e79a9da86be83dd3480f3d5e (diff) | |
| download | mariadb-git-2b53eef5f00364464652847065a81a32571cc73f.tar.gz | |
WorkLog #1323 (part 2)
New Statement: SHOW [STORAGE] ENGINES
New System Variable: storage_engine
New mysqld Argument: --default-storage-engine=
Diffstat (limited to 'mysql-test/t/variables.test')
| -rw-r--r-- | mysql-test/t/variables.test | 16 |
1 files changed, 8 insertions, 8 deletions
diff --git a/mysql-test/t/variables.test b/mysql-test/t/variables.test index b5c402fe962..e2537532eb4 100644 --- a/mysql-test/t/variables.test +++ b/mysql-test/t/variables.test @@ -70,9 +70,9 @@ show variables like 'concurrent_insert'; set global concurrent_insert=DEFAULT; show variables like 'concurrent_insert'; -set table_type=MYISAM, table_type="HEAP", global table_type="INNODB"; -show local variables like 'table_type'; -show global variables like 'table_type'; +set storage_engine=MYISAM, storage_engine="HEAP", global storage_engine="INNODB"; +show local variables like 'storage_engine'; +show global variables like 'storage_engine'; set GLOBAL query_cache_size=100000; set GLOBAL myisam_max_sort_file_size=2000000; @@ -125,14 +125,14 @@ set unknown_variable=1; --error 1232 set max_join_size="hello"; --error 1285 -set table_type=UNKNOWN_TABLE_TYPE; +set storage_engine=UNKNOWN_TABLE_TYPE; --error 1231 -set table_type=INNODB, big_tables=2; -show local variables like 'table_type'; +set storage_engine=INNODB, big_tables=2; +show local variables like 'storage_engine'; --error 1229 set SESSION query_cache_size=10000; --error 1230 -set GLOBAL table_type=DEFAULT; +set GLOBAL storage_engine=DEFAULT; --error 1115 set character_set_client=UNKNOWN_CHARACTER_SET; --error 1272 @@ -235,7 +235,7 @@ set sql_select_limit=1; set global sql_slave_skip_counter=100; set sql_warnings=1; set global table_cache=100; -set table_type=myisam; +set storage_engine=myisam; set global thread_cache_size=100; set timestamp=1, timestamp=default; set tmp_table_size=100; |