null+****@clear*****
null+****@clear*****
2011年 6月 9日 (木) 18:05:51 JST
Kouhei Sutou 2011-06-09 09:05:51 +0000 (Thu, 09 Jun 2011)
New Revision: 134254b939f00580375c6c5249444c03032c9af3
Log:
[wrapper][test] engine = groonga -> COMMENT 'engine = "innodb"'.
Modified files:
test/sql/r/create_table_wrapper.result
test/sql/t/create_table_wrapper.test
Modified: test/sql/r/create_table_wrapper.result (+7 -7)
===================================================================
--- test/sql/r/create_table_wrapper.result 2011-06-09 07:48:05 +0000 (4ec8793)
+++ test/sql/r/create_table_wrapper.result 2011-06-09 09:05:51 +0000 (7118c3e)
@@ -146,27 +146,27 @@ desc t1;
Field Type Null Key Default Extra
c1 set('A','B','AB','O') YES NULL
drop table t1;
-create table t1 (c1 int, `_id` int) engine = groonga;
+create table t1 (c1 int, `_id` int) COMMENT = 'engine "innodb"';
desc t1;
Field Type Null Key Default Extra
c1 int(11) YES NULL
_id int(11) YES NULL
drop table t1;
-create table t1 (c1 int, `_score` float) engine = groonga;
+create table t1 (c1 int, `_score` float) COMMENT = 'engine "innodb"';
desc t1;
Field Type Null Key Default Extra
c1 int(11) YES NULL
_score float YES NULL
drop table t1;
-create table `_aaa` (c1 int) engine = groonga;
+create table `_aaa` (c1 int) COMMENT = 'engine "innodb"';
ERROR HY000: [table][create]: name can't start with '_' and 0-9, and contains only 0-9, A-Z, a-z, or _: <_aaa>
-create table t1 (c1 int, `_id` text) engine = groonga;
+create table t1 (c1 int, `_id` text) COMMENT = 'engine "innodb"';
ERROR HY000: _id must be numeric data type
-create table t1 (c1 int, `_score` int) engine = groonga;
+create table t1 (c1 int, `_score` int) COMMENT = 'engine "innodb"';
ERROR HY000: _score must be float or double
-create table t1 (c1 int, `_id` int, index(`_id`)) engine = groonga;
+create table t1 (c1 int, `_id` int, index(`_id`)) COMMENT = 'engine "innodb"';
ERROR HY000: only hash index can be defined for _id
-create table t1 (c1 int, `_score` double, index(`_score`)) engine = groonga;
+create table t1 (c1 int, `_score` double, index(`_score`)) COMMENT = 'engine "innodb"';
ERROR HY000: _score cannot be used for index
create table t1 (_id int, c1 int, primary key (_id)) COMMENT = 'engine "innodb"';
ERROR HY000: only hash index can be defined for _id
Modified: test/sql/t/create_table_wrapper.test (+7 -7)
===================================================================
--- test/sql/t/create_table_wrapper.test 2011-06-09 07:48:05 +0000 (d45a6d9)
+++ test/sql/t/create_table_wrapper.test 2011-06-09 09:05:51 +0000 (00c96d1)
@@ -116,26 +116,26 @@ desc t1;
drop table t1;
# virtual columns
-create table t1 (c1 int, `_id` int) engine = groonga;
+create table t1 (c1 int, `_id` int) COMMENT = 'engine "innodb"';
desc t1;
drop table t1;
-create table t1 (c1 int, `_score` float) engine = groonga;
+create table t1 (c1 int, `_score` float) COMMENT = 'engine "innodb"';
desc t1;
drop table t1;
# error
--error 1005
-create table `_aaa` (c1 int) engine = groonga;
+create table `_aaa` (c1 int) COMMENT = 'engine "innodb"';
# checking for virtual columns
--error 1005
-create table t1 (c1 int, `_id` text) engine = groonga;
+create table t1 (c1 int, `_id` text) COMMENT = 'engine "innodb"';
--error 1005
-create table t1 (c1 int, `_score` int) engine = groonga;
+create table t1 (c1 int, `_score` int) COMMENT = 'engine "innodb"';
--error 1005
-create table t1 (c1 int, `_id` int, index(`_id`)) engine = groonga;
+create table t1 (c1 int, `_id` int, index(`_id`)) COMMENT = 'engine "innodb"';
--error 1005
-create table t1 (c1 int, `_score` double, index(`_score`)) engine = groonga;
+create table t1 (c1 int, `_score` double, index(`_score`)) COMMENT = 'engine "innodb"';
# index for _id
--error 1005