HAYASHI Kentaro
hayas****@clear*****
Mon Jun 24 14:59:42 JST 2013
メモ: 直後にテーブルとカラムの説明をしているので、 その説明を追加しないと整合性がとれない。 On Mon, 24 Jun 2013 14:32:05 +0900 HAYASHI Kentaro <null+****@clear*****> wrote: > HAYASHI Kentaro 2013-06-24 14:32:05 +0900 (Mon, 24 Jun 2013) > > New Revision: 56b0b4d389dc01915c5175b4652f1a59a873f247 > https://github.com/groonga/groonga/commit/56b0b4d389dc01915c5175b4652f1a59a873f247 > > Message: > doc en: add missing column index for location column > > These changes fix following errors by "make update-examples" > > "geo_in_circle(): index for <Users.location> is missing" > "geo_in_circle(): index for <Comments.location> is missing" > > Modified files: > doc/source/example/tutorial/micro_blog-1.log > doc/source/example/tutorial/micro_blog-4.log > doc/source/tutorial/micro_blog.txt > > Modified: doc/source/example/tutorial/micro_blog-1.log (+3 -0) > =================================================================== > --- doc/source/example/tutorial/micro_blog-1.log 2013-06-24 12:17:39 +0900 (85b1e91) > +++ doc/source/example/tutorial/micro_blog-1.log 2013-06-24 14:32:05 +0900 (95c49f9) > @@ -23,6 +23,9 @@ Execution example:: > # [[0, 1337566253.89858, 0.000355720520019531], true] > # [[0, 1337566253.89858, 0.000355720520019531], true] > # [[0, 1337566253.89858, 0.000355720520019531], true] > + # [[0, 1337566253.89858, 0.000355720520019531], true] > + # [[0, 1337566253.89858, 0.000355720520019531], true] > + # [[0, 1337566253.89858, 0.000355720520019531], true] > # [[0, 1337566253.89858, 0.000355720520019531], 3] > # [[0, 1337566253.89858, 0.000355720520019531], 8] > # [ > > Modified: doc/source/example/tutorial/micro_blog-4.log (+6 -6) > =================================================================== > --- doc/source/example/tutorial/micro_blog-4.log 2013-06-24 12:17:39 +0900 (f8e4471) > +++ doc/source/example/tutorial/micro_blog-4.log 2013-06-24 14:32:05 +0900 (b3abce0) > @@ -23,16 +23,16 @@ Execution example:: > # ] > # ], > # [ > - # "OffGao", > - # "@daijiro @tasukuchan 登録してみましたよー！" > + # "グニャラくん", > + # "groonga開発合宿のため羽田空港に来ました！ #groonga #travel" > # ], > # [ > # "グニャラくん", > # "groongaなう #groonga" > # ], > # [ > - # "グニャラくん", > - # "groonga開発合宿のため羽田空港に来ました！ #groonga #travel" > + # "OffGao", > + # "@daijiro @tasukuchan 登録してみましたよー！" > # ], > # [ > # "OffGao", > @@ -77,11 +77,11 @@ Execution example:: > # ] > # ], > # [ > - # "OffGao", > + # "tasukuchan", > # 2 > # ], > # [ > - # "tasukuchan", > + # "OffGao", > # 2 > # ] > # ] > > Modified: doc/source/tutorial/micro_blog.txt (+8 -0) > =================================================================== > --- doc/source/tutorial/micro_blog.txt 2013-06-24 12:17:39 +0900 (7728ddc) > +++ doc/source/tutorial/micro_blog.txt 2013-06-24 14:32:05 +0900 (b2cf912) > @@ -21,6 +21,7 @@ > table_create --name Comments --flags TABLE_HASH_KEY --key_type ShortText > table_create --name HashTags --flags TABLE_HASH_KEY --key_type ShortText > table_create --name Bigram --flags TABLE_PAT_KEY|KEY_NORMALIZE --key_type ShortText --default_tokenizer TokenBigram > + table_create --name GeoIndex --flags TABLE_PAT_KEY --key_type WGS84GeoPoint > > column_create --table Users --name name --flags COLUMN_SCALAR --type ShortText > column_create --table Users --name follower --flags COLUMN_VECTOR --type Users > @@ -44,6 +45,9 @@ > column_create --table Bigram --name users_index --flags COLUMN_INDEX|WITH_POSITION|WITH_SECTION --type Users --source name,location_str,description > column_create --table Bigram --name comment_index --flags COLUMN_INDEX|WITH_POSITION --type Comments --source comment > > + column_create --table GeoIndex --name users_location --type Users --flags COLUMN_INDEX --source location > + column_create --table GeoIndex --name comments_location --type Comments --flags COLUMN_INDEX --source location > + > Usersテーブル > ^^^^^^^^^^^^^ > > @@ -249,6 +253,7 @@ Commentsテーブルのlast_modifiedカラムは、Time型です。この型で > table_create --name Comments --flags TABLE_HASH_KEY --key_type ShortText > table_create --name HashTags --flags TABLE_HASH_KEY --key_type ShortText > table_create --name Bigram --flags TABLE_PAT_KEY|KEY_NORMALIZE --key_type ShortText --default_tokenizer TokenBigram > + table_create --name GeoIndex --flags TABLE_PAT_KEY --key_type WGS84GeoPoint > > column_create --table Users --name name --flags COLUMN_SCALAR --type ShortText > column_create --table Users --name follower --flags COLUMN_VECTOR --type Users > @@ -272,6 +277,9 @@ Commentsテーブルのlast_modifiedカラムは、Time型です。この型で > column_create --table Bigram --name users_index --flags COLUMN_INDEX|WITH_POSITION|WITH_SECTION --type Users --source name,location_str,description > column_create --table Bigram --name comment_index --flags COLUMN_INDEX|WITH_POSITION --type Comments --source comment > > + column_create --table GeoIndex --name users_location --type Users --flags COLUMN_INDEX --source location > + column_create --table GeoIndex --name comments_location --type Comments --flags COLUMN_INDEX --source location > + > load --table Users > [ > { -- HAYASHI Kentaro <hayas****@clear*****>
