Kouhei Sutou
null+****@clear*****
Thu Oct 4 10:28:33 JST 2012
Kouhei Sutou 2011-09-24 19:36:24 +0900 (Sat, 24 Sep 2011) New Revision: 851197fd7fb79dd55e27f7e4b2960be43a33134f https://github.com/mroonga/mroonga/commit/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 19:34:38 +0900 (954f644) +++ test/sql/groonga_storage/r/geometry_contains.result 2011-09-24 19:36:24 +0900 (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 19:34:38 +0900 (b881a42) +++ test/sql/groonga_storage/t/geometry_contains.test 2011-09-24 19:36:24 +0900 (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)')); -------------- next part -------------- HTML����������������������������...Download