null+****@clear*****
null+****@clear*****
2011年 9月 24日 (土) 19:36:24 JST
Kouhei Sutou 2011-09-24 10:36:24 +0000 (Sat, 24 Sep 2011)
New Revision: 851197fd7fb79dd55e27f7e4b2960be43a33134f
Log:
[storage][test] add show create table.
Modified files:
test/sql/groonga_storage/r/geometry_contains.result
test/sql/groonga_storage/t/geometry_contains.test
Modified: test/sql/groonga_storage/r/geometry_contains.result (+10 -1)
===================================================================
--- test/sql/groonga_storage/r/geometry_contains.result 2011-09-24 10:34:38 +0000 (954f644)
+++ test/sql/groonga_storage/r/geometry_contains.result 2011-09-24 10:36:24 +0000 (ce1a3c6)
@@ -3,8 +3,17 @@ create table shops (
id int primary key auto_increment,
name text,
location geometry NOT NULL,
-SPATIAL KEY location_index (location)
+spatial key location_index (location)
);
+show create table shops;
+Table Create Table
+shops CREATE TABLE `shops` (
+ `id` int(11) NOT NULL AUTO_INCREMENT,
+ `name` text,
+ `location` geometry NOT NULL,
+ PRIMARY KEY (`id`),
+ SPATIAL KEY `location_index` (`location`)
+) ENGINE=groonga DEFAULT CHARSET=latin1
insert into shops (name, location)
values ('nezu-no-taiyaki',
GeomFromText('POINT(139.762573 35.720253)'));
Modified: test/sql/groonga_storage/t/geometry_contains.test (+2 -1)
===================================================================
--- test/sql/groonga_storage/t/geometry_contains.test 2011-09-24 10:34:38 +0000 (b881a42)
+++ test/sql/groonga_storage/t/geometry_contains.test 2011-09-24 10:36:24 +0000 (7e11e40)
@@ -24,8 +24,9 @@ create table shops (
id int primary key auto_increment,
name text,
location geometry NOT NULL,
- SPATIAL KEY location_index (location)
+ spatial key location_index (location)
);
+show create table shops;
insert into shops (name, location)
values ('nezu-no-taiyaki',
GeomFromText('POINT(139.762573 35.720253)'));