null+****@clear*****
null+****@clear*****
2012年 5月 10日 (木) 10:14:06 JST
Kouhei Sutou 2012-05-10 10:14:06 +0900 (Thu, 10 May 2012) New Revision: 034a5425e9519903019a355bd91ac5e0f4f237d2 Log: doc: update execution examples Modified files: doc/source/example/commands/select/filter_equal.log doc/source/example/commands/select/filter_less_than.log doc/source/example/commands/select/match_columns_simple.log doc/source/example/commands/select/match_columns_some_columns.log doc/source/example/commands/select/match_columns_weight.log doc/source/example/commands/select/match_escalation_threshold.log doc/source/example/commands/select/no_limit.log doc/source/example/commands/select/paging.log doc/source/example/commands/select/query_and.log doc/source/example/commands/select/query_equal.log doc/source/example/commands/select/query_less_than.log doc/source/example/commands/select/query_or.log doc/source/example/commands/select/simple_filter.log doc/source/example/commands/select/simple_query.log doc/source/example/commands/select/simple_usage.log doc/source/example/commands/select/table_nonexistent.log doc/source/example/commands/select/usage_setup.log doc/source/example/completion-1.log doc/source/example/correction-1.log doc/source/example/suggestion-1.log doc/source/example/tutorial/data-1.log doc/source/example/tutorial/data-2.log doc/source/example/tutorial/data-3.log doc/source/example/tutorial/data-4.log doc/source/example/tutorial/data-5.log doc/source/example/tutorial/data-6.log doc/source/example/tutorial/data-7.log doc/source/example/tutorial/data-8.log doc/source/example/tutorial/drilldown-1.log doc/source/example/tutorial/drilldown-2.log doc/source/example/tutorial/drilldown-3.log doc/source/example/tutorial/drilldown-4.log doc/source/example/tutorial/drilldown-5.log doc/source/example/tutorial/drilldown-6.log doc/source/example/tutorial/index-1.log doc/source/example/tutorial/index-2.log doc/source/example/tutorial/index-3.log doc/source/example/tutorial/index-4.log doc/source/example/tutorial/index-5.log doc/source/example/tutorial/index-6.log doc/source/example/tutorial/index-7.log doc/source/example/tutorial/introduction-1.log doc/source/example/tutorial/introduction-10.log doc/source/example/tutorial/introduction-11.log doc/source/example/tutorial/introduction-12.log doc/source/example/tutorial/introduction-13.log doc/source/example/tutorial/introduction-14.log doc/source/example/tutorial/introduction-15.log doc/source/example/tutorial/introduction-16.log doc/source/example/tutorial/introduction-17.log doc/source/example/tutorial/introduction-18.log doc/source/example/tutorial/introduction-2.log doc/source/example/tutorial/introduction-3.log doc/source/example/tutorial/introduction-4.log doc/source/example/tutorial/introduction-5.log doc/source/example/tutorial/introduction-6.log doc/source/example/tutorial/introduction-7.log doc/source/example/tutorial/introduction-8.log doc/source/example/tutorial/introduction-9.log doc/source/example/tutorial/match_columns-1.log doc/source/example/tutorial/match_columns-2.log doc/source/example/tutorial/match_columns-3.log doc/source/example/tutorial/match_columns-4.log doc/source/example/tutorial/micro_blog-1.log doc/source/example/tutorial/micro_blog-10.log doc/source/example/tutorial/micro_blog-2.log doc/source/example/tutorial/micro_blog-3.log doc/source/example/tutorial/micro_blog-4.log doc/source/example/tutorial/micro_blog-5.log doc/source/example/tutorial/micro_blog-6.log doc/source/example/tutorial/micro_blog-7.log doc/source/example/tutorial/micro_blog-8.log doc/source/example/tutorial/micro_blog-9.log doc/source/example/tutorial/network-1.log doc/source/example/tutorial/network-3.log doc/source/example/tutorial/patricia_trie-1.log doc/source/example/tutorial/patricia_trie-2.log doc/source/example/tutorial/query_expansion-1.log doc/source/example/tutorial/query_expansion-2.log doc/source/example/tutorial/query_expansion-3.log doc/source/example/tutorial/search-1.log doc/source/example/tutorial/search-2.log doc/source/example/tutorial/search-3.log doc/source/example/tutorial/search-4.log doc/source/example/tutorial/search-5.log doc/source/example/tutorial/search-6.log doc/source/example/tutorial/search-7.log Modified: doc/source/example/commands/select/filter_equal.log (+2 -2) =================================================================== --- doc/source/example/commands/select/filter_equal.log 2012-05-10 10:12:32 +0900 (a112d7c) +++ doc/source/example/commands/select/filter_equal.log 2012-05-10 10:14:06 +0900 (07a6dfd) @@ -4,8 +4,8 @@ Execution example:: # [ # [ # 0, - # 1336468386.94773, - # 0.000296354293823242 + # 1336611812.329, + # 0.000258684158325195 # ], # [ # [ Modified: doc/source/example/commands/select/filter_less_than.log (+2 -2) =================================================================== --- doc/source/example/commands/select/filter_less_than.log 2012-05-10 10:12:32 +0900 (c195c52) +++ doc/source/example/commands/select/filter_less_than.log 2012-05-10 10:14:06 +0900 (cb35358) @@ -4,8 +4,8 @@ Execution example:: # [ # [ # 0, - # 1336468387.14931, - # 0.000354528427124023 + # 1336611812.5306, + # 0.000262260437011719 # ], # [ # [ Modified: doc/source/example/commands/select/match_columns_simple.log (+2 -2) =================================================================== --- doc/source/example/commands/select/match_columns_simple.log 2012-05-10 10:12:32 +0900 (04aa28a) +++ doc/source/example/commands/select/match_columns_simple.log 2012-05-10 10:14:06 +0900 (d9e6eb1) @@ -4,8 +4,8 @@ Execution example:: # [ # [ # 0, - # 1336468385.53409, - # 0.000331878662109375 + # 1336611810.90718, + # 0.000256538391113281 # ], # [ # [ Modified: doc/source/example/commands/select/match_columns_some_columns.log (+2 -2) =================================================================== --- doc/source/example/commands/select/match_columns_some_columns.log 2012-05-10 10:12:32 +0900 (cce9d05) +++ doc/source/example/commands/select/match_columns_some_columns.log 2012-05-10 10:14:06 +0900 (9830a71) @@ -4,8 +4,8 @@ Execution example:: # [ # [ # 0, - # 1336468385.93695, - # 0.000330209732055664 + # 1336611811.31145, + # 0.000434637069702148 # ], # [ # [ Modified: doc/source/example/commands/select/match_columns_weight.log (+2 -2) =================================================================== --- doc/source/example/commands/select/match_columns_weight.log 2012-05-10 10:12:32 +0900 (b479018) +++ doc/source/example/commands/select/match_columns_weight.log 2012-05-10 10:14:06 +0900 (5f00358) @@ -4,8 +4,8 @@ Execution example:: # [ # [ # 0, - # 1336468385.73556, - # 0.00034332275390625 + # 1336611811.10905, + # 0.000304698944091797 # ], # [ # [ Modified: doc/source/example/commands/select/match_escalation_threshold.log (+4 -4) =================================================================== --- doc/source/example/commands/select/match_escalation_threshold.log 2012-05-10 10:12:32 +0900 (5803e58) +++ doc/source/example/commands/select/match_escalation_threshold.log 2012-05-10 10:14:06 +0900 (e7e8041) @@ -4,8 +4,8 @@ Execution example:: # [ # [ # 0, - # 1336468387.35126, - # 0.000413894653320312 + # 1336611812.7323, + # 0.000343561172485352 # ], # [ # [ @@ -43,8 +43,8 @@ Execution example:: # [ # [ # 0, - # 1336468387.55269, - # 0.000319004058837891 + # 1336611812.93373, + # 0.000299453735351562 # ], # [ # [ Modified: doc/source/example/commands/select/no_limit.log (+2 -2) =================================================================== --- doc/source/example/commands/select/no_limit.log 2012-05-10 10:12:32 +0900 (79754f5) +++ doc/source/example/commands/select/no_limit.log 2012-05-10 10:14:06 +0900 (9d131a6) @@ -4,8 +4,8 @@ Execution example:: # [ # [ # 0, - # 1336468385.13137, - # 0.000172138214111328 + # 1336611810.50242, + # 0.000186681747436523 # ], # [ # [ Modified: doc/source/example/commands/select/paging.log (+2 -2) =================================================================== --- doc/source/example/commands/select/paging.log 2012-05-10 10:12:32 +0900 (6df6128) +++ doc/source/example/commands/select/paging.log 2012-05-10 10:14:06 +0900 (f568d2e) @@ -4,8 +4,8 @@ Execution example:: # [ # [ # 0, - # 1336468384.93004, - # 0.000171661376953125 + # 1336611810.30042, + # 0.000216245651245117 # ], # [ # [ Modified: doc/source/example/commands/select/query_and.log (+2 -2) =================================================================== --- doc/source/example/commands/select/query_and.log 2012-05-10 10:12:32 +0900 (096d817) +++ doc/source/example/commands/select/query_and.log 2012-05-10 10:14:06 +0900 (eb62143) @@ -4,8 +4,8 @@ Execution example:: # [ # [ # 0, - # 1336468386.13964, - # 0.000435829162597656 + # 1336611811.51658, + # 0.000452756881713867 # ], # [ # [ Modified: doc/source/example/commands/select/query_equal.log (+2 -2) =================================================================== --- doc/source/example/commands/select/query_equal.log 2012-05-10 10:12:32 +0900 (b3af178) +++ doc/source/example/commands/select/query_equal.log 2012-05-10 10:14:06 +0900 (0c10f25) @@ -4,8 +4,8 @@ Execution example:: # [ # [ # 0, - # 1336468386.54406, - # 0.00028681755065918 + # 1336611811.92408, + # 0.000410079956054688 # ], # [ # [ Modified: doc/source/example/commands/select/query_less_than.log (+2 -2) =================================================================== --- doc/source/example/commands/select/query_less_than.log 2012-05-10 10:12:32 +0900 (058080e) +++ doc/source/example/commands/select/query_less_than.log 2012-05-10 10:14:06 +0900 (28a3420) @@ -4,8 +4,8 @@ Execution example:: # [ # [ # 0, - # 1336468386.74599, - # 0.000313997268676758 + # 1336611812.12614, + # 0.000287294387817383 # ], # [ # [ Modified: doc/source/example/commands/select/query_or.log (+2 -2) =================================================================== --- doc/source/example/commands/select/query_or.log 2012-05-10 10:12:32 +0900 (fc07bae) +++ doc/source/example/commands/select/query_or.log 2012-05-10 10:14:06 +0900 (764f470) @@ -4,8 +4,8 @@ Execution example:: # [ # [ # 0, - # 1336468386.34177, - # 0.000362157821655273 + # 1336611811.71885, + # 0.000710248947143555 # ], # [ # [ Modified: doc/source/example/commands/select/simple_filter.log (+2 -2) =================================================================== --- doc/source/example/commands/select/simple_filter.log 2012-05-10 10:12:32 +0900 (15ddc57) +++ doc/source/example/commands/select/simple_filter.log 2012-05-10 10:14:06 +0900 (ffccc8e) @@ -4,8 +4,8 @@ Execution example:: # [ # [ # 0, - # 1336468384.7285, - # 0.00033116340637207 + # 1336611810.09767, + # 0.000473737716674805 # ], # [ # [ Modified: doc/source/example/commands/select/simple_query.log (+2 -2) =================================================================== --- doc/source/example/commands/select/simple_query.log 2012-05-10 10:12:32 +0900 (64e2fe4) +++ doc/source/example/commands/select/simple_query.log 2012-05-10 10:14:06 +0900 (e122d75) @@ -4,8 +4,8 @@ Execution example:: # [ # [ # 0, - # 1336468384.52646, - # 0.000507831573486328 + # 1336611809.89455, + # 0.000563383102416992 # ], # [ # [ Modified: doc/source/example/commands/select/simple_usage.log (+2 -2) =================================================================== --- doc/source/example/commands/select/simple_usage.log 2012-05-10 10:12:32 +0900 (586f3b8) +++ doc/source/example/commands/select/simple_usage.log 2012-05-10 10:14:06 +0900 (8b58474) @@ -4,8 +4,8 @@ Execution example:: # [ # [ # 0, - # 1336468384.32453, - # 0.000257015228271484 + # 1336611809.69057, + # 0.000313520431518555 # ], # [ # [ Modified: doc/source/example/commands/select/table_nonexistent.log (+2 -2) =================================================================== --- doc/source/example/commands/select/table_nonexistent.log 2012-05-10 10:12:32 +0900 (b3e9d70) +++ doc/source/example/commands/select/table_nonexistent.log 2012-05-10 10:14:06 +0900 (ecc616e) @@ -4,8 +4,8 @@ Execution example:: # [ # [ # -22, - # 1336468385.33269, - # 0.000337600708007812, + # 1336611810.7049, + # 0.000555038452148438, # "invalid table name: <Nonexistent>", # [ # [ Modified: doc/source/example/commands/select/usage_setup.log (+7 -7) =================================================================== --- doc/source/example/commands/select/usage_setup.log 2012-05-10 10:12:32 +0900 (a8f9856) +++ doc/source/example/commands/select/usage_setup.log 2012-05-10 10:14:06 +0900 (d54f483) @@ -1,17 +1,17 @@ Execution example:: table_create Entries TABLE_HASH_KEY ShortText - # [[0,1336468382.70925,0.000218391418457031],true] + # [[0,1336611808.06813,0.000176191329956055],true] column_create Entries content COLUMN_SCALAR Text - # [[0,1336468382.91008,0.000534534454345703],true] + # [[0,1336611808.26927,0.000956296920776367],true] column_create Entries n_likes COLUMN_SCALAR UInt32 - # [[0,1336468383.11114,0.00021815299987793],true] + # [[0,1336611808.47111,0.000242948532104492],true] table_create Terms TABLE_PAT_KEY|KEY_NORMALIZE ShortText --default_tokenizer TokenBigram - # [[0,1336468383.31188,0.000239849090576172],true] + # [[0,1336611808.67209,0.000334978103637695],true] column_create Terms entries_key_index COLUMN_INDEX|WITH_POSITION Entries _key - # [[0,1336468383.51263,0.00399947166442871],true] + # [[0,1336611808.87329,0.00582623481750488],true] column_create Terms entries_content_index COLUMN_INDEX|WITH_POSITION Entries content - # [[0,1336468383.71716,0.00355195999145508],true] + # [[0,1336611809.07999,0.00536251068115234],true] load --table Entries [ {"_key": "The first post!", @@ -24,4 +24,4 @@ Execution example:: "content": "I also started to use mroonga. It's also very fast! Really fast!", "n_likes": 15} ] - # [[0,1336468383.92122,0.202519655227661],3] + # [[0,1336611809.28621,0.203172922134399],3] Modified: doc/source/example/completion-1.log (+2 -2) =================================================================== --- doc/source/example/completion-1.log 2012-05-10 10:12:32 +0900 (1578305) +++ doc/source/example/completion-1.log 2012-05-10 10:14:06 +0900 (5a6bd31) @@ -4,8 +4,8 @@ Execution example:: # [ # [ # 0, - # 1336468379.14295, - # 0.000610589981079102 + # 1336611804.53526, + # 0.000535488128662109 # ], # { # "complete": [ Modified: doc/source/example/correction-1.log (+2 -2) =================================================================== --- doc/source/example/correction-1.log 2012-05-10 10:12:32 +0900 (c2cd372) +++ doc/source/example/correction-1.log 2012-05-10 10:14:06 +0900 (80e75d4) @@ -4,8 +4,8 @@ Execution example:: # [ # [ # 0, - # 1336468380.42915, - # 0.000398397445678711 + # 1336611805.8012, + # 0.000647783279418945 # ], # { # "correct": [ Modified: doc/source/example/suggestion-1.log (+2 -2) =================================================================== --- doc/source/example/suggestion-1.log 2012-05-10 10:12:32 +0900 (5005abe) +++ doc/source/example/suggestion-1.log 2012-05-10 10:14:06 +0900 (70ed400) @@ -4,8 +4,8 @@ Execution example:: # [ # [ # 0, - # 1336468379.78154, - # 0.000372171401977539 + # 1336611805.1708, + # 0.000539064407348633 # ], # { # "suggest": [ Modified: doc/source/example/tutorial/data-1.log (+1 -1) =================================================================== --- doc/source/example/tutorial/data-1.log 2012-05-10 10:12:32 +0900 (933a2bb) +++ doc/source/example/tutorial/data-1.log 2012-05-10 10:14:06 +0900 (e6d93c4) @@ -1,4 +1,4 @@ Execution example:: table_create --name ToyBox --flags TABLE_HASH_KEY --key_type ShortText - # [[0,1336468394.04655,0.000269889831542969],true] + # [[0,1336611819.44127,0.000303030014038086],true] Modified: doc/source/example/tutorial/data-2.log (+4 -4) =================================================================== --- doc/source/example/tutorial/data-2.log 2012-05-10 10:12:32 +0900 (88cfb21) +++ doc/source/example/tutorial/data-2.log 2012-05-10 10:14:06 +0900 (2bf9465) @@ -1,20 +1,20 @@ Execution example:: column_create --table ToyBox --name is_animal --type Bool - # [[0,1336468394.24776,0.000195503234863281],true] + # [[0,1336611819.64273,0.000374794006347656],true] load --table ToyBox [ {"_key":"Monkey","is_animal":true} {"_key":"Flower","is_animal":false} {"_key":"Block"} ] - # [[0,1336468394.44844,0.20062780380249],3] + # [[0,1336611819.84394,0.200589179992676],3] select --table ToyBox --output_columns _key,is_animal # [ # [ # 0, - # 1336468394.84955, - # 0.000217676162719727 + # 1336611820.24499, + # 0.000177383422851562 # ], # [ # [ Modified: doc/source/example/tutorial/data-3.log (+5 -5) =================================================================== --- doc/source/example/tutorial/data-3.log 2012-05-10 10:12:32 +0900 (a6def39) +++ doc/source/example/tutorial/data-3.log 2012-05-10 10:14:06 +0900 (ac6007f) @@ -1,22 +1,22 @@ Execution example:: column_create --table ToyBox --name price --type Int8 - # [[0,1336468395.05099,0.000190258026123047],true] + # [[0,1336611820.44642,0.000164985656738281],true] column_create --table ToyBox --name weight --type Float - # [[0,1336468395.25174,0.00020289421081543],true] + # [[0,1336611820.64708,0.000161409378051758],true] load --table ToyBox [ {"_key":"Monkey","price":15.9} {"_key":"Flower","price":200,"weight":0.13} {"_key":"Block","weight":25.7} ] - # [[0,1336468395.45248,0.200597286224365],3] + # [[0,1336611820.84755,0.200565576553345],3] select --table ToyBox --output_columns _key,price,weight # [ # [ # 0, - # 1336468395.8535, - # 0.000161170959472656 + # 1336611821.24859, + # 0.000151157379150391 # ], # [ # [ Modified: doc/source/example/tutorial/data-4.log (+4 -4) =================================================================== --- doc/source/example/tutorial/data-4.log 2012-05-10 10:12:32 +0900 (95310cc) +++ doc/source/example/tutorial/data-4.log 2012-05-10 10:14:06 +0900 (b1032d0) @@ -1,19 +1,19 @@ Execution example:: column_create --table ToyBox --name name --type ShortText - # [[0,1336468396.05497,0.000494003295898438],true] + # [[0,1336611821.45016,0.000436305999755859],true] load --table ToyBox [ {"_key":"Monkey","name":"Grease"} {"_key":"Flower","name":"Rose"} ] - # [[0,1336468396.25599,0.200543642044067],2] + # [[0,1336611821.65106,0.200551986694336],2] select --table ToyBox --output_columns _key,name # [ # [ # 0, - # 1336468396.65701, - # 0.000139951705932617 + # 1336611822.0521, + # 0.000115394592285156 # ], # [ # [ Modified: doc/source/example/tutorial/data-5.log (+4 -4) =================================================================== --- doc/source/example/tutorial/data-5.log 2012-05-10 10:12:32 +0900 (1ade1bc) +++ doc/source/example/tutorial/data-5.log 2012-05-10 10:14:06 +0900 (54f66e0) @@ -1,19 +1,19 @@ Execution example:: column_create --table ToyBox --name time --type Time - # [[0,1336468396.85832,0.000158786773681641],true] + # [[0,1336611822.25344,0.000145912170410156],true] load --table ToyBox [ {"_key":"Flower","time":1234567890.1234569999} {"_key":"Block","time":-1234567890} ] - # [[0,1336468397.05898,0.200578927993774],2] + # [[0,1336611822.45411,0.200608730316162],2] select --table ToyBox --output_columns _key,time # [ # [ # 0, - # 1336468397.46003, - # 0.000164031982421875 + # 1336611822.85535, + # 0.000291585922241211 # ], # [ # [ Modified: doc/source/example/tutorial/data-6.log (+4 -4) =================================================================== --- doc/source/example/tutorial/data-6.log 2012-05-10 10:12:32 +0900 (9dc3a7b) +++ doc/source/example/tutorial/data-6.log 2012-05-10 10:14:06 +0900 (f65e387) @@ -1,19 +1,19 @@ Execution example:: column_create --table ToyBox --name location --type WGS84GeoPoint - # [[0,1336468397.6614,0.00018763542175293],true] + # [[0,1336611823.05786,0.000207662582397461],true] load --table ToyBox [ {"_key":"Monkey","location":"128452975x503157902"} {"_key":"Block","location":"35.6813819x139.7660839"} ] - # [[0,1336468397.86209,0.200498580932617],2] + # [[0,1336611823.25875,0.200576543807983],2] select --table ToyBox --output_columns _key,location # [ # [ # 0, - # 1336468398.26311, - # 0.000158071517944336 + # 1336611823.65991, + # 0.000181436538696289 # ], # [ # [ Modified: doc/source/example/tutorial/data-7.log (+4 -4) =================================================================== --- doc/source/example/tutorial/data-7.log 2012-05-10 10:12:32 +0900 (64f9be8) +++ doc/source/example/tutorial/data-7.log 2012-05-10 10:14:06 +0900 (c41e747) @@ -1,16 +1,16 @@ Execution example:: column_create --table Site --name link --type Site - # [[0,1336468398.46454,0.00023341178894043],true] + # [[0,1336611823.86268,0.000335931777954102],true] load --table Site [{"_key":"http://example.org/","link":"http://example.net/"}] select --table Site --output_columns _key,title,link._key,link.title --query title:@this - # [[0,1336468398.66529,0.200507402420044],1] + # [[0,1336611824.0639,0.200538396835327],1] # [ # [ # 0, - # 1336468398.86583, - # 0.00056004524230957 + # 1336611824.2645, + # 0.000945568084716797 # ], # [ # [ Modified: doc/source/example/tutorial/data-8.log (+4 -4) =================================================================== --- doc/source/example/tutorial/data-8.log 2012-05-10 10:12:32 +0900 (d094f8f) +++ doc/source/example/tutorial/data-8.log 2012-05-10 10:14:06 +0900 (05537e6) @@ -1,16 +1,16 @@ Execution example:: column_create --table Site --name links --flags COLUMN_VECTOR --type Site - # [[0,1336468399.06797,0.00054478645324707],true] + # [[0,1336611824.46827,0.000877857208251953],true] load --table Site [{"_key":"http://example.org/","links":["http://example.net/","http://example.org/","http://example.com/"]}] select --table Site --output_columns _key,title,links._key,links.title --query title:@this - # [[0,1336468399.26902,0.200450658798218],1] + # [[0,1336611824.67004,0.200572729110718],1] # [ # [ # 0, - # 1336468399.4695, - # 0.000309467315673828 + # 1336611824.87066, + # 0.000319957733154297 # ], # [ # [ Modified: doc/source/example/tutorial/drilldown-1.log (+81 -22) =================================================================== --- doc/source/example/tutorial/drilldown-1.log 2012-05-10 10:12:32 +0900 (d719830) +++ doc/source/example/tutorial/drilldown-1.log 2012-05-10 10:14:06 +0900 (0bad740) @@ -1,24 +1,83 @@ Execution example:: - > table_create --name SiteDomain --flags TABLE_HASH_KEY --key_type ShortText - [[0,1317212750.98228,0.098212593],true] - > table_create --name SiteCountry --flags TABLE_HASH_KEY --key_type ShortText - > column_create --table Site --name domain --flags COLUMN_SCALAR --type SiteDomain - [[0,1317212751.28095,0.256200943],true] - [[0,1317212751.53719,0.085740621],true] - > column_create --table Site --name country --flags COLUMN_SCALAR --type SiteCountry - [[0,1317212751.82329,0.064026147],true] - > load --table Site - > [ - > {"_key":"http://example.org/","domain":".org","country":"japan"}, - > {"_key":"http://example.net/","domain":".net","country":"brazil"}, - > {"_key":"http://example.com/","domain":".com","country":"japan"}, - > {"_key":"http://example.net/afr","domain":".net","country":"usa"}, - > {"_key":"http://example.org/aba","domain":".org","country":"korea"}, - > {"_key":"http://example.com/rab","domain":".com","country":"china"}, - > {"_key":"http://example.net/atv","domain":".net","country":"china"}, - > {"_key":"http://example.org/gat","domain":".org","country":"usa"}, - > {"_key":"http://example.com/vdw","domain":".com","country":"japan"} - > ] - [[0,1317212752.0878,2.202801388],9] - \ No newline at end of file + table_create --name SiteDomain --flags TABLE_HASH_KEY --key_type ShortText + # [ + # [ + # -22, + # 1336611851.32846, + # 0.000257730484008789, + # "already used name was assigned: <SiteDomain>", + # [ + # [ + # "grn_obj_register", + # "db.c", + # 6572 + # ] + # ] + # ], + # false + # ] + table_create --name SiteCountry --flags TABLE_HASH_KEY --key_type ShortText + # [ + # [ + # -22, + # 1336611851.52966, + # 0.000301361083984375, + # "already used name was assigned: <SiteCountry>", + # [ + # [ + # "grn_obj_register", + # "db.c", + # 6572 + # ] + # ] + # ], + # false + # ] + column_create --table Site --name domain --flags COLUMN_SCALAR --type SiteDomain + # [ + # [ + # -22, + # 1336611851.73073, + # 0.000830650329589844, + # "already used name was assigned: <Site.domain>", + # [ + # [ + # "grn_obj_register", + # "db.c", + # 6572 + # ] + # ] + # ], + # false + # ] + column_create --table Site --name country --flags COLUMN_SCALAR --type SiteCountry + # [ + # [ + # -22, + # 1336611851.93283, + # 0.000349521636962891, + # "already used name was assigned: <Site.country>", + # [ + # [ + # "grn_obj_register", + # "db.c", + # 6572 + # ] + # ] + # ], + # false + # ] + load --table Site + [ + {"_key":"http://example.org/","domain":".org","country":"japan"}, + {"_key":"http://example.net/","domain":".net","country":"brazil"}, + {"_key":"http://example.com/","domain":".com","country":"japan"}, + {"_key":"http://example.net/afr","domain":".net","country":"usa"}, + {"_key":"http://example.org/aba","domain":".org","country":"korea"}, + {"_key":"http://example.com/rab","domain":".com","country":"china"}, + {"_key":"http://example.net/atv","domain":".net","country":"china"}, + {"_key":"http://example.org/gat","domain":".org","country":"usa"}, + {"_key":"http://example.com/vdw","domain":".com","country":"japan"} + ] + # [[0,1336611852.13468,0.20110821723938],9] Modified: doc/source/example/tutorial/drilldown-2.log (+76 -3) =================================================================== --- doc/source/example/tutorial/drilldown-2.log 2012-05-10 10:12:32 +0900 (cc001d0) +++ doc/source/example/tutorial/drilldown-2.log 2012-05-10 10:14:06 +0900 (0e59194) @@ -1,5 +1,78 @@ Execution example:: - > select --table Site --limit 0 --drilldown domain - [[0,1317212754.4912,0.000250704],[[[9],[["_id","UInt32"],["_key","ShortText"],["title","ShortText"],["location","WGS84GeoPoint"],["links","Site"],["link","Site"],["domain","SiteDomain"],["country","SiteCountry"]]],[[3],[["_key","ShortText"],["_nsubrecs","Int32"]],[".org",3],[".net",3],[".com",3]]]] - \ No newline at end of file + select --table Site --limit 0 --drilldown domain + # [ + # [ + # 0, + # 1336611852.53696, + # 0.000780820846557617 + # ], + # [ + # [ + # [ + # 9 + # ], + # [ + # [ + # "_id", + # "UInt32" + # ], + # [ + # "_key", + # "ShortText" + # ], + # [ + # "country", + # "SiteCountry" + # ], + # [ + # "domain", + # "SiteDomain" + # ], + # [ + # "link", + # "Site" + # ], + # [ + # "links", + # "Site" + # ], + # [ + # "location", + # "WGS84GeoPoint" + # ], + # [ + # "title", + # "ShortText" + # ] + # ] + # ], + # [ + # [ + # 3 + # ], + # [ + # [ + # "_key", + # "ShortText" + # ], + # [ + # "_nsubrecs", + # "Int32" + # ] + # ], + # [ + # ".org", + # 3 + # ], + # [ + # ".net", + # 3 + # ], + # [ + # ".com", + # 3 + # ] + # ] + # ] + # ] Modified: doc/source/example/tutorial/drilldown-3.log (+83 -3) =================================================================== --- doc/source/example/tutorial/drilldown-3.log 2012-05-10 10:12:32 +0900 (2387f46) +++ doc/source/example/tutorial/drilldown-3.log 2012-05-10 10:14:06 +0900 (d54cd5a) @@ -1,5 +1,85 @@ Execution example:: - > select --table Site --limit 0 --drilldown domain --drilldown_output_columns _id,_key,_nsubrecs - [[0,1317212754.69307,0.000359614],[[[9],[["_id","UInt32"],["_key","ShortText"],["title","ShortText"],["location","WGS84GeoPoint"],["links","Site"],["link","Site"],["domain","SiteDomain"],["country","SiteCountry"]]],[[3],[["_id","UInt32"],["_key","ShortText"],["_nsubrecs","Int32"]],[1,".org",3],[2,".net",3],[3,".com",3]]]] - \ No newline at end of file + select --table Site --limit 0 --drilldown domain --drilldown_output_columns _id,_key,_nsubrecs + # [ + # [ + # 0, + # 1336611852.74141, + # 0.000358104705810547 + # ], + # [ + # [ + # [ + # 9 + # ], + # [ + # [ + # "_id", + # "UInt32" + # ], + # [ + # "_key", + # "ShortText" + # ], + # [ + # "country", + # "SiteCountry" + # ], + # [ + # "domain", + # "SiteDomain" + # ], + # [ + # "link", + # "Site" + # ], + # [ + # "links", + # "Site" + # ], + # [ + # "location", + # "WGS84GeoPoint" + # ], + # [ + # "title", + # "ShortText" + # ] + # ] + # ], + # [ + # [ + # 3 + # ], + # [ + # [ + # "_id", + # "UInt32" + # ], + # [ + # "_key", + # "ShortText" + # ], + # [ + # "_nsubrecs", + # "Int32" + # ] + # ], + # [ + # 1, + # ".org", + # 3 + # ], + # [ + # 2, + # ".net", + # 3 + # ], + # [ + # 3, + # ".com", + # 3 + # ] + # ] + # ] + # ] Modified: doc/source/example/tutorial/drilldown-4.log (+111 -3) =================================================================== --- doc/source/example/tutorial/drilldown-4.log 2012-05-10 10:12:32 +0900 (1665abf) +++ doc/source/example/tutorial/drilldown-4.log 2012-05-10 10:14:06 +0900 (07ebf8d) @@ -1,5 +1,113 @@ Execution example:: - > select --table Site --limit 0 --drilldown domain,country - [[0,1317212754.89542,0.000263258],[[[9],[["_id","UInt32"],["_key","ShortText"],["title","ShortText"],["location","WGS84GeoPoint"],["links","Site"],["link","Site"],["domain","SiteDomain"],["country","SiteCountry"]]],[[3],[["_key","ShortText"],["_nsubrecs","Int32"]],[".org",3],[".net",3],[".com",3]],[[5],[["_key","ShortText"],["_nsubrecs","Int32"]],["japan",3],["brazil",1],["usa",2],["korea",1],["china",2]]]] - \ No newline at end of file + select --table Site --limit 0 --drilldown domain,country + # [ + # [ + # 0, + # 1336611852.94523, + # 0.000336408615112305 + # ], + # [ + # [ + # [ + # 9 + # ], + # [ + # [ + # "_id", + # "UInt32" + # ], + # [ + # "_key", + # "ShortText" + # ], + # [ + # "country", + # "SiteCountry" + # ], + # [ + # "domain", + # "SiteDomain" + # ], + # [ + # "link", + # "Site" + # ], + # [ + # "links", + # "Site" + # ], + # [ + # "location", + # "WGS84GeoPoint" + # ], + # [ + # "title", + # "ShortText" + # ] + # ] + # ], + # [ + # [ + # 3 + # ], + # [ + # [ + # "_key", + # "ShortText" + # ], + # [ + # "_nsubrecs", + # "Int32" + # ] + # ], + # [ + # ".org", + # 3 + # ], + # [ + # ".net", + # 3 + # ], + # [ + # ".com", + # 3 + # ] + # ], + # [ + # [ + # 5 + # ], + # [ + # [ + # "_key", + # "ShortText" + # ], + # [ + # "_nsubrecs", + # "Int32" + # ] + # ], + # [ + # "japan", + # 3 + # ], + # [ + # "brazil", + # 1 + # ], + # [ + # "usa", + # 2 + # ], + # [ + # "korea", + # 1 + # ], + # [ + # "china", + # 2 + # ] + # ] + # ] + # ] Modified: doc/source/example/tutorial/drilldown-5.log (+84 -3) =================================================================== --- doc/source/example/tutorial/drilldown-5.log 2012-05-10 10:12:32 +0900 (4568327) +++ doc/source/example/tutorial/drilldown-5.log 2012-05-10 10:14:06 +0900 (67a388a) @@ -1,5 +1,86 @@ Execution example:: - > select --table Site --limit 0 --drilldown country --drilldown_sortby _nsubrecs - [[0,1317212755.09777,0.000284575],[[[9],[["_id","UInt32"],["_key","ShortText"],["title","ShortText"],["location","WGS84GeoPoint"],["links","Site"],["link","Site"],["domain","SiteDomain"],["country","SiteCountry"]]],[[5],[["_key","ShortText"],["_nsubrecs","Int32"]],["brazil",1],["korea",1],["usa",2],["china",2],["japan",3]]]] - \ No newline at end of file + select --table Site --limit 0 --drilldown country --drilldown_sortby _nsubrecs + # [ + # [ + # 0, + # 1336611853.14965, + # 0.000450611114501953 + # ], + # [ + # [ + # [ + # 9 + # ], + # [ + # [ + # "_id", + # "UInt32" + # ], + # [ + # "_key", + # "ShortText" + # ], + # [ + # "country", + # "SiteCountry" + # ], + # [ + # "domain", + # "SiteDomain" + # ], + # [ + # "link", + # "Site" + # ], + # [ + # "links", + # "Site" + # ], + # [ + # "location", + # "WGS84GeoPoint" + # ], + # [ + # "title", + # "ShortText" + # ] + # ] + # ], + # [ + # [ + # 5 + # ], + # [ + # [ + # "_key", + # "ShortText" + # ], + # [ + # "_nsubrecs", + # "Int32" + # ] + # ], + # [ + # "brazil", + # 1 + # ], + # [ + # "korea", + # 1 + # ], + # [ + # "usa", + # 2 + # ], + # [ + # "china", + # 2 + # ], + # [ + # "japan", + # 3 + # ] + # ] + # ] + # ] Modified: doc/source/example/tutorial/drilldown-6.log (+72 -3) =================================================================== --- doc/source/example/tutorial/drilldown-6.log 2012-05-10 10:12:32 +0900 (d79a79d) +++ doc/source/example/tutorial/drilldown-6.log 2012-05-10 10:14:06 +0900 (002d798) @@ -1,5 +1,74 @@ Execution example:: - > select --table Site --limit 0 --drilldown country --drilldown_sortby _nsubrecs --drilldown_limit 2 --drilldown_offset 2 - [[0,1317212755.29988,0.000237191],[[[9],[["_id","UInt32"],["_key","ShortText"],["title","ShortText"],["location","WGS84GeoPoint"],["links","Site"],["link","Site"],["domain","SiteDomain"],["country","SiteCountry"]]],[[5],[["_key","ShortText"],["_nsubrecs","Int32"]],["usa",2],["china",2]]]] - \ No newline at end of file + select --table Site --limit 0 --drilldown country --drilldown_sortby _nsubrecs --drilldown_limit 2 --drilldown_offset 2 + # [ + # [ + # 0, + # 1336611853.35361, + # 0.000497102737426758 + # ], + # [ + # [ + # [ + # 9 + # ], + # [ + # [ + # "_id", + # "UInt32" + # ], + # [ + # "_key", + # "ShortText" + # ], + # [ + # "country", + # "SiteCountry" + # ], + # [ + # "domain", + # "SiteDomain" + # ], + # [ + # "link", + # "Site" + # ], + # [ + # "links", + # "Site" + # ], + # [ + # "location", + # "WGS84GeoPoint" + # ], + # [ + # "title", + # "ShortText" + # ] + # ] + # ], + # [ + # [ + # 5 + # ], + # [ + # [ + # "_key", + # "ShortText" + # ], + # [ + # "_nsubrecs", + # "Int32" + # ] + # ], + # [ + # "usa", + # 2 + # ], + # [ + # "china", + # 2 + # ] + # ] + # ] + # ] Modified: doc/source/example/tutorial/index-1.log (+6 -6) =================================================================== --- doc/source/example/tutorial/index-1.log 2012-05-10 10:12:32 +0900 (39fa09a) +++ doc/source/example/tutorial/index-1.log 2012-05-10 10:14:06 +0900 (0faa537) @@ -1,15 +1,15 @@ Execution example:: table_create --name Video --flags TABLE_HASH_KEY --key_type UInt32 - # [[0,1336468408.59485,0.000248908996582031],true] + # [[0,1336611834.01058,0.000293254852294922],true] table_create --name Tag --flags TABLE_HASH_KEY --key_type ShortText - # [[0,1336468408.79565,0.000237226486206055],true] + # [[0,1336611834.21159,0.000316381454467773],true] column_create --table Video --name title --flags COLUMN_SCALAR --type ShortText - # [[0,1336468408.9964,0.000552892684936523],true] + # [[0,1336611834.4127,0.000793695449829102],true] column_create --table Video --name tags --flags COLUMN_VECTOR --type Tag - # [[0,1336468409.19748,0.000529050827026367],true] + # [[0,1336611834.61425,0.000461101531982422],true] column_create --table Tag --name index_tags --flags COLUMN_INDEX --type Video --source tags - # [[0,1336468409.39853,0.00356459617614746],true] + # [[0,1336611834.81527,0.00487780570983887],true] load --table Video [ {"_key":1,"title":"Soccer 2010","tags":["Sports","Soccer"]}, @@ -21,4 +21,4 @@ Execution example:: {"_key":7,"title":"Draw 8 Month","tags":["Animation","Raccoon"]}, {"_key":8,"title":"K.O.","tags":["Animation","Music"]} ] - # [[0,1336468409.60264,0.201507091522217],8] + # [[0,1336611835.02103,0.20155143737793],8] Modified: doc/source/example/tutorial/index-2.log (+6 -6) =================================================================== --- doc/source/example/tutorial/index-2.log 2012-05-10 10:12:32 +0900 (ae929aa) +++ doc/source/example/tutorial/index-2.log 2012-05-10 10:14:06 +0900 (6efbec7) @@ -4,8 +4,8 @@ Execution example:: # [ # [ # 0, - # 1336468410.00491, - # 0.000417709350585938 + # 1336611835.42384, + # 0.000788211822509766 # ], # [ # [ @@ -37,8 +37,8 @@ Execution example:: # [ # [ # 0, - # 1336468410.20624, - # 0.000339508056640625 + # 1336611835.62658, + # 0.000372886657714844 # ], # [ # [ @@ -70,8 +70,8 @@ Execution example:: # [ # [ # 0, - # 1336468410.40778, - # 0.00030517578125 + # 1336611835.82812, + # 0.000413179397583008 # ], # [ # [ Modified: doc/source/example/tutorial/index-3.log (+5 -5) =================================================================== --- doc/source/example/tutorial/index-3.log 2012-05-10 10:12:32 +0900 (264d207) +++ doc/source/example/tutorial/index-3.log 2012-05-10 10:14:06 +0900 (4b97670) @@ -1,13 +1,13 @@ Execution example:: table_create --name User --flags TABLE_HASH_KEY --key_type ShortText - # [[0,1336468410.61002,0.000179052352905273],true] + # [[0,1336611836.03182,0.000157833099365234],true] column_create --table User --name username --flags COLUMN_SCALAR --type ShortText - # [[0,1336468410.81085,0.000480890274047852],true] + # [[0,1336611836.23282,0.000749349594116211],true] column_create --table User --name friends --flags COLUMN_VECTOR --type User - # [[0,1336468411.01181,0.000520944595336914],true] + # [[0,1336611836.43435,0.000875711441040039],true] column_create --table User --name index_friends --flags COLUMN_INDEX --type User --source friends - # [[0,1336468411.21288,0.00342512130737305],true] + # [[0,1336611836.63601,0.00509786605834961],true] load --table User [ {"_key":"ken","username":"健作","friends":["taro","jiro","tomo","moritapo"]} @@ -17,4 +17,4 @@ Execution example:: {"_key":"tomo","username":"トモちゃん","friends":["ken","hana"]} {"_key":"hana","username":"花子","friends":["ken","taro","jiro","moritapo","tomo"]} ] - # [[0,1336468411.41682,0.201314687728882],6] + # [[0,1336611836.84189,0.201859712600708],6] Modified: doc/source/example/tutorial/index-4.log (+4 -4) =================================================================== --- doc/source/example/tutorial/index-4.log 2012-05-10 10:12:32 +0900 (630de4f) +++ doc/source/example/tutorial/index-4.log 2012-05-10 10:14:06 +0900 (c0236cc) @@ -4,8 +4,8 @@ Execution example:: # [ # [ # 0, - # 1336468411.81889, - # 0.000313997268676758 + # 1336611837.24505, + # 0.000468969345092773 # ], # [ # [ @@ -49,8 +49,8 @@ Execution example:: # [ # [ # 0, - # 1336468412.0203, - # 0.000349998474121094 + # 1336611837.44797, + # 0.000360012054443359 # ], # [ # [ Modified: doc/source/example/tutorial/index-5.log (+2 -2) =================================================================== --- doc/source/example/tutorial/index-5.log 2012-05-10 10:12:32 +0900 (958741d) +++ doc/source/example/tutorial/index-5.log 2012-05-10 10:14:06 +0900 (54d993d) @@ -4,8 +4,8 @@ Execution example:: # [ # [ # 0, - # 1336468412.22189, - # 0.000318527221679688 + # 1336611837.6504, + # 0.000432491302490234 # ], # [ # [ Modified: doc/source/example/tutorial/index-6.log (+5 -5) =================================================================== --- doc/source/example/tutorial/index-6.log 2012-05-10 10:12:32 +0900 (653eea5) +++ doc/source/example/tutorial/index-6.log 2012-05-10 10:14:06 +0900 (6194fba) @@ -1,21 +1,21 @@ Execution example:: table_create --name GeoIndex --flags TABLE_PAT_KEY --key_type WGS84GeoPoint - # [[0,1336468412.42386,0.000223398208618164],true] + # [[0,1336611837.8527,0.000306844711303711],true] column_create --table GeoIndex --name index_point --type Site --flags COLUMN_INDEX --source location - # [[0,1336468412.62459,0.00424361228942871],true] + # [[0,1336611838.05388,0.00336003303527832],true] load --table Site [ {"_key":"http://example.org/","location":"128452975x503157902"}, {"_key":"http://example.net/","location":"128487316x502920929"} ] - # [[0,1336468412.82931,0.200539588928223],2] + # [[0,1336611838.25812,0.200433015823364],2] select --table Site --filter 'geo_in_circle(location, "128515259x503187188", 5000)' --output_columns _key,location # [ # [ # 0, - # 1336468413.2306, - # 0.000440359115600586 + # 1336611838.6591, + # 0.000338315963745117 # ], # [ # [ Modified: doc/source/example/tutorial/index-7.log (+2 -2) =================================================================== --- doc/source/example/tutorial/index-7.log 2012-05-10 10:12:32 +0900 (25ce10b) +++ doc/source/example/tutorial/index-7.log 2012-05-10 10:14:06 +0900 (73cfd51) @@ -4,8 +4,8 @@ Execution example:: # [ # [ # 0, - # 1336468413.43257, - # 0.000459194183349609 + # 1336611838.86067, + # 0.000425577163696289 # ], # [ # [ Modified: doc/source/example/tutorial/introduction-1.log (+1 -1) =================================================================== --- doc/source/example/tutorial/introduction-1.log 2012-05-10 10:12:32 +0900 (7d410ea) +++ doc/source/example/tutorial/introduction-1.log 2012-05-10 10:14:06 +0900 (463e24b) @@ -1,4 +1,4 @@ Execution example:: - % groonga -n /tmp/groonga-databases/introduction.db +% groonga -n /tmp/groonga-databases/introduction.db \ No newline at end of file Modified: doc/source/example/tutorial/introduction-10.log (+17 -3) =================================================================== --- doc/source/example/tutorial/introduction-10.log 2012-05-10 10:12:32 +0900 (a1f6a0e) +++ doc/source/example/tutorial/introduction-10.log 2012-05-10 10:14:06 +0900 (ae2de71) @@ -1,5 +1,19 @@ Execution example:: - > table_create --name Terms --flags TABLE_PAT_KEY|KEY_NORMALIZE --key_type ShortText --default_tokenizer TokenBigram - [[0,1332484902.52532,0.00777173042297363],true] - \ No newline at end of file + table_create --name Terms --flags TABLE_PAT_KEY|KEY_NORMALIZE --key_type ShortText --default_tokenizer TokenBigram + # [ + # [ + # -22, + # 1336611843.18913, + # 0.000519990921020508, + # "already used name was assigned: <Terms>", + # [ + # [ + # "grn_obj_register", + # "db.c", + # 6572 + # ] + # ] + # ], + # false + # ] Modified: doc/source/example/tutorial/introduction-11.log (+17 -3) =================================================================== --- doc/source/example/tutorial/introduction-11.log 2012-05-10 10:12:32 +0900 (fc3b1d9) +++ doc/source/example/tutorial/introduction-11.log 2012-05-10 10:14:06 +0900 (f7db3c4) @@ -1,5 +1,19 @@ Execution example:: - > column_create --table Terms --name blog_title --flags COLUMN_INDEX|WITH_POSITION --type Site --source title - [[0,1332484902.73511,0.0202178955078125],true] - \ No newline at end of file + column_create --table Terms --name blog_title --flags COLUMN_INDEX|WITH_POSITION --type Site --source title + # [ + # [ + # -22, + # 1336611843.39162, + # 0.000575065612792969, + # "already used name was assigned: <Terms.blog_title>", + # [ + # [ + # "grn_obj_register", + # "db.c", + # 6572 + # ] + # ] + # ], + # false + # ] Modified: doc/source/example/tutorial/introduction-12.log (+63 -3) =================================================================== --- doc/source/example/tutorial/introduction-12.log 2012-05-10 10:12:32 +0900 (9eac0ec) +++ doc/source/example/tutorial/introduction-12.log 2012-05-10 10:14:06 +0900 (35b78ca) @@ -1,5 +1,65 @@ Execution example:: - > select --table Site --query title:@this - [[0,1332484902.95678,0.000878334045410156],[[[1],[["_id","UInt32"],["_key","ShortText"],["title","ShortText"]],[1,"http://example.org/","This is test record 1!"]]]] - \ No newline at end of file + select --table Site --query title:@this + # [ + # [ + # 0, + # 1336611843.59405, + # 0.000802278518676758 + # ], + # [ + # [ + # [ + # 1 + # ], + # [ + # [ + # "_id", + # "UInt32" + # ], + # [ + # "_key", + # "ShortText" + # ], + # [ + # "country", + # "SiteCountry" + # ], + # [ + # "domain", + # "SiteDomain" + # ], + # [ + # "link", + # "Site" + # ], + # [ + # "links", + # "Site" + # ], + # [ + # "location", + # "WGS84GeoPoint" + # ], + # [ + # "title", + # "ShortText" + # ] + # ], + # [ + # 1, + # "http://example.org/", + # "japan", + # ".org", + # "http://example.net/", + # [ + # "http://example.net/", + # "http://example.org/", + # "http://example.com/" + # ], + # "128452975x503157902", + # "This is test record 1!" + # ] + # ] + # ] + # ] Modified: doc/source/example/tutorial/introduction-13.log (+63 -3) =================================================================== --- doc/source/example/tutorial/introduction-13.log 2012-05-10 10:12:32 +0900 (e0c485b) +++ doc/source/example/tutorial/introduction-13.log 2012-05-10 10:14:06 +0900 (d150bc2) @@ -1,5 +1,65 @@ Execution example:: - > select --table Site --match_columns title --query this - [[0,1332484903.16096,0.000757932662963867],[[[1],[["_id","UInt32"],["_key","ShortText"],["title","ShortText"]],[1,"http://example.org/","This is test record 1!"]]]] - \ No newline at end of file + select --table Site --match_columns title --query this + # [ + # [ + # 0, + # 1336611843.79923, + # 0.000676631927490234 + # ], + # [ + # [ + # [ + # 1 + # ], + # [ + # [ + # "_id", + # "UInt32" + # ], + # [ + # "_key", + # "ShortText" + # ], + # [ + # "country", + # "SiteCountry" + # ], + # [ + # "domain", + # "SiteDomain" + # ], + # [ + # "link", + # "Site" + # ], + # [ + # "links", + # "Site" + # ], + # [ + # "location", + # "WGS84GeoPoint" + # ], + # [ + # "title", + # "ShortText" + # ] + # ], + # [ + # 1, + # "http://example.org/", + # "japan", + # ".org", + # "http://example.net/", + # [ + # "http://example.net/", + # "http://example.org/", + # "http://example.com/" + # ], + # "128452975x503157902", + # "This is test record 1!" + # ] + # ] + # ] + # ] Modified: doc/source/example/tutorial/introduction-14.log (+74 -3) =================================================================== --- doc/source/example/tutorial/introduction-14.log 2012-05-10 10:12:32 +0900 (d24193c) +++ doc/source/example/tutorial/introduction-14.log 2012-05-10 10:14:06 +0900 (9ba5617) @@ -1,5 +1,76 @@ Execution example:: - > select --table Site --output_columns _key,title,_score --query title:@test - [[0,1332484903.36506,0.000709056854248047],[[[9],[["_key","ShortText"],["title","ShortText"],["_score","Int32"]],["http://example.org/","This is test record 1!",1],["http://example.net/","test record 2.",1],["http://example.com/","test test record three.",2],["http://example.net/afr","test record four.",1],["http://example.org/aba","test test test record five.",3],["http://example.com/rab","test test test test record six.",4],["http://example.net/atv","test test test record seven.",3],["http://example.org/gat","test test record eight.",2],["http://example.com/vdw","test test record nine.",2]]]] - \ No newline at end of file + select --table Site --output_columns _key,title,_score --query title:@test + # [ + # [ + # 0, + # 1336611844.00422, + # 0.000320196151733398 + # ], + # [ + # [ + # [ + # 9 + # ], + # [ + # [ + # "_key", + # "ShortText" + # ], + # [ + # "title", + # "ShortText" + # ], + # [ + # "_score", + # "Int32" + # ] + # ], + # [ + # "http://example.org/", + # "This is test record 1!", + # 1 + # ], + # [ + # "http://example.net/", + # "test record 2.", + # 1 + # ], + # [ + # "http://example.com/", + # "test test record three.", + # 2 + # ], + # [ + # "http://example.net/afr", + # "test record four.", + # 1 + # ], + # [ + # "http://example.org/aba", + # "test test test record five.", + # 3 + # ], + # [ + # "http://example.com/rab", + # "test test test test record six.", + # 4 + # ], + # [ + # "http://example.net/atv", + # "test test test record seven.", + # 3 + # ], + # [ + # "http://example.org/gat", + # "test test record eight.", + # 2 + # ], + # [ + # "http://example.com/vdw", + # "test test record nine.", + # 2 + # ] + # ] + # ] + # ] Modified: doc/source/example/tutorial/introduction-15.log (+231 -7) =================================================================== --- doc/source/example/tutorial/introduction-15.log 2012-05-10 10:12:32 +0900 (b8a955f) +++ doc/source/example/tutorial/introduction-15.log 2012-05-10 10:14:06 +0900 (af66636) @@ -1,9 +1,233 @@ Execution example:: - > select --table Site --offset 0 --limit 3 - [[0,1332484903.57505,0.000303268432617188],[[[9],[["_id","UInt32"],["_key","ShortText"],["title","ShortText"]],[1,"http://example.org/","This is test record 1!"],[2,"http://example.net/","test record 2."],[3,"http://example.com/","test test record three."]]]] - > select --table Site --offset 3 --limit 3 - [[0,1332484903.77936,0.000320196151733398],[[[9],[["_id","UInt32"],["_key","ShortText"],["title","ShortText"]],[4,"http://example.net/afr","test record four."],[5,"http://example.org/aba","test test test record five."],[6,"http://example.com/rab","test test test test record six."]]]] - > select --table Site --offset 7 --limit 3 - [[0,1332484903.98409,0.000294685363769531],[[[9],[["_id","UInt32"],["_key","ShortText"],["title","ShortText"]],[8,"http://example.org/gat","test test record eight."],[9,"http://example.com/vdw","test test record nine."]]]] - \ No newline at end of file + select --table Site --offset 0 --limit 3 + # [ + # [ + # 0, + # 1336611844.20698, + # 0.00018000602722168 + # ], + # [ + # [ + # [ + # 9 + # ], + # [ + # [ + # "_id", + # "UInt32" + # ], + # [ + # "_key", + # "ShortText" + # ], + # [ + # "country", + # "SiteCountry" + # ], + # [ + # "domain", + # "SiteDomain" + # ], + # [ + # "link", + # "Site" + # ], + # [ + # "links", + # "Site" + # ], + # [ + # "location", + # "WGS84GeoPoint" + # ], + # [ + # "title", + # "ShortText" + # ] + # ], + # [ + # 1, + # "http://example.org/", + # "japan", + # ".org", + # "http://example.net/", + # [ + # "http://example.net/", + # "http://example.org/", + # "http://example.com/" + # ], + # "128452975x503157902", + # "This is test record 1!" + # ], + # [ + # 2, + # "http://example.net/", + # "brazil", + # ".net", + # "", + # [], + # "128487316x502920929", + # "test record 2." + # ], + # [ + # 3, + # "http://example.com/", + # "japan", + # ".com", + # "", + # [], + # "0x0", + # "test test record three." + # ] + # ] + # ] + # ] + select --table Site --offset 3 --limit 3 + # [ + # [ + # 0, + # 1336611844.40931, + # 0.000249385833740234 + # ], + # [ + # [ + # [ + # 9 + # ], + # [ + # [ + # "_id", + # "UInt32" + # ], + # [ + # "_key", + # "ShortText" + # ], + # [ + # "country", + # "SiteCountry" + # ], + # [ + # "domain", + # "SiteDomain" + # ], + # [ + # "link", + # "Site" + # ], + # [ + # "links", + # "Site" + # ], + # [ + # "location", + # "WGS84GeoPoint" + # ], + # [ + # "title", + # "ShortText" + # ] + # ], + # [ + # 4, + # "http://example.net/afr", + # "usa", + # ".net", + # "", + # [], + # "0x0", + # "test record four." + # ], + # [ + # 5, + # "http://example.org/aba", + # "korea", + # ".org", + # "", + # [], + # "0x0", + # "test test test record five." + # ], + # [ + # 6, + # "http://example.com/rab", + # "china", + # ".com", + # "", + # [], + # "0x0", + # "test test test test record six." + # ] + # ] + # ] + # ] + select --table Site --offset 7 --limit 3 + # [ + # [ + # 0, + # 1336611844.61372, + # 0.000185012817382812 + # ], + # [ + # [ + # [ + # 9 + # ], + # [ + # [ + # "_id", + # "UInt32" + # ], + # [ + # "_key", + # "ShortText" + # ], + # [ + # "country", + # "SiteCountry" + # ], + # [ + # "domain", + # "SiteDomain" + # ], + # [ + # "link", + # "Site" + # ], + # [ + # "links", + # "Site" + # ], + # [ + # "location", + # "WGS84GeoPoint" + # ], + # [ + # "title", + # "ShortText" + # ] + # ], + # [ + # 8, + # "http://example.org/gat", + # "usa", + # ".org", + # "", + # [], + # "0x0", + # "test test record eight." + # ], + # [ + # 9, + # "http://example.com/vdw", + # "japan", + # ".com", + # "", + # [], + # "0x0", + # "test test record nine." + # ] + # ] + # ] + # ] Modified: doc/source/example/tutorial/introduction-16.log (+143 -3) =================================================================== --- doc/source/example/tutorial/introduction-16.log 2012-05-10 10:12:32 +0900 (03fda64) +++ doc/source/example/tutorial/introduction-16.log 2012-05-10 10:14:06 +0900 (92db466) @@ -1,5 +1,145 @@ Execution example:: - > select --table Site --sortby -_id - [[0,1332484904.18805,0.000293493270874023],[[[9],[["_id","UInt32"],["_key","ShortText"],["title","ShortText"]],[9,"http://example.com/vdw","test test record nine."],[8,"http://example.org/gat","test test record eight."],[7,"http://example.net/atv","test test test record seven."],[6,"http://example.com/rab","test test test test record six."],[5,"http://example.org/aba","test test test record five."],[4,"http://example.net/afr","test record four."],[3,"http://example.com/","test test record three."],[2,"http://example.net/","test record 2."],[1,"http://example.org/","This is test record 1!"]]]] - \ No newline at end of file + select --table Site --sortby -_id + # [ + # [ + # 0, + # 1336611844.81692, + # 0.000475645065307617 + # ], + # [ + # [ + # [ + # 9 + # ], + # [ + # [ + # "_id", + # "UInt32" + # ], + # [ + # "_key", + # "ShortText" + # ], + # [ + # "country", + # "SiteCountry" + # ], + # [ + # "domain", + # "SiteDomain" + # ], + # [ + # "link", + # "Site" + # ], + # [ + # "links", + # "Site" + # ], + # [ + # "location", + # "WGS84GeoPoint" + # ], + # [ + # "title", + # "ShortText" + # ] + # ], + # [ + # 9, + # "http://example.com/vdw", + # "japan", + # ".com", + # "", + # [], + # "0x0", + # "test test record nine." + # ], + # [ + # 8, + # "http://example.org/gat", + # "usa", + # ".org", + # "", + # [], + # "0x0", + # "test test record eight." + # ], + # [ + # 7, + # "http://example.net/atv", + # "china", + # ".net", + # "", + # [], + # "0x0", + # "test test test record seven." + # ], + # [ + # 6, + # "http://example.com/rab", + # "china", + # ".com", + # "", + # [], + # "0x0", + # "test test test test record six." + # ], + # [ + # 5, + # "http://example.org/aba", + # "korea", + # ".org", + # "", + # [], + # "0x0", + # "test test test record five." + # ], + # [ + # 4, + # "http://example.net/afr", + # "usa", + # ".net", + # "", + # [], + # "0x0", + # "test record four." + # ], + # [ + # 3, + # "http://example.com/", + # "japan", + # ".com", + # "", + # [], + # "0x0", + # "test test record three." + # ], + # [ + # 2, + # "http://example.net/", + # "brazil", + # ".net", + # "", + # [], + # "128487316x502920929", + # "test record 2." + # ], + # [ + # 1, + # "http://example.org/", + # "japan", + # ".org", + # "http://example.net/", + # [ + # "http://example.net/", + # "http://example.org/", + # "http://example.com/" + # ], + # "128452975x503157902", + # "This is test record 1!" + # ] + # ] + # ] + # ] Modified: doc/source/example/tutorial/introduction-17.log (+74 -3) =================================================================== --- doc/source/example/tutorial/introduction-17.log 2012-05-10 10:12:32 +0900 (c0b51bb) +++ doc/source/example/tutorial/introduction-17.log 2012-05-10 10:14:06 +0900 (9d4dbd6) @@ -1,5 +1,76 @@ Execution example:: - > select --table Site --query title:@test --output_columns _id,_score,title --sortby -_score - [[0,1332484904.39402,0.000802755355834961],[[[9],[["_id","UInt32"],["_score","Int32"],["title","ShortText"]],[6,4,"test test test test record six."],[5,3,"test test test record five."],[7,3,"test test test record seven."],[8,2,"test test record eight."],[3,2,"test test record three."],[9,2,"test test record nine."],[1,1,"This is test record 1!"],[4,1,"test record four."],[2,1,"test record 2."]]]] - \ No newline at end of file + select --table Site --query title:@test --output_columns _id,_score,title --sortby -_score + # [ + # [ + # 0, + # 1336611845.02591, + # 0.000528573989868164 + # ], + # [ + # [ + # [ + # 9 + # ], + # [ + # [ + # "_id", + # "UInt32" + # ], + # [ + # "_score", + # "Int32" + # ], + # [ + # "title", + # "ShortText" + # ] + # ], + # [ + # 6, + # 4, + # "test test test test record six." + # ], + # [ + # 5, + # 3, + # "test test test record five." + # ], + # [ + # 7, + # 3, + # "test test test record seven." + # ], + # [ + # 8, + # 2, + # "test test record eight." + # ], + # [ + # 3, + # 2, + # "test test record three." + # ], + # [ + # 9, + # 2, + # "test test record nine." + # ], + # [ + # 1, + # 1, + # "This is test record 1!" + # ], + # [ + # 4, + # 1, + # "test record four." + # ], + # [ + # 2, + # 1, + # "test record 2." + # ] + # ] + # ] + # ] Modified: doc/source/example/tutorial/introduction-18.log (+74 -3) =================================================================== --- doc/source/example/tutorial/introduction-18.log 2012-05-10 10:12:32 +0900 (5481c94) +++ doc/source/example/tutorial/introduction-18.log 2012-05-10 10:14:06 +0900 (e99c05a) @@ -1,5 +1,76 @@ Execution example:: - > select --table Site --query title:@test --output_columns _id,_score,title --sortby -_score,_id - [[0,1332484904.60132,0.000498056411743164],[[[9],[["_id","UInt32"],["_score","Int32"],["title","ShortText"]],[6,4,"test test test test record six."],[5,3,"test test test record five."],[7,3,"test test test record seven."],[3,2,"test test record three."],[8,2,"test test record eight."],[9,2,"test test record nine."],[1,1,"This is test record 1!"],[2,1,"test record 2."],[4,1,"test record four."]]]] - \ No newline at end of file + select --table Site --query title:@test --output_columns _id,_score,title --sortby -_score,_id + # [ + # [ + # 0, + # 1336611845.23052, + # 0.00045466423034668 + # ], + # [ + # [ + # [ + # 9 + # ], + # [ + # [ + # "_id", + # "UInt32" + # ], + # [ + # "_score", + # "Int32" + # ], + # [ + # "title", + # "ShortText" + # ] + # ], + # [ + # 6, + # 4, + # "test test test test record six." + # ], + # [ + # 5, + # 3, + # "test test test record five." + # ], + # [ + # 7, + # 3, + # "test test test record seven." + # ], + # [ + # 3, + # 2, + # "test test record three." + # ], + # [ + # 8, + # 2, + # "test test record eight." + # ], + # [ + # 9, + # 2, + # "test test record nine." + # ], + # [ + # 1, + # 1, + # "This is test record 1!" + # ], + # [ + # 2, + # 1, + # "test record 2." + # ], + # [ + # 4, + # 1, + # "test record four." + # ] + # ] + # ] + # ] Modified: doc/source/example/tutorial/introduction-2.log (+20 -4) =================================================================== --- doc/source/example/tutorial/introduction-2.log 2012-05-10 10:12:32 +0900 (d0cc619) +++ doc/source/example/tutorial/introduction-2.log 2012-05-10 10:14:06 +0900 (dc635d2) @@ -1,6 +1,22 @@ Execution example:: - % groonga /tmp/groonga-databases/introduction.db - > status - [[0,1332484898.47079,0.000113010406494141],{"alloc_count":151,"starttime":1332484898,"uptime":0,"version":"2.0.0-250-g5a3cf19","n_queries":0,"cache_hit_rate":0.0,"command_version":1,"default_command_version":1,"max_command_version":2}] - \ No newline at end of file +% groonga /tmp/groonga-databases/introduction.db + status + # [ + # [ + # 0, + # 1336611841.14606, + # 0.000140905380249023 + # ], + # { + # "uptime": 0, + # "max_command_version": 2, + # "n_queries": 0, + # "cache_hit_rate": 0.0, + # "version": "2.0.2", + # "alloc_count": 130, + # "command_version": 1, + # "starttime": 1336611841, + # "default_command_version": 1 + # } + # ] Modified: doc/source/example/tutorial/introduction-3.log (+17 -3) =================================================================== --- doc/source/example/tutorial/introduction-3.log 2012-05-10 10:12:32 +0900 (94be828) +++ doc/source/example/tutorial/introduction-3.log 2012-05-10 10:14:06 +0900 (8b0edaf) @@ -1,5 +1,19 @@ Execution example:: - > table_create --name Site --flags TABLE_HASH_KEY --key_type ShortText - [[0,1332484898.674,0.0103404521942139],true] - \ No newline at end of file + table_create --name Site --flags TABLE_HASH_KEY --key_type ShortText + # [ + # [ + # -22, + # 1336611841.34969, + # 0.000652074813842773, + # "already used name was assigned: <Site>", + # [ + # [ + # "grn_obj_register", + # "db.c", + # 6572 + # ] + # ] + # ], + # false + # ] Modified: doc/source/example/tutorial/introduction-4.log (+143 -3) =================================================================== --- doc/source/example/tutorial/introduction-4.log 2012-05-10 10:12:32 +0900 (d93c9ed) +++ doc/source/example/tutorial/introduction-4.log 2012-05-10 10:14:06 +0900 (52cf6d9) @@ -1,5 +1,145 @@ Execution example:: - > select --table Site - [[0,1332484898.88587,0.000526189804077148],[[[0],[["_id","UInt32"],["_key","ShortText"]]]]] - \ No newline at end of file + select --table Site + # [ + # [ + # 0, + # 1336611841.5522, + # 0.000861406326293945 + # ], + # [ + # [ + # [ + # 9 + # ], + # [ + # [ + # "_id", + # "UInt32" + # ], + # [ + # "_key", + # "ShortText" + # ], + # [ + # "country", + # "SiteCountry" + # ], + # [ + # "domain", + # "SiteDomain" + # ], + # [ + # "link", + # "Site" + # ], + # [ + # "links", + # "Site" + # ], + # [ + # "location", + # "WGS84GeoPoint" + # ], + # [ + # "title", + # "ShortText" + # ] + # ], + # [ + # 1, + # "http://example.org/", + # "japan", + # ".org", + # "http://example.net/", + # [ + # "http://example.net/", + # "http://example.org/", + # "http://example.com/" + # ], + # "128452975x503157902", + # "This is test record 1!" + # ], + # [ + # 2, + # "http://example.net/", + # "brazil", + # ".net", + # "", + # [], + # "128487316x502920929", + # "test record 2." + # ], + # [ + # 3, + # "http://example.com/", + # "japan", + # ".com", + # "", + # [], + # "0x0", + # "test test record three." + # ], + # [ + # 4, + # "http://example.net/afr", + # "usa", + # ".net", + # "", + # [], + # "0x0", + # "test record four." + # ], + # [ + # 5, + # "http://example.org/aba", + # "korea", + # ".org", + # "", + # [], + # "0x0", + # "test test test record five." + # ], + # [ + # 6, + # "http://example.com/rab", + # "china", + # ".com", + # "", + # [], + # "0x0", + # "test test test test record six." + # ], + # [ + # 7, + # "http://example.net/atv", + # "china", + # ".net", + # "", + # [], + # "0x0", + # "test test test record seven." + # ], + # [ + # 8, + # "http://example.org/gat", + # "usa", + # ".org", + # "", + # [], + # "0x0", + # "test test record eight." + # ], + # [ + # 9, + # "http://example.com/vdw", + # "japan", + # ".com", + # "", + # [], + # "0x0", + # "test test record nine." + # ] + # ] + # ] + # ] Modified: doc/source/example/tutorial/introduction-5.log (+160 -5) =================================================================== --- doc/source/example/tutorial/introduction-5.log 2012-05-10 10:12:32 +0900 (29fc470) +++ doc/source/example/tutorial/introduction-5.log 2012-05-10 10:14:06 +0900 (4ff21d2) @@ -1,7 +1,162 @@ Execution example:: - > column_create --table Site --name title --type ShortText - [[0,1332484899.08879,0.00948214530944824],true] - > select --table Site - [[0,1332484899.29974,0.000299215316772461],[[[0],[["_id","UInt32"],["_key","ShortText"],["title","ShortText"]]]]] - \ No newline at end of file + column_create --table Site --name title --type ShortText + # [ + # [ + # -22, + # 1336611841.75835, + # 0.000437021255493164, + # "already used name was assigned: <Site.title>", + # [ + # [ + # "grn_obj_register", + # "db.c", + # 6572 + # ] + # ] + # ], + # false + # ] + select --table Site + # [ + # [ + # 0, + # 1336611841.96024, + # 9.918212890625e-05 + # ], + # [ + # [ + # [ + # 9 + # ], + # [ + # [ + # "_id", + # "UInt32" + # ], + # [ + # "_key", + # "ShortText" + # ], + # [ + # "country", + # "SiteCountry" + # ], + # [ + # "domain", + # "SiteDomain" + # ], + # [ + # "link", + # "Site" + # ], + # [ + # "links", + # "Site" + # ], + # [ + # "location", + # "WGS84GeoPoint" + # ], + # [ + # "title", + # "ShortText" + # ] + # ], + # [ + # 1, + # "http://example.org/", + # "japan", + # ".org", + # "http://example.net/", + # [ + # "http://example.net/", + # "http://example.org/", + # "http://example.com/" + # ], + # "128452975x503157902", + # "This is test record 1!" + # ], + # [ + # 2, + # "http://example.net/", + # "brazil", + # ".net", + # "", + # [], + # "128487316x502920929", + # "test record 2." + # ], + # [ + # 3, + # "http://example.com/", + # "japan", + # ".com", + # "", + # [], + # "0x0", + # "test test record three." + # ], + # [ + # 4, + # "http://example.net/afr", + # "usa", + # ".net", + # "", + # [], + # "0x0", + # "test record four." + # ], + # [ + # 5, + # "http://example.org/aba", + # "korea", + # ".org", + # "", + # [], + # "0x0", + # "test test test record five." + # ], + # [ + # 6, + # "http://example.com/rab", + # "china", + # ".com", + # "", + # [], + # "0x0", + # "test test test test record six." + # ], + # [ + # 7, + # "http://example.net/atv", + # "china", + # ".net", + # "", + # [], + # "0x0", + # "test test test record seven." + # ], + # [ + # 8, + # "http://example.org/gat", + # "usa", + # ".org", + # "", + # [], + # "0x0", + # "test test record eight." + # ], + # [ + # 9, + # "http://example.com/vdw", + # "japan", + # ".com", + # "", + # [], + # "0x0", + # "test test record nine." + # ] + # ] + # ] + # ] Modified: doc/source/example/tutorial/introduction-6.log (+13 -14) =================================================================== --- doc/source/example/tutorial/introduction-6.log 2012-05-10 10:12:32 +0900 (94a3c90) +++ doc/source/example/tutorial/introduction-6.log 2012-05-10 10:14:06 +0900 (c069e90) @@ -1,16 +1,15 @@ Execution example:: - > load --table Site - > [ - > {"_key":"http://example.org/","title":"This is test record 1!"}, - > {"_key":"http://example.net/","title":"test record 2."}, - > {"_key":"http://example.com/","title":"test test record three."}, - > {"_key":"http://example.net/afr","title":"test record four."}, - > {"_key":"http://example.org/aba","title":"test test test record five."}, - > {"_key":"http://example.com/rab","title":"test test test test record six."}, - > {"_key":"http://example.net/atv","title":"test test test record seven."}, - > {"_key":"http://example.org/gat","title":"test test record eight."}, - > {"_key":"http://example.com/vdw","title":"test test record nine."}, - > ] - [[0,1332484899.50234,2.20460820198059],9] - \ No newline at end of file + load --table Site + [ + {"_key":"http://example.org/","title":"This is test record 1!"}, + {"_key":"http://example.net/","title":"test record 2."}, + {"_key":"http://example.com/","title":"test test record three."}, + {"_key":"http://example.net/afr","title":"test record four."}, + {"_key":"http://example.org/aba","title":"test test test record five."}, + {"_key":"http://example.com/rab","title":"test test test test record six."}, + {"_key":"http://example.net/atv","title":"test test test record seven."}, + {"_key":"http://example.org/gat","title":"test test record eight."}, + {"_key":"http://example.com/vdw","title":"test test record nine."}, + ] + # [[0,1336611842.17065,0.200849294662476],9] Modified: doc/source/example/tutorial/introduction-7.log (+143 -3) =================================================================== --- doc/source/example/tutorial/introduction-7.log 2012-05-10 10:12:32 +0900 (ea902c1) +++ doc/source/example/tutorial/introduction-7.log 2012-05-10 10:14:06 +0900 (7bd6d7e) @@ -1,5 +1,145 @@ Execution example:: - > select --table Site - [[0,1332484901.90868,0.000381231307983398],[[[9],[["_id","UInt32"],["_key","ShortText"],["title","ShortText"]],[1,"http://example.org/","This is test record 1!"],[2,"http://example.net/","test record 2."],[3,"http://example.com/","test test record three."],[4,"http://example.net/afr","test record four."],[5,"http://example.org/aba","test test test record five."],[6,"http://example.com/rab","test test test test record six."],[7,"http://example.net/atv","test test test record seven."],[8,"http://example.org/gat","test test record eight."],[9,"http://example.com/vdw","test test record nine."]]]] - \ No newline at end of file + select --table Site + # [ + # [ + # 0, + # 1336611842.57257, + # 0.000315666198730469 + # ], + # [ + # [ + # [ + # 9 + # ], + # [ + # [ + # "_id", + # "UInt32" + # ], + # [ + # "_key", + # "ShortText" + # ], + # [ + # "country", + # "SiteCountry" + # ], + # [ + # "domain", + # "SiteDomain" + # ], + # [ + # "link", + # "Site" + # ], + # [ + # "links", + # "Site" + # ], + # [ + # "location", + # "WGS84GeoPoint" + # ], + # [ + # "title", + # "ShortText" + # ] + # ], + # [ + # 1, + # "http://example.org/", + # "japan", + # ".org", + # "http://example.net/", + # [ + # "http://example.net/", + # "http://example.org/", + # "http://example.com/" + # ], + # "128452975x503157902", + # "This is test record 1!" + # ], + # [ + # 2, + # "http://example.net/", + # "brazil", + # ".net", + # "", + # [], + # "128487316x502920929", + # "test record 2." + # ], + # [ + # 3, + # "http://example.com/", + # "japan", + # ".com", + # "", + # [], + # "0x0", + # "test test record three." + # ], + # [ + # 4, + # "http://example.net/afr", + # "usa", + # ".net", + # "", + # [], + # "0x0", + # "test record four." + # ], + # [ + # 5, + # "http://example.org/aba", + # "korea", + # ".org", + # "", + # [], + # "0x0", + # "test test test record five." + # ], + # [ + # 6, + # "http://example.com/rab", + # "china", + # ".com", + # "", + # [], + # "0x0", + # "test test test test record six." + # ], + # [ + # 7, + # "http://example.net/atv", + # "china", + # ".net", + # "", + # [], + # "0x0", + # "test test test record seven." + # ], + # [ + # 8, + # "http://example.org/gat", + # "usa", + # ".org", + # "", + # [], + # "0x0", + # "test test record eight." + # ], + # [ + # 9, + # "http://example.com/vdw", + # "japan", + # ".com", + # "", + # [], + # "0x0", + # "test test record nine." + # ] + # ] + # ] + # ] Modified: doc/source/example/tutorial/introduction-8.log (+63 -3) =================================================================== --- doc/source/example/tutorial/introduction-8.log 2012-05-10 10:12:32 +0900 (2d5acfc) +++ doc/source/example/tutorial/introduction-8.log 2012-05-10 10:14:06 +0900 (703a01d) @@ -1,5 +1,65 @@ Execution example:: - > select --table Site --query _id:1 - [[0,1332484902.11683,0.000809431076049805],[[[1],[["_id","UInt32"],["_key","ShortText"],["title","ShortText"]],[1,"http://example.org/","This is test record 1!"]]]] - \ No newline at end of file + select --table Site --query _id:1 + # [ + # [ + # 0, + # 1336611842.77874, + # 0.000614166259765625 + # ], + # [ + # [ + # [ + # 1 + # ], + # [ + # [ + # "_id", + # "UInt32" + # ], + # [ + # "_key", + # "ShortText" + # ], + # [ + # "country", + # "SiteCountry" + # ], + # [ + # "domain", + # "SiteDomain" + # ], + # [ + # "link", + # "Site" + # ], + # [ + # "links", + # "Site" + # ], + # [ + # "location", + # "WGS84GeoPoint" + # ], + # [ + # "title", + # "ShortText" + # ] + # ], + # [ + # 1, + # "http://example.org/", + # "japan", + # ".org", + # "http://example.net/", + # [ + # "http://example.net/", + # "http://example.org/", + # "http://example.com/" + # ], + # "128452975x503157902", + # "This is test record 1!" + # ] + # ] + # ] + # ] Modified: doc/source/example/tutorial/introduction-9.log (+63 -3) =================================================================== --- doc/source/example/tutorial/introduction-9.log 2012-05-10 10:12:32 +0900 (6ff0235) +++ doc/source/example/tutorial/introduction-9.log 2012-05-10 10:14:06 +0900 (f9acf49) @@ -1,5 +1,65 @@ Execution example:: - > select --table Site --query '_key:"http://example.org/"' - [[0,1332484902.32106,0.000850200653076172],[[[1],[["_id","UInt32"],["_key","ShortText"],["title","ShortText"]],[1,"http://example.org/","This is test record 1!"]]]] - \ No newline at end of file + select --table Site --query '_key:"http://example.org/"' + # [ + # [ + # 0, + # 1336611842.9839, + # 0.000544548034667969 + # ], + # [ + # [ + # [ + # 1 + # ], + # [ + # [ + # "_id", + # "UInt32" + # ], + # [ + # "_key", + # "ShortText" + # ], + # [ + # "country", + # "SiteCountry" + # ], + # [ + # "domain", + # "SiteDomain" + # ], + # [ + # "link", + # "Site" + # ], + # [ + # "links", + # "Site" + # ], + # [ + # "location", + # "WGS84GeoPoint" + # ], + # [ + # "title", + # "ShortText" + # ] + # ], + # [ + # 1, + # "http://example.org/", + # "japan", + # ".org", + # "http://example.net/", + # [ + # "http://example.net/", + # "http://example.org/", + # "http://example.com/" + # ], + # "128452975x503157902", + # "This is test record 1!" + # ] + # ] + # ] + # ] Modified: doc/source/example/tutorial/match_columns-1.log (+7 -7) =================================================================== --- doc/source/example/tutorial/match_columns-1.log 2012-05-10 10:12:32 +0900 (9061ffa) +++ doc/source/example/tutorial/match_columns-1.log 2012-05-10 10:14:06 +0900 (807b6cb) @@ -1,21 +1,21 @@ Execution example:: table_create --name Blog1 --flags TABLE_HASH_KEY --key_type ShortText - # [[0,1336468399.6861,0.000176429748535156],true] + # [[0,1336611825.0818,0.000154495239257812],true] column_create --table Blog1 --name title --flags COLUMN_SCALAR --type ShortText - # [[0,1336468399.88692,0.000572443008422852],true] + # [[0,1336611825.28257,0.000925779342651367],true] column_create --table Blog1 --name message --flags COLUMN_SCALAR --type ShortText - # [[0,1336468400.08803,0.000512361526489258],true] + # [[0,1336611825.48417,0.000760078430175781],true] table_create --name IndexBlog1 --flags TABLE_PAT_KEY|KEY_NORMALIZE --key_type ShortText --default_tokenizer TokenBigram - # [[0,1336468400.28907,0.000239133834838867],true] + # [[0,1336611825.68563,0.000369071960449219],true] column_create --table IndexBlog1 --name index_title --flags COLUMN_INDEX|WITH_POSITION --type Blog1 --source title - # [[0,1336468400.48983,0.00376629829406738],true] + # [[0,1336611825.8869,0.00517129898071289],true] column_create --table IndexBlog1 --name index_message --flags COLUMN_INDEX|WITH_POSITION --type Blog1 --source message - # [[0,1336468400.69408,0.00344538688659668],true] + # [[0,1336611826.09288,0.0058131217956543],true] load --table Blog1 [ {"_key":"grn1","title":"groonga test","message":"groonga message"}, {"_key":"grn2","title":"baseball result","message":"rakutan eggs 4 - 4 groonga moritars"}, {"_key":"grn3","title":"groonga message","message":"none"} ] - # [[0,1336468400.89804,0.202517986297607],3] + # [[0,1336611826.29967,0.202595233917236],3] Modified: doc/source/example/tutorial/match_columns-2.log (+6 -6) =================================================================== --- doc/source/example/tutorial/match_columns-2.log 2012-05-10 10:12:32 +0900 (9e81b80) +++ doc/source/example/tutorial/match_columns-2.log 2012-05-10 10:14:06 +0900 (8d12a44) @@ -4,8 +4,8 @@ Execution example:: # [ # [ # 0, - # 1336468401.3015, - # 0.000590324401855469 + # 1336611826.7034, + # 0.000846385955810547 # ], # [ # [ @@ -55,8 +55,8 @@ Execution example:: # [ # [ # 0, - # 1336468401.5036, - # 0.000405550003051758 + # 1336611826.90708, + # 0.000471830368041992 # ], # [ # [ @@ -100,8 +100,8 @@ Execution example:: # [ # [ # 0, - # 1336468401.70521, - # 0.000378131866455078 + # 1336611827.10959, + # 0.000474691390991211 # ], # [ # [ Modified: doc/source/example/tutorial/match_columns-3.log (+6 -6) =================================================================== --- doc/source/example/tutorial/match_columns-3.log 2012-05-10 10:12:32 +0900 (ea81ede) +++ doc/source/example/tutorial/match_columns-3.log 2012-05-10 10:14:06 +0900 (f3ede62) @@ -1,19 +1,19 @@ Execution example:: table_create --name Blog2 --flags TABLE_HASH_KEY --key_type ShortText - # [[0,1336468401.90693,0.000187397003173828],true] + # [[0,1336611827.31262,0.000228166580200195],true] column_create --table Blog2 --name title --flags COLUMN_SCALAR --type ShortText - # [[0,1336468402.10767,0.000550508499145508],true] + # [[0,1336611827.51363,0.000732183456420898],true] column_create --table Blog2 --name message --flags COLUMN_SCALAR --type ShortText - # [[0,1336468402.30881,0.00057530403137207],true] + # [[0,1336611827.71511,0.000954389572143555],true] table_create --name IndexBlog2 --flags TABLE_PAT_KEY|KEY_NORMALIZE --key_type ShortText --default_tokenizer TokenBigram - # [[0,1336468402.50999,0.000248193740844727],true] + # [[0,1336611827.91687,0.000237703323364258],true] column_create --table IndexBlog2 --name index_blog --flags COLUMN_INDEX|WITH_POSITION|WITH_SECTION --type Blog2 --source title,message - # [[0,1336468402.71084,0.00389933586120605],true] + # [[0,1336611828.11779,0.00291132926940918],true] load --table Blog2 [ {"_key":"grn1","title":"groonga test","message":"groonga message"}, {"_key":"grn2","title":"baseball result","message":"rakutan eggs 4 - 4 groonga moritars"}, {"_key":"grn3","title":"groonga message","message":"none"} ] - # [[0,1336468402.91537,0.201383829116821],3] + # [[0,1336611828.32151,0.201633453369141],3] Modified: doc/source/example/tutorial/match_columns-4.log (+6 -6) =================================================================== --- doc/source/example/tutorial/match_columns-4.log 2012-05-10 10:12:32 +0900 (6556fac) +++ doc/source/example/tutorial/match_columns-4.log 2012-05-10 10:14:06 +0900 (84d312e) @@ -4,8 +4,8 @@ Execution example:: # [ # [ # 0, - # 1336468403.31753, - # 0.000391006469726562 + # 1336611828.72544, + # 0.000603675842285156 # ], # [ # [ @@ -55,8 +55,8 @@ Execution example:: # [ # [ # 0, - # 1336468403.51936, - # 0.00037837028503418 + # 1336611828.92891, + # 0.000412225723266602 # ], # [ # [ @@ -100,8 +100,8 @@ Execution example:: # [ # [ # 0, - # 1336468403.72081, - # 0.000359535217285156 + # 1336611829.13139, + # 0.000463962554931641 # ], # [ # [ Modified: doc/source/example/tutorial/micro_blog-1.log (+26 -26) =================================================================== --- doc/source/example/tutorial/micro_blog-1.log 2012-05-10 10:12:32 +0900 (8df8e9e) +++ doc/source/example/tutorial/micro_blog-1.log 2012-05-10 10:14:06 +0900 (7154b17) @@ -1,35 +1,35 @@ Execution example:: select --table Users --match_columns name,location_str,description --query 東京 --output_columns _key,name - # [[0,1336468413.65365,0.000164031982421875],true] - # [[0,1336468413.65387,0.000146865844726562],true] - # [[0,1336468413.65403,0.000139474868774414],true] - # [[0,1336468413.65418,0.000150680541992188],true] - # [[0,1336468413.65435,0.000566482543945312],true] - # [[0,1336468413.65515,0.000523567199707031],true] - # [[0,1336468413.65569,0.000493526458740234],true] - # [[0,1336468413.65619,0.000108957290649414],true] - # [[0,1336468413.65632,0.000498056411743164],true] - # [[0,1336468413.65683,0.00047755241394043],true] - # [[0,1336468413.65732,0.00335407257080078],true] - # [[0,1336468413.6607,0.000487565994262695],true] - # [[0,1336468413.6612,9.20295715332031e-05],true] - # [[0,1336468413.66132,8.46385955810547e-05],true] - # [[0,1336468413.66141,0.000533342361450195],true] - # [[0,1336468413.66215,0.000516414642333984],true] - # [[0,1336468413.66289,9.79900360107422e-05],true] - # [[0,1336468413.66321,8.32080841064453e-05],true] - # [[0,1336468413.66352,0.0038611888885498],true] - # [[0,1336468413.66749,0.00368213653564453],true] - # [[0,1336468413.67146,0.00414204597473145],true] - # [[0,1336468413.6759,0.00406765937805176],true] - # [[0,1336468413.68002,0.00325989723205566],3] - # [[0,1336468413.68367,0.00261378288269043],8] + # [[0,1336611839.07118,0.000281333923339844],true] + # [[0,1336611839.07154,0.000112056732177734],true] + # [[0,1336611839.07166,0.000104904174804688],true] + # [[0,1336611839.07178,0.000121831893920898],true] + # [[0,1336611839.07194,0.000499248504638672],true] + # [[0,1336611839.0727,0.000520229339599609],true] + # [[0,1336611839.07324,0.000482082366943359],true] + # [[0,1336611839.07395,8.41617584228516e-05],true] + # [[0,1336611839.07426,0.000544309616088867],true] + # [[0,1336611839.07504,0.00052952766418457],true] + # [[0,1336611839.07581,0.003662109375],true] + # [[0,1336611839.07977,0.000470876693725586],true] + # [[0,1336611839.08025,6.84261322021484e-05],true] + # [[0,1336611839.08033,5.7220458984375e-05],true] + # [[0,1336611839.0804,0.000474929809570312],true] + # [[0,1336611839.08089,0.00048828125],true] + # [[0,1336611839.0814,7.51018524169922e-05],true] + # [[0,1336611839.08149,5.76972961425781e-05],true] + # [[0,1336611839.08155,0.00359082221984863],true] + # [[0,1336611839.08519,0.00360488891601562],true] + # [[0,1336611839.08884,0.00371098518371582],true] + # [[0,1336611839.09259,0.00375628471374512],true] + # [[0,1336611839.09671,0.00286769866943359],3] + # [[0,1336611839.09987,0.00216031074523926],8] # [ # [ # 0, - # 1336468413.6863, - # 0.000454187393188477 + # 1336611839.10206, + # 0.000345468521118164 # ], # [ # [ Modified: doc/source/example/tutorial/micro_blog-10.log (+2 -2) =================================================================== --- doc/source/example/tutorial/micro_blog-10.log 2012-05-10 10:12:32 +0900 (c96b1e7) +++ doc/source/example/tutorial/micro_blog-10.log 2012-05-10 10:14:06 +0900 (9b82c5e) @@ -4,8 +4,8 @@ Execution example:: # [ # [ # 0, - # 1336468415.50436, - # 0.000488042831420898 + # 1336611840.93257, + # 0.000453948974609375 # ], # [ # [ Modified: doc/source/example/tutorial/micro_blog-2.log (+2 -2) =================================================================== --- doc/source/example/tutorial/micro_blog-2.log 2012-05-10 10:12:32 +0900 (7ea3b22) +++ doc/source/example/tutorial/micro_blog-2.log 2012-05-10 10:14:06 +0900 (abac142) @@ -4,8 +4,8 @@ Execution example:: # [ # [ # 0, - # 1336468413.88813, - # 0.000306844711303711 + # 1336611839.30384, + # 0.000298023223876953 # ], # [ # [ Modified: doc/source/example/tutorial/micro_blog-3.log (+2 -2) =================================================================== --- doc/source/example/tutorial/micro_blog-3.log 2012-05-10 10:12:32 +0900 (572fe6c) +++ doc/source/example/tutorial/micro_blog-3.log 2012-05-10 10:14:06 +0900 (d781796) @@ -4,8 +4,8 @@ Execution example:: # [ # [ # 0, - # 1336468414.08964, - # 0.000273466110229492 + # 1336611839.50564, + # 0.000256776809692383 # ], # [ # [ Modified: doc/source/example/tutorial/micro_blog-4.log (+2 -2) =================================================================== --- doc/source/example/tutorial/micro_blog-4.log 2012-05-10 10:12:32 +0900 (1192b13) +++ doc/source/example/tutorial/micro_blog-4.log 2012-05-10 10:14:06 +0900 (90107f2) @@ -4,8 +4,8 @@ Execution example:: # [ # [ # 0, - # 1336468414.29108, - # 0.000583171844482422 + # 1336611839.70805, + # 0.000712156295776367 # ], # [ # [ Modified: doc/source/example/tutorial/micro_blog-5.log (+2 -2) =================================================================== --- doc/source/example/tutorial/micro_blog-5.log 2012-05-10 10:12:32 +0900 (c33b134) +++ doc/source/example/tutorial/micro_blog-5.log 2012-05-10 10:14:06 +0900 (d50d61e) @@ -4,8 +4,8 @@ Execution example:: # [ # [ # 0, - # 1336468414.49473, - # 0.000291824340820312 + # 1336611839.91469, + # 0.000325918197631836 # ], # [ # [ Modified: doc/source/example/tutorial/micro_blog-6.log (+2 -2) =================================================================== --- doc/source/example/tutorial/micro_blog-6.log 2012-05-10 10:12:32 +0900 (e3f0579) +++ doc/source/example/tutorial/micro_blog-6.log 2012-05-10 10:14:06 +0900 (622e6f5) @@ -4,8 +4,8 @@ Execution example:: # [ # [ # 0, - # 1336468414.69623, - # 0.000463008880615234 + # 1336611840.11718, + # 0.000686168670654297 # ], # [ # [ Modified: doc/source/example/tutorial/micro_blog-7.log (+2 -2) =================================================================== --- doc/source/example/tutorial/micro_blog-7.log 2012-05-10 10:12:32 +0900 (c21dfff) +++ doc/source/example/tutorial/micro_blog-7.log 2012-05-10 10:14:06 +0900 (0cad5f4) @@ -4,8 +4,8 @@ Execution example:: # [ # [ # 0, - # 1336468414.8984, - # 0.00037074089050293 + # 1336611840.3228, + # 0.000347375869750977 # ], # [ # [ Modified: doc/source/example/tutorial/micro_blog-8.log (+2 -2) =================================================================== --- doc/source/example/tutorial/micro_blog-8.log 2012-05-10 10:12:32 +0900 (7e1e367) +++ doc/source/example/tutorial/micro_blog-8.log 2012-05-10 10:14:06 +0900 (2b47069) @@ -4,8 +4,8 @@ Execution example:: # [ # [ # 0, - # 1336468415.10035, - # 0.000369787216186523 + # 1336611840.52657, + # 0.000337839126586914 # ], # [ # [ Modified: doc/source/example/tutorial/micro_blog-9.log (+2 -2) =================================================================== --- doc/source/example/tutorial/micro_blog-9.log 2012-05-10 10:12:32 +0900 (c66855e) +++ doc/source/example/tutorial/micro_blog-9.log 2012-05-10 10:14:06 +0900 (9b28047) @@ -4,8 +4,8 @@ Execution example:: # [ # [ # 0, - # 1336468415.3025, - # 0.000294923782348633 + # 1336611840.72949, + # 0.000270605087280273 # ], # [ # [ Modified: doc/source/example/tutorial/network-1.log (+4 -4) =================================================================== --- doc/source/example/tutorial/network-1.log 2012-05-10 10:12:32 +0900 (03c1f6b) +++ doc/source/example/tutorial/network-1.log 2012-05-10 10:14:06 +0900 (3ec2fd3) @@ -5,18 +5,18 @@ Execution example:: # [ # [ # 0, - # 1336468415.72543, - # 6.19888305664062e-05 + # 1336611845.44394, + # 5.60283660888672e-05 # ], # { # "uptime": 0, # "max_command_version": 2, # "n_queries": 0, # "cache_hit_rate": 0.0, - # "version": "2.0.2-28-g74fc93a", + # "version": "2.0.2", # "alloc_count": 130, # "command_version": 1, - # "starttime": 1336468415, + # "starttime": 1336611845, # "default_command_version": 1 # } # ] Modified: doc/source/example/tutorial/network-3.log (+6 -6) =================================================================== --- doc/source/example/tutorial/network-3.log 2012-05-10 10:12:32 +0900 (bf81133) +++ doc/source/example/tutorial/network-3.log 2012-05-10 10:14:06 +0900 (40a1855) @@ -6,18 +6,18 @@ http://HOST_NAME_OR_IP_ADDRESS[:PORT_NUMBER]/d/status # [ # [ # 0, - # 1336468415.92706, - # 6.43730163574219e-05 + # 1336611845.64733, + # 0.000109672546386719 # ], # { # "uptime": 0, # "max_command_version": 2, # "n_queries": 0, # "cache_hit_rate": 0.0, - # "version": "2.0.2-28-g74fc93a", + # "version": "2.0.2", # "alloc_count": 131, # "command_version": 1, - # "starttime": 1336468415, + # "starttime": 1336611845, # "default_command_version": 1 # } # ] @@ -28,8 +28,8 @@ http://HOST_NAME_OR_IP_ADDRESS[:PORT_NUMBER]/d/status # [ # [ # 0, - # 1336468416.12826, - # 0.00135111808776855 + # 1336611845.84951, + # 0.00153684616088867 # ], # [ # [ Modified: doc/source/example/tutorial/patricia_trie-1.log (+4 -4) =================================================================== --- doc/source/example/tutorial/patricia_trie-1.log 2012-05-10 10:12:32 +0900 (e1b17c6) +++ doc/source/example/tutorial/patricia_trie-1.log 2012-05-10 10:14:06 +0900 (2b1ae5a) @@ -1,20 +1,20 @@ Execution example:: table_create --name PatPrefix --flags TABLE_PAT_KEY --key_type ShortText - # [[0,1336468387.77833,0.000189781188964844],true] + # [[0,1336611813.15703,0.000311613082885742],true] load --table PatPrefix [ {"_key":"ひろゆき"}, {"_key":"まろゆき"}, {"_key":"ひろあき"} ] - # [[0,1336468387.97908,0.200587749481201],3] + # [[0,1336611813.35797,0.200602531433105],3] select --table PatPrefix --query _key:@ひろ # [ # [ # 0, - # 1336468388.38016, - # 0.000479698181152344 + # 1336611813.7593, + # 0.000472307205200195 # ], # [ # [ Modified: doc/source/example/tutorial/patricia_trie-2.log (+7 -7) =================================================================== --- doc/source/example/tutorial/patricia_trie-2.log 2012-05-10 10:12:32 +0900 (790fc11) +++ doc/source/example/tutorial/patricia_trie-2.log 2012-05-10 10:14:06 +0900 (1de9401) @@ -1,22 +1,22 @@ Execution example:: table_create --name PatSuffix --flags TABLE_PAT_KEY|KEY_WITH_SIS --key_type ShortText - # [[0,1336468388.5819,0.000212192535400391],true] + # [[0,1336611813.96192,0.000253677368164062],true] column_create --table PatSuffix --name original --type Bool - # [[0,1336468388.78261,0.000191450119018555],true] + # [[0,1336611814.16294,0.000247478485107422],true] load --table PatSuffix [ {"_key":"ひろゆき","original":true}, {"_key":"まろゆき","original":true}, {"_key":"ひろあき","original":true} ] - # [[0,1336468388.9833,0.200592756271362],3] + # [[0,1336611814.36409,0.200676918029785],3] select --table PatSuffix --query _key:@ゆき # [ # [ # 0, - # 1336468389.38437, - # 0.000394582748413086 + # 1336611814.7656, + # 0.000568866729736328 # ], # [ # [ @@ -64,8 +64,8 @@ Execution example:: # [ # [ # 0, - # 1336468389.58586, - # 0.000368118286132812 + # 1336611814.96857, + # 0.000341415405273438 # ], # [ # [ Modified: doc/source/example/tutorial/query_expansion-1.log (+8 -8) =================================================================== --- doc/source/example/tutorial/query_expansion-1.log 2012-05-10 10:12:32 +0900 (90cae0c) +++ doc/source/example/tutorial/query_expansion-1.log 2012-05-10 10:14:06 +0900 (b3e19c9) @@ -1,26 +1,26 @@ Execution example:: table_create Doc TABLE_PAT_KEY ShortText - # [[0,1336468416.35389,0.000249862670898438],true] + # [[0,1336611848.49714,0.000167131423950195],true] column_create Doc body COLUMN_SCALAR ShortText - # [[0,1336468416.5548,0.000641345977783203],true] + # [[0,1336611848.69792,0.000664710998535156],true] table_create Term TABLE_PAT_KEY|KEY_NORMALIZE ShortText --default_tokenizer TokenBigram - # [[0,1336468416.75607,0.000226736068725586],true] + # [[0,1336611848.8991,0.000290870666503906],true] column_create Term Doc_body COLUMN_INDEX|WITH_POSITION Doc body - # [[0,1336468416.95674,0.00353670120239258],true] + # [[0,1336611849.1001,0.00568056106567383],true] table_create Synonym TABLE_PAT_KEY ShortText - # [[0,1336468417.16076,0.000248432159423828],true] + # [[0,1336611849.30661,0.000278949737548828],true] column_create Synonym body COLUMN_SCALAR ShortText - # [[0,1336468417.36158,0.000540494918823242],true] + # [[0,1336611849.50759,0.00092005729675293],true] load --table Doc [ {"_key": "001", "body": "すっぱいブドウと甘いシークァーサー"}, {"_key": "002", "body": "シークヮーサージュースとゴーヤチャンプル"}, ] - # [[0,1336468417.56262,0.201695919036865],2] + # [[0,1336611849.70934,0.201861143112183],2] load --table Synonym [ {"_key": "シークァーサー", "body": "(シークァーサー OR シークヮーサー)"}, {"_key": "シークヮーサー", "body": "(シークァーサー OR シークヮーサー)"}, ] - # [[0,1336468417.96483,0.200520038604736],2] + # [[0,1336611850.11205,0.20064902305603],2] Modified: doc/source/example/tutorial/query_expansion-2.log (+4 -4) =================================================================== --- doc/source/example/tutorial/query_expansion-2.log 2012-05-10 10:12:32 +0900 (c08b35e) +++ doc/source/example/tutorial/query_expansion-2.log 2012-05-10 10:14:06 +0900 (10629df) @@ -4,8 +4,8 @@ Execution example:: # [ # [ # 0, - # 1336468418.36617, - # 0.000488758087158203 + # 1336611850.51383, + # 0.000647783279418945 # ], # [ # [ @@ -38,8 +38,8 @@ Execution example:: # [ # [ # 0, - # 1336468418.56768, - # 0.000367879867553711 + # 1336611850.71645, + # 0.000455617904663086 # ], # [ # [ Modified: doc/source/example/tutorial/query_expansion-3.log (+4 -4) =================================================================== --- doc/source/example/tutorial/query_expansion-3.log 2012-05-10 10:12:32 +0900 (06ea084) +++ doc/source/example/tutorial/query_expansion-3.log 2012-05-10 10:14:06 +0900 (4bbbabe) @@ -4,8 +4,8 @@ Execution example:: # [ # [ # 0, - # 1336468418.76931, - # 0.000395298004150391 + # 1336611850.91904, + # 0.000535011291503906 # ], # [ # [ @@ -43,8 +43,8 @@ Execution example:: # [ # [ # 0, - # 1336468418.97085, - # 0.000394105911254883 + # 1336611851.12091, + # 0.000458002090454102 # ], # [ # [ Modified: doc/source/example/tutorial/search-1.log (+29 -3) =================================================================== --- doc/source/example/tutorial/search-1.log 2012-05-10 10:12:32 +0900 (7dd2694) +++ doc/source/example/tutorial/search-1.log 2012-05-10 10:14:06 +0900 (2bbe9d2) @@ -1,5 +1,31 @@ Execution example:: - > select --table Site --filter "_id <= 1" --output_columns _id,_key - [[0,1317212733.77852,0.000333188],[[[1],[["_id","UInt32"],["_key","ShortText"]],[1,"http://example.org/"]]]] - \ No newline at end of file + select --table Site --filter "_id <= 1" --output_columns _id,_key + # [ + # [ + # 0, + # 1336611846.06145, + # 0.000503778457641602 + # ], + # [ + # [ + # [ + # 1 + # ], + # [ + # [ + # "_id", + # "UInt32" + # ], + # [ + # "_key", + # "ShortText" + # ] + # ], + # [ + # 1, + # "http://example.org/" + # ] + # ] + # ] + # ] Modified: doc/source/example/tutorial/search-2.log (+82 -5) =================================================================== --- doc/source/example/tutorial/search-2.log 2012-05-10 10:12:32 +0900 (8517fbf) +++ doc/source/example/tutorial/search-2.log 2012-05-10 10:14:06 +0900 (4fb5506) @@ -1,7 +1,84 @@ Execution example:: - > select --table Site --filter "_id >= 4 && _id <= 6" --output_columns _id,_key - [[0,1317212733.97986,0.000297681],[[[3],[["_id","UInt32"],["_key","ShortText"]],[4,"http://example.net/afr"],[5,"http://example.org/aba"],[6,"http://example.com/rab"]]]] - > select --table Site --filter "_id <= 2 || _id >= 7" --output_columns _id,_key - [[0,1317212734.18118,0.000250524],[[[5],[["_id","UInt32"],["_key","ShortText"]],[1,"http://example.org/"],[2,"http://example.net/"],[7,"http://example.net/atv"],[8,"http://example.org/gat"],[9,"http://example.com/vdw"]]]] - \ No newline at end of file + select --table Site --filter "_id >= 4 && _id <= 6" --output_columns _id,_key + # [ + # [ + # 0, + # 1336611846.2635, + # 0.000507116317749023 + # ], + # [ + # [ + # [ + # 3 + # ], + # [ + # [ + # "_id", + # "UInt32" + # ], + # [ + # "_key", + # "ShortText" + # ] + # ], + # [ + # 4, + # "http://example.net/afr" + # ], + # [ + # 5, + # "http://example.org/aba" + # ], + # [ + # 6, + # "http://example.com/rab" + # ] + # ] + # ] + # ] + select --table Site --filter "_id <= 2 || _id >= 7" --output_columns _id,_key + # [ + # [ + # 0, + # 1336611846.46611, + # 0.000424385070800781 + # ], + # [ + # [ + # [ + # 5 + # ], + # [ + # [ + # "_id", + # "UInt32" + # ], + # [ + # "_key", + # "ShortText" + # ] + # ], + # [ + # 1, + # "http://example.org/" + # ], + # [ + # 2, + # "http://example.net/" + # ], + # [ + # 7, + # "http://example.net/atv" + # ], + # [ + # 8, + # "http://example.org/gat" + # ], + # [ + # 9, + # "http://example.com/vdw" + # ] + # ] + # ] + # ] Modified: doc/source/example/tutorial/search-3.log (+148 -5) =================================================================== --- doc/source/example/tutorial/search-3.log 2012-05-10 10:12:32 +0900 (28898da) +++ doc/source/example/tutorial/search-3.log 2012-05-10 10:14:06 +0900 (3b42523) @@ -1,7 +1,150 @@ Execution example:: - > select --table Site --filter "1" --scorer "_score = rand()" --output_columns _id,_key,_score --sortby _score - [[0,1317212734.38283,0.000354558],[[[9],[["_id","UInt32"],["_key","ShortText"],["_score","Int32"]],[6,"http://example.com/rab",424238335],[9,"http://example.com/vdw",596516649],[7,"http://example.net/atv",719885386],[2,"http://example.net/",846930886],[8,"http://example.org/gat",1649760492],[3,"http://example.com/",1681692777],[4,"http://example.net/afr",1714636915],[1,"http://example.org/",1804289383],[5,"http://example.org/aba",1957747793]]]] - > select --table Site --filter "1" --scorer "_score = rand()" --output_columns _id,_key,_score --sortby _score - [[0,1317212734.58497,0.000350529],[[[9],[["_id","UInt32"],["_key","ShortText"],["_score","Int32"]],[4,"http://example.net/afr",783368690],[2,"http://example.net/",1025202362],[5,"http://example.org/aba",1102520059],[1,"http://example.org/",1189641421],[3,"http://example.com/",1350490027],[8,"http://example.org/gat",1365180540],[9,"http://example.com/vdw",1540383426],[7,"http://example.net/atv",1967513926],[6,"http://example.com/rab",2044897763]]]] - \ No newline at end of file + select --table Site --filter "1" --scorer "_score = rand()" --output_columns _id,_key,_score --sortby _score + # [ + # [ + # 0, + # 1336611846.66914, + # 0.000356435775756836 + # ], + # [ + # [ + # [ + # 9 + # ], + # [ + # [ + # "_id", + # "UInt32" + # ], + # [ + # "_key", + # "ShortText" + # ], + # [ + # "_score", + # "Int32" + # ] + # ], + # [ + # 6, + # "http://example.com/rab", + # 424238335 + # ], + # [ + # 9, + # "http://example.com/vdw", + # 596516649 + # ], + # [ + # 7, + # "http://example.net/atv", + # 719885386 + # ], + # [ + # 2, + # "http://example.net/", + # 846930886 + # ], + # [ + # 8, + # "http://example.org/gat", + # 1649760492 + # ], + # [ + # 3, + # "http://example.com/", + # 1681692777 + # ], + # [ + # 4, + # "http://example.net/afr", + # 1714636915 + # ], + # [ + # 1, + # "http://example.org/", + # 1804289383 + # ], + # [ + # 5, + # "http://example.org/aba", + # 1957747793 + # ] + # ] + # ] + # ] + select --table Site --filter "1" --scorer "_score = rand()" --output_columns _id,_key,_score --sortby _score + # [ + # [ + # 0, + # 1336611846.87139, + # 0.000517129898071289 + # ], + # [ + # [ + # [ + # 9 + # ], + # [ + # [ + # "_id", + # "UInt32" + # ], + # [ + # "_key", + # "ShortText" + # ], + # [ + # "_score", + # "Int32" + # ] + # ], + # [ + # 4, + # "http://example.net/afr", + # 783368690 + # ], + # [ + # 2, + # "http://example.net/", + # 1025202362 + # ], + # [ + # 5, + # "http://example.org/aba", + # 1102520059 + # ], + # [ + # 1, + # "http://example.org/", + # 1189641421 + # ], + # [ + # 3, + # "http://example.com/", + # 1350490027 + # ], + # [ + # 8, + # "http://example.org/gat", + # 1365180540 + # ], + # [ + # 9, + # "http://example.com/vdw", + # 1540383426 + # ], + # [ + # 7, + # "http://example.net/atv", + # 1967513926 + # ], + # [ + # 6, + # "http://example.com/rab", + # 2044897763 + # ] + # ] + # ] + # ] Modified: doc/source/example/tutorial/search-4.log (+56 -11) =================================================================== --- doc/source/example/tutorial/search-4.log 2012-05-10 10:12:32 +0900 (62a73eb) +++ doc/source/example/tutorial/search-4.log 2012-05-10 10:14:06 +0900 (7a175ad) @@ -1,13 +1,58 @@ Execution example:: - > column_create --table Site --name location --type WGS84GeoPoint - [[0,1317212734.78744,0.047997601],true] - > load --table Site - > [ - > {"_key":"http://example.org/","location":"128452975x503157902"} - > {"_key":"http://example.net/","location":"128487316x502920929"}, - > ] - [[0,1317212735.0361,0.801149613],2] - > select --table Site --query "_id:1 OR _id:2" --output_columns _key,location - [[0,1317212736.03775,0.000261897],[[[2],[["_key","ShortText"],["location","WGS84GeoPoint"]],["http://example.org/","128452975x503157902"],["http://example.net/","128487316x502920929"]]]] - \ No newline at end of file + column_create --table Site --name location --type WGS84GeoPoint + # [ + # [ + # -22, + # 1336611847.07642, + # 0.000628948211669922, + # "already used name was assigned: <Site.location>", + # [ + # [ + # "grn_obj_register", + # "db.c", + # 6572 + # ] + # ] + # ], + # false + # ] + load --table Site + [ + {"_key":"http://example.org/","location":"128452975x503157902"} + {"_key":"http://example.net/","location":"128487316x502920929"}, + ] + # [[0,1336611847.27872,0.200761318206787],2] + select --table Site --query "_id:1 OR _id:2" --output_columns _key,location + # [ + # [ + # 0, + # 1336611847.68, + # 0.00042724609375 + # ], + # [ + # [ + # [ + # 2 + # ], + # [ + # [ + # "_key", + # "ShortText" + # ], + # [ + # "location", + # "WGS84GeoPoint" + # ] + # ], + # [ + # "http://example.org/", + # "128452975x503157902" + # ], + # [ + # "http://example.net/", + # "128487316x502920929" + # ] + # ] + # ] + # ] Modified: doc/source/example/tutorial/search-5.log (+39 -3) =================================================================== --- doc/source/example/tutorial/search-5.log 2012-05-10 10:12:32 +0900 (707b05f) +++ doc/source/example/tutorial/search-5.log 2012-05-10 10:14:06 +0900 (93fa40d) @@ -1,5 +1,41 @@ Execution example:: - > select --table Site --query "_id:1 OR _id:2" --output_columns _key,location,_score --scorer '_score = geo_distance(location, "128515259x503187188")' - [[0,1317212736.23918,0.000393211],[[[2],[["_key","ShortText"],["location","WGS84GeoPoint"],["_score","Int32"]],["http://example.org/","128452975x503157902",2054],["http://example.net/","128487316x502920929",6720]]]] - \ No newline at end of file + select --table Site --query "_id:1 OR _id:2" --output_columns _key,location,_score --scorer '_score = geo_distance(location, "128515259x503187188")' + # [ + # [ + # 0, + # 1336611847.88274, + # 0.000491142272949219 + # ], + # [ + # [ + # [ + # 2 + # ], + # [ + # [ + # "_key", + # "ShortText" + # ], + # [ + # "location", + # "WGS84GeoPoint" + # ], + # [ + # "_score", + # "Int32" + # ] + # ], + # [ + # "http://example.org/", + # "128452975x503157902", + # 2054 + # ], + # [ + # "http://example.net/", + # "128487316x502920929", + # 6720 + # ] + # ] + # ] + # ] Modified: doc/source/example/tutorial/search-6.log (+39 -3) =================================================================== --- doc/source/example/tutorial/search-6.log 2012-05-10 10:12:32 +0900 (c3e7046) +++ doc/source/example/tutorial/search-6.log 2012-05-10 10:14:06 +0900 (2d2d308) @@ -1,5 +1,41 @@ Execution example:: - > select --table Site --query "_id:1 OR _id:2" --output_columns _key,location,_score --scorer '_score = geo_distance(location, "128515259x503187188")' --sortby -_score - [[0,1317212736.44102,0.000345608],[[[2],[["_key","ShortText"],["location","WGS84GeoPoint"],["_score","Int32"]],["http://example.net/","128487316x502920929",6720],["http://example.org/","128452975x503157902",2054]]]] - \ No newline at end of file + select --table Site --query "_id:1 OR _id:2" --output_columns _key,location,_score --scorer '_score = geo_distance(location, "128515259x503187188")' --sortby -_score + # [ + # [ + # 0, + # 1336611848.08587, + # 0.000615596771240234 + # ], + # [ + # [ + # [ + # 2 + # ], + # [ + # [ + # "_key", + # "ShortText" + # ], + # [ + # "location", + # "WGS84GeoPoint" + # ], + # [ + # "_score", + # "Int32" + # ] + # ], + # [ + # "http://example.net/", + # "128487316x502920929", + # 6720 + # ], + # [ + # "http://example.org/", + # "128452975x503157902", + # 2054 + # ] + # ] + # ] + # ] Modified: doc/source/example/tutorial/search-7.log (+29 -3) =================================================================== --- doc/source/example/tutorial/search-7.log 2012-05-10 10:12:32 +0900 (5305925) +++ doc/source/example/tutorial/search-7.log 2012-05-10 10:14:06 +0900 (d78d6cb) @@ -1,5 +1,31 @@ Execution example:: - > select --table Site --output_columns _key,location --filter 'geo_in_circle(location, "128515259x503187188", 5000)' - [[0,1317212736.64335,0.000245378],[[[1],[["_key","ShortText"],["location","WGS84GeoPoint"]],["http://example.org/","128452975x503157902"]]]] - \ No newline at end of file + select --table Site --output_columns _key,location --filter 'geo_in_circle(location, "128515259x503187188", 5000)' + # [ + # [ + # 0, + # 1336611848.28917, + # 0.000642061233520508 + # ], + # [ + # [ + # [ + # 1 + # ], + # [ + # [ + # "_key", + # "ShortText" + # ], + # [ + # "location", + # "WGS84GeoPoint" + # ] + # ], + # [ + # "http://example.org/", + # "128452975x503157902" + # ] + # ] + # ] + # ]