Tetsuro IKEDA
null+****@clear*****
Thu Oct 4 10:20:16 JST 2012
Tetsuro IKEDA 2010-03-24 15:29:40 +0900 (Wed, 24 Mar 2010) New Revision: 7dd8a838d43d1dfbed08be4110f6d5f82a0ac276 https://github.com/mroonga/mroonga/commit/7dd8a838d43d1dfbed08be4110f6d5f82a0ac276 Log: add test case for "SHOW CREATE TABLE". Added files: test/sql/r/show_create_table.result test/sql/t/show_create_table.test Added: test/sql/r/show_create_table.result (+31 -0) 100644 =================================================================== --- /dev/null +++ test/sql/r/show_create_table.result 2010-03-24 15:29:40 +0900 (bfee3ef) @@ -0,0 +1,31 @@ +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 create table t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` int(11) DEFAULT NULL +) ENGINE=mroonga DEFAULT CHARSET=latin1 +drop table t1; +create table t1 (c1 int, c2 int); +show create table t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` int(11) DEFAULT NULL, + `c2` int(11) DEFAULT NULL +) ENGINE=mroonga DEFAULT CHARSET=latin1 +drop table t1; +create table t1 (c1 int primary key, c2 varchar(100)); +show create table t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` int(11) NOT NULL, + `c2` varchar(100) DEFAULT NULL, + PRIMARY KEY (`c1`) +) ENGINE=mroonga DEFAULT CHARSET=latin1 +drop table t1; +drop database db1; +uninstall plugin mroonga; Added: test/sql/t/show_create_table.test (+24 -0) 100644 =================================================================== --- /dev/null +++ test/sql/t/show_create_table.test 2010-03-24 15:29:40 +0900 (4122c06) @@ -0,0 +1,24 @@ +--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 create table t1; +drop table t1; + +create table t1 (c1 int, c2 int); +show create table t1; +drop table t1; + +create table t1 (c1 int primary key, c2 varchar(100)); +show create table t1; +drop table t1; + +--disable_warnings +drop database db1; +uninstall plugin mroonga; +--enable_warnings -------------- next part -------------- HTML����������������������������...Download