Tetsuro IKEDA
null+****@clear*****
Thu Oct 4 10:20:15 JST 2012
Tetsuro IKEDA 2010-03-24 15:31:50 +0900 (Wed, 24 Mar 2010) New Revision: 01f4bca071aaf318fc6c25b7cce9cd1ff2b81f14 https://github.com/mroonga/mroonga/commit/01f4bca071aaf318fc6c25b7cce9cd1ff2b81f14 Log: added test case for "SHOW TABLE STATUS". Added files: test/sql/r/show_table_status.result test/sql/t/show_table_status.test Added: test/sql/r/show_table_status.result (+19 -0) 100644 =================================================================== --- /dev/null +++ test/sql/r/show_table_status.result 2010-03-24 15:31:50 +0900 (cc17111) @@ -0,0 +1,19 @@ +install plugin mroonga soname 'libmroonga.so'; +set storage_engine=mroonga; +drop database if exists db1; +create database db1; +use db1; +create table t1 (c1 int); +show table status; +Name Engine Version Row_format Rows Avg_row_length Data_length Max_data_length Index_length Data_free Auto_increment Create_time Update_time Check_time Collation Checksum Create_options Comment +t1 mroonga 10 Fixed 0 0 0 0 0 0 NULL NULL NULL NULL latin1_swedish_ci NULL +create table t2 (c1 int, c2 int); +show table status; +Name Engine Version Row_format Rows Avg_row_length Data_length Max_data_length Index_length Data_free Auto_increment Create_time Update_time Check_time Collation Checksum Create_options Comment +t1 mroonga 10 Fixed 0 0 0 0 0 0 NULL NULL NULL NULL latin1_swedish_ci NULL +t2 mroonga 10 Fixed 0 0 0 0 0 0 NULL NULL NULL NULL latin1_swedish_ci NULL +show table status like 't2'; +Name Engine Version Row_format Rows Avg_row_length Data_length Max_data_length Index_length Data_free Auto_increment Create_time Update_time Check_time Collation Checksum Create_options Comment +t2 mroonga 10 Fixed 0 0 0 0 0 0 NULL NULL NULL NULL latin1_swedish_ci NULL +drop database db1; +uninstall plugin mroonga; Added: test/sql/t/show_table_status.test (+20 -0) 100644 =================================================================== --- /dev/null +++ test/sql/t/show_table_status.test 2010-03-24 15:31:50 +0900 (3ef1a02) @@ -0,0 +1,20 @@ +--disable_warnings +install plugin mroonga soname 'libmroonga.so'; +set storage_engine=mroonga; +drop database if exists db1; +create database db1; +use db1; +--enable_warnings + +create table t1 (c1 int); +show table status; + +create table t2 (c1 int, c2 int); +show table status; + +show table status like 't2'; + +--disable_warnings +drop database db1; +uninstall plugin mroonga; +--enable_warnings -------------- next part -------------- HTML����������������������������...Download