null+****@clear*****
null+****@clear*****
2011年 6月 10日 (金) 17:35:26 JST
Kouhei Sutou 2011-06-10 08:35:26 +0000 (Fri, 10 Jun 2011)
New Revision: 739ad048274ec0bf9d2a1249b79bc51ab22cf3b1
Log:
[test][sql][wrapper] remove groonga specific test.
Modified files:
test/sql/r/create_table_wrapper.result
test/sql/t/create_table_wrapper.test
Modified: test/sql/r/create_table_wrapper.result (+0 -34)
===================================================================
--- test/sql/r/create_table_wrapper.result 2011-06-10 00:22:40 +0000 (7118c3e)
+++ test/sql/r/create_table_wrapper.result 2011-06-10 08:35:26 +0000 (5cb8d85)
@@ -146,37 +146,3 @@ 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) 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) 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) 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) COMMENT = 'engine "innodb"';
-ERROR HY000: _id must be numeric data type
-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`)) COMMENT = 'engine "innodb"';
-ERROR HY000: only hash index can be defined for _id
-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
-create table t1 (_id int, c1 int, primary key (_id) using hash) COMMENT = 'engine "innodb"';
-drop table t1;
-create table t1 (_id int, c1 int, unique key (_id)) COMMENT = 'engine "innodb"';
-ERROR HY000: only hash index can be defined for _id
-create table t1 (_id int, c1 int, unique key (_id) using hash) COMMENT = 'engine "innodb"';
-drop table t1;
-create table t1 (_id int, c1 int, key (_id)) COMMENT = 'engine "innodb"';
-ERROR HY000: only hash index can be defined for _id
-create table t1 (_id int, c1 int, key (_id) using hash) COMMENT = 'engine "innodb"';
-drop table t1;
Modified: test/sql/t/create_table_wrapper.test (+1 -36)
===================================================================
--- test/sql/t/create_table_wrapper.test 2011-06-10 00:22:40 +0000 (00c96d1)
+++ test/sql/t/create_table_wrapper.test 2011-06-10 08:35:26 +0000 (09c99fd)
@@ -1,4 +1,5 @@
# Copyright(C) 2010 Tetsuro IKEDA
+# Copyright(C) 2011 Kouhei Sutou <kou****@clear*****>
#
# This library is free software; you can redistribute it and/or
# modify it under the terms of the GNU Lesser General Public
@@ -115,40 +116,4 @@ create table t1 (c1 set("A","B","AB","O")) COMMENT = 'engine "innodb"';
desc t1;
drop table t1;
-# virtual columns
-create table t1 (c1 int, `_id` int) COMMENT = 'engine "innodb"';
-desc t1;
-drop table t1;
-create table t1 (c1 int, `_score` float) COMMENT = 'engine "innodb"';
-desc t1;
-drop table t1;
-
-# error
---error 1005
-create table `_aaa` (c1 int) COMMENT = 'engine "innodb"';
-
-# checking for virtual columns
---error 1005
-create table t1 (c1 int, `_id` text) COMMENT = 'engine "innodb"';
---error 1005
-create table t1 (c1 int, `_score` int) COMMENT = 'engine "innodb"';
---error 1005
-create table t1 (c1 int, `_id` int, index(`_id`)) COMMENT = 'engine "innodb"';
---error 1005
-create table t1 (c1 int, `_score` double, index(`_score`)) COMMENT = 'engine "innodb"';
-
-# index for _id
---error 1005
-create table t1 (_id int, c1 int, primary key (_id)) COMMENT = 'engine "innodb"';
-create table t1 (_id int, c1 int, primary key (_id) using hash) COMMENT = 'engine "innodb"';
-drop table t1;
---error 1005
-create table t1 (_id int, c1 int, unique key (_id)) COMMENT = 'engine "innodb"';
-create table t1 (_id int, c1 int, unique key (_id) using hash) COMMENT = 'engine "innodb"';
-drop table t1;
---error 1005
-create table t1 (_id int, c1 int, key (_id)) COMMENT = 'engine "innodb"';
-create table t1 (_id int, c1 int, key (_id) using hash) COMMENT = 'engine "innodb"';
-drop table t1;
-
--source suite/groonga/include/groonga_deinit.inc