Skip to content

Instantly share code, notes, and snippets.

@pashinin

pashinin/gist:7ad9eaaf90d633961386df247daa37cd

Last active August 13, 2016 12:59
Show Gist options
  • Save pashinin/7ad9eaaf90d633961386df247daa37cd to your computer and use it in GitHub Desktop.
Save pashinin/7ad9eaaf90d633961386df247daa37cd to your computer and use it in GitHub Desktop.
Download ZIP
regression.diffs
Raw
gistfile1.txt
*** /build/zombodb/postgres/src/test/expected/expansions.out 2016-08-01 08:20:46.475002197 +0000
--- /build/zombodb/postgres/results/expansions.out 2016-08-13 12:46:49.435631734 +0000
***************
*** 1,544 ****
select * from zdb_tally('so_posts', 'owner_display_name', '^.*', '( #expand<parent_id=<this.index>id> (title:java) ) ', 1000, 'term');
! term | count
! ------------------------+-------
! | 4010
! 8kb | 1
! a b | 1
! abafei | 1
! adeel ansari | 1
! adipa gunasekara | 1
! aedonetlira | 1
! alexander suraphel | 1
! allen | 1
! andrey chaschev | 1
! andrzej doyle | 2
! andy thomas-cramer | 1
! anon | 1
! anotherdave | 1
! ansgri | 1
! aravind chennuru | 1
! augusto | 1
! az651 | 1
! basic | 1
! bendin | 1
! bestsss | 1
! bill the lizard | 1
! billy oneal | 2
! blauohr | 1
! bluegoldfish | 1
! bohemian | 2
! boris pavlović | 1
! bot | 1
! captain | 1
! carrknight | 1
! chandra | 1
! chirag fanse | 1
! chris aldrich | 1
! chris jester-young | 1
! chris thompson | 1
! cloudanger | 1
! cloudyster | 1
! clyfe | 1
! codemed | 1
! corgrath | 1
! daniel c. sobral | 1
! daniel r hicks | 1
! darthvader | 1
! david harkness | 1
! david wallace | 1
! davidgr | 1
! dcn | 1
! dean j | 1
! dimoniy | 1
! dinesh | 1
! dmitri | 1
! dsimcha | 1
! duffymo | 2
! edin dazdarevic | 1
! eek | 1
! eli | 1
! ellery newcomer | 1
! eric david | 1
! eric galluzzo | 1
! ericschaefer | 1
! ernest friedman-hill | 1
! ernesto che | 1
! evernoob | 1
! fbonnet | 1
! federico fissore | 1
! fergie | 1
! fernandogarcez | 1
! fielding | 1
! flapjackery | 1
! folone | 2
! frank pape | 1
! gareth davis | 1
! gargc | 1
! glenpeterson | 1
! glenviewjeff | 1
! grayger | 1
! hakre | 1
! hamlet d'arcy | 1
! harper89 | 2
! hawkeye | 1
! highland mark | 1
! hilbrand | 1
! huntlyc | 1
! hvgotcodes | 1
! iik | 1
! jack | 1
! jaksky | 1
! james | 2
! jaredpar | 1
! jarrod roberson | 1
! jason | 1
! jason s | 2
! java_mouse | 1
! jberg | 1
! jean-philippe pellet | 1
! jesper | 1
! jesse good | 1
! jmort253 | 1
! jodonnell | 1
! joe philllips | 1
! john blake | 1
! johnnyboy | 1
! jon skeet | 1
! joseph ottinger | 1
! jsmyth | 1
! justin thomas | 1
! kaiserjohaan | 1
! kal | 1
! kamikaze mercenary | 1
! kares | 1
! karstenf | 1
! kerb | 1
! keshav.veerapaneni | 1
! kevin | 1
! kevin montrose | 1
! kevin zhang | 1
! kierrow | 1
! kim burgaard | 1
! kocko | 1
! konrad rudolph | 1
! kr0e | 1
! krock | 1
! kshitiz sharma | 1
! laserallan | 1
! legally_challenged | 1
! legend | 1
! lewicki | 1
! loosebruce | 1
! louis rhys | 1
! luchian grigore | 1
! m. deinum | 1
! marcandreson | 1
! mariuszs | 1
! mark | 1
! marko topolnik | 1
! markr | 1
! martin | 1
! mat banik | 1
! matt briggs | 1
! max | 1
! maxym | 1
! mike strobel | 1
! mikera | 1
! mort | 1
! morten holdflod møller | 1
! moyamo | 1
! n1234 | 1
! naveen | 1
! nemanja trifunovic | 1
! nikhil kashyap | 1
! nilesh | 1
! nishant | 1
! nsfyn55 | 1
! onewhoneedguidenss | 1
! oscarryz | 1
! oxbow_lakes | 1
! patrick | 1
! paulmurray | 1
! peter wone | 1
! pinnacle | 1
! polygenelubricants | 1
! pubby8 | 1
! quant_dev | 1
! ranzilber | 1
! raticulin | 1
! rbusch90 | 1
! regulus | 1
! retrodev | 1
! rex kerr | 1
! ricky | 1
! rik | 1
! rob warthen | 1
! robert fischer | 1
! robert oschler | 1
! robin green | 1
! rogcg | 1
! roland schneider | 1
! rudy gruse | 1
! ryan delucchi | 1
! ryyst | 1
! salil | 1
! samit g. | 1
! sbridges | 1
! science_fiction | 1
! sebarmeli | 1
! segy | 1
! senthil | 1
! sergey | 1
! sergio | 2
! serik | 1
! shadowfoxmi | 1
! shamis | 1
! shisoft | 1
! sk-logic | 1
! skeith | 1
! soc | 1
! sophie sperner | 1
! space rocker | 1
! spyrosp | 1
! sschaef | 1
! stefan d. | 1
! stepancheg | 1
! stephen c | 2
! steve chambers | 1
! steven | 1
! suresh s | 1
! suroot | 1
! tarun | 1
! tete | 1
! thecompboy | 1
! thomas | 1
! thsoft | 1
! timo geusch | 1
! tkee2036 | 1
! tlpd | 1
! toluju | 1
! tom | 2
! tom hawtin - tackline | 1
! tomasz nurkiewicz | 1
! turing complete | 1
! ubersoldat | 1
! uri | 1
! user1056758 | 1
! user11020 | 1
! user1249 | 46
! user1449 | 3
! user14719 | 1
! user16373 | 1
! user16482 | 1
! user17715 | 1
! user18046 | 1
! user18404 | 2
! user19000 | 1
! user19067 | 1
! user19382 | 1
! user19437 | 1
! user22904 | 1
! user255607 | 1
! user2567 | 1
! user269799 | 1
! user2860598 | 2
! user29079 | 1
! user39331 | 1
! user39685 | 4
! user40362 | 1
! user4051 | 4
! user42242 | 2
! user50689 | 1
! user57697 | 1
! user66282 | 1
! user664509 | 1
! user7071 | 1
! user7197 | 2
! user80699 | 1
! user852740 | 1
! user92106 | 1
! user967316 | 1
! ven coder | 1
! vimvq1987 | 1
! wang.chance | 1
! wesley | 1
! winstonchurchill | 1
! wolfmandragon | 1
! woot4moo | 1
! yaba | 1
! zaske | 1
! (266 rows)
select * from zdb_tally('so_posts', 'owner_display_name', '^.*', '( #expand<parent_id=<this.index>id> (title:java) ) ', 1000, 'term');
! term | count
! ------------------------+-------
! | 4010
! 8kb | 1
! a b | 1
! abafei | 1
! adeel ansari | 1
! adipa gunasekara | 1
! aedonetlira | 1
! alexander suraphel | 1
! allen | 1
! andrey chaschev | 1
! andrzej doyle | 2
! andy thomas-cramer | 1
! anon | 1
! anotherdave | 1
! ansgri | 1
! aravind chennuru | 1
! augusto | 1
! az651 | 1
! basic | 1
! bendin | 1
! bestsss | 1
! bill the lizard | 1
! billy oneal | 2
! blauohr | 1
! bluegoldfish | 1
! bohemian | 2
! boris pavlović | 1
! bot | 1
! captain | 1
! carrknight | 1
! chandra | 1
! chirag fanse | 1
! chris aldrich | 1
! chris jester-young | 1
! chris thompson | 1
! cloudanger | 1
! cloudyster | 1
! clyfe | 1
! codemed | 1
! corgrath | 1
! daniel c. sobral | 1
! daniel r hicks | 1
! darthvader | 1
! david harkness | 1
! david wallace | 1
! davidgr | 1
! dcn | 1
! dean j | 1
! dimoniy | 1
! dinesh | 1
! dmitri | 1
! dsimcha | 1
! duffymo | 2
! edin dazdarevic | 1
! eek | 1
! eli | 1
! ellery newcomer | 1
! eric david | 1
! eric galluzzo | 1
! ericschaefer | 1
! ernest friedman-hill | 1
! ernesto che | 1
! evernoob | 1
! fbonnet | 1
! federico fissore | 1
! fergie | 1
! fernandogarcez | 1
! fielding | 1
! flapjackery | 1
! folone | 2
! frank pape | 1
! gareth davis | 1
! gargc | 1
! glenpeterson | 1
! glenviewjeff | 1
! grayger | 1
! hakre | 1
! hamlet d'arcy | 1
! harper89 | 2
! hawkeye | 1
! highland mark | 1
! hilbrand | 1
! huntlyc | 1
! hvgotcodes | 1
! iik | 1
! jack | 1
! jaksky | 1
! james | 2
! jaredpar | 1
! jarrod roberson | 1
! jason | 1
! jason s | 2
! java_mouse | 1
! jberg | 1
! jean-philippe pellet | 1
! jesper | 1
! jesse good | 1
! jmort253 | 1
! jodonnell | 1
! joe philllips | 1
! john blake | 1
! johnnyboy | 1
! jon skeet | 1
! joseph ottinger | 1
! jsmyth | 1
! justin thomas | 1
! kaiserjohaan | 1
! kal | 1
! kamikaze mercenary | 1
! kares | 1
! karstenf | 1
! kerb | 1
! keshav.veerapaneni | 1
! kevin | 1
! kevin montrose | 1
! kevin zhang | 1
! kierrow | 1
! kim burgaard | 1
! kocko | 1
! konrad rudolph | 1
! kr0e | 1
! krock | 1
! kshitiz sharma | 1
! laserallan | 1
! legally_challenged | 1
! legend | 1
! lewicki | 1
! loosebruce | 1
! louis rhys | 1
! luchian grigore | 1
! m. deinum | 1
! marcandreson | 1
! mariuszs | 1
! mark | 1
! marko topolnik | 1
! markr | 1
! martin | 1
! mat banik | 1
! matt briggs | 1
! max | 1
! maxym | 1
! mike strobel | 1
! mikera | 1
! mort | 1
! morten holdflod møller | 1
! moyamo | 1
! n1234 | 1
! naveen | 1
! nemanja trifunovic | 1
! nikhil kashyap | 1
! nilesh | 1
! nishant | 1
! nsfyn55 | 1
! onewhoneedguidenss | 1
! oscarryz | 1
! oxbow_lakes | 1
! patrick | 1
! paulmurray | 1
! peter wone | 1
! pinnacle | 1
! polygenelubricants | 1
! pubby8 | 1
! quant_dev | 1
! ranzilber | 1
! raticulin | 1
! rbusch90 | 1
! regulus | 1
! retrodev | 1
! rex kerr | 1
! ricky | 1
! rik | 1
! rob warthen | 1
! robert fischer | 1
! robert oschler | 1
! robin green | 1
! rogcg | 1
! roland schneider | 1
! rudy gruse | 1
! ryan delucchi | 1
! ryyst | 1
! salil | 1
! samit g. | 1
! sbridges | 1
! science_fiction | 1
! sebarmeli | 1
! segy | 1
! senthil | 1
! sergey | 1
! sergio | 2
! serik | 1
! shadowfoxmi | 1
! shamis | 1
! shisoft | 1
! sk-logic | 1
! skeith | 1
! soc | 1
! sophie sperner | 1
! space rocker | 1
! spyrosp | 1
! sschaef | 1
! stefan d. | 1
! stepancheg | 1
! stephen c | 2
! steve chambers | 1
! steven | 1
! suresh s | 1
! suroot | 1
! tarun | 1
! tete | 1
! thecompboy | 1
! thomas | 1
! thsoft | 1
! timo geusch | 1
! tkee2036 | 1
! tlpd | 1
! toluju | 1
! tom | 2
! tom hawtin - tackline | 1
! tomasz nurkiewicz | 1
! turing complete | 1
! ubersoldat | 1
! uri | 1
! user1056758 | 1
! user11020 | 1
! user1249 | 46
! user1449 | 3
! user14719 | 1
! user16373 | 1
! user16482 | 1
! user17715 | 1
! user18046 | 1
! user18404 | 2
! user19000 | 1
! user19067 | 1
! user19382 | 1
! user19437 | 1
! user22904 | 1
! user255607 | 1
! user2567 | 1
! user269799 | 1
! user2860598 | 2
! user29079 | 1
! user39331 | 1
! user39685 | 4
! user40362 | 1
! user4051 | 4
! user42242 | 2
! user50689 | 1
! user57697 | 1
! user66282 | 1
! user664509 | 1
! user7071 | 1
! user7197 | 2
! user80699 | 1
! user852740 | 1
! user92106 | 1
! user967316 | 1
! ven coder | 1
! vimvq1987 | 1
! wang.chance | 1
! wesley | 1
! winstonchurchill | 1
! wolfmandragon | 1
! woot4moo | 1
! yaba | 1
! zaske | 1
! (266 rows)
select id, owner_display_name from so_posts where zdb('so_posts', ctid) ==> '#expand<owner_display_name=<this.index>owner_display_name>(id:39338)' order by 1;
id | owner_display_name
--- 1,14 ----
select * from zdb_tally('so_posts', 'owner_display_name', '^.*', '( #expand<parent_id=<this.index>id> (title:java) ) ', 1000, 'term');
! term | count
! ------+-------
! | 4010
! (1 row)
select * from zdb_tally('so_posts', 'owner_display_name', '^.*', '( #expand<parent_id=<this.index>id> (title:java) ) ', 1000, 'term');
! term | count
! ------+-------
! | 4010
! (1 row)
select id, owner_display_name from so_posts where zdb('so_posts', ctid) ==> '#expand<owner_display_name=<this.index>owner_display_name>(id:39338)' order by 1;
id | owner_display_name
======================================================================
*** /build/zombodb/postgres/src/test/expected/determine-index2.out 2016-08-01 08:20:46.475002197 +0000
--- /build/zombodb/postgres/results/determine-index2.out 2016-08-13 12:47:05.635704750 +0000
***************
*** 36,43 ****
SELECT * FROM zdb_tally('public.mam_doc_test', 'security', '0', '^.*', '', 5000, 'term'::zdb_tally_order);
term | count
------+-------
! eric | 1
! (1 row)
SELECT * FROM zdb_tally('public.mam_doc_test', 'mam_doc_sub_data.security', '0', '^.*', '', 5000, 'term'::zdb_tally_order);
term | count
--- 36,42 ----
SELECT * FROM zdb_tally('public.mam_doc_test', 'security', '0', '^.*', '', 5000, 'term'::zdb_tally_order);
term | count
------+-------
! (0 rows)
SELECT * FROM zdb_tally('public.mam_doc_test', 'mam_doc_sub_data.security', '0', '^.*', '', 5000, 'term'::zdb_tally_order);
term | count
======================================================================
*** /build/zombodb/postgres/src/test/expected/issue-29.out 2016-08-01 08:20:46.475002197 +0000
--- /build/zombodb/postgres/results/issue-29.out 2016-08-13 12:47:06.515708716 +0000
***************
*** 1,16 ****
SELECT * FROM zdb_tally('so_posts', 'owner_display_name', '^.*', '', 10, 'count');
! term | count
! -----------+--------
! | 154132
! user1249 | 598
! user2567 | 513
! user8685 | 254
! user4051 | 153
! user8 | 84
! user29981 | 79
! user39685 | 68
! user23157 | 50
! sergio | 48
! user29079 | 47
! (11 rows)
--- 1,6 ----
SELECT * FROM zdb_tally('so_posts', 'owner_display_name', '^.*', '', 10, 'count');
! term | count
! ------+--------
! | 154132
! (1 row)
======================================================================
*** /build/zombodb/postgres/src/test/expected/issue-32.out 2016-08-01 08:20:46.475002197 +0000
--- /build/zombodb/postgres/results/issue-32.out 2016-08-13 12:47:07.147711563 +0000
***************
*** 1,18 ****
SELECT * FROM zdb_tally('so_posts', 'tags', '^.*', '', 12, 'count');
! term | count
! -------------+--------
! | 129680
! design | 4955
! c | 4283
! programming | 2842
! java | 2713
! development | 2618
! web | 2207
! patterns | 1873
! object | 1803
! oriented | 1798
! code | 1416
! testing | 1393
! php | 1344
! (13 rows)
--- 1,6 ----
SELECT * FROM zdb_tally('so_posts', 'tags', '^.*', '', 12, 'count');
! term | count
! ------+--------
! | 129680
! (1 row)
======================================================================
*** /build/zombodb/postgres/src/test/expected/issue-63.out 2016-08-01 08:20:46.475002197 +0000
--- /build/zombodb/postgres/results/issue-63.out 2016-08-13 12:47:18.927765524 +0000
***************
*** 35,47 ****
CREATE INDEX es_idx_tas_update_fail ON tas_update_fail USING zombodb (zdb('tas_update_fail', ctid), zdb(tas_update_fail.*)) WITH (url='http://localhost:9200/', shards=2, replicas=1);
SELECT *
FROM zdb_tally('tas_update_fail', 'end_date_text', '0', '^.*', '', 5000, 'term' :: zdb_tally_order);
! term | count
! ------------+-------
! 12/31/1999 | 2
! 12/31/2016 | 1
! 2/3/1999 | 1
! unknown | 1
! (4 rows)
UPDATE tas_update_fail
SET duration = CASE WHEN isdate(end_date_text) = 1 AND isdate(start_date_text) = 1
--- 35,43 ----
CREATE INDEX es_idx_tas_update_fail ON tas_update_fail USING zombodb (zdb('tas_update_fail', ctid), zdb(tas_update_fail.*)) WITH (url='http://localhost:9200/', shards=2, replicas=1);
SELECT *
FROM zdb_tally('tas_update_fail', 'end_date_text', '0', '^.*', '', 5000, 'term' :: zdb_tally_order);
! term | count
! ------+-------
! (0 rows)
UPDATE tas_update_fail
SET duration = CASE WHEN isdate(end_date_text) = 1 AND isdate(start_date_text) = 1
***************
*** 49,61 ****
ELSE NULL END;
SELECT *
FROM zdb_tally('tas_update_fail', 'end_date_text', '0', '^.*', '', 5000, 'term' :: zdb_tally_order);
! term | count
! ------------+-------
! 12/31/1999 | 2
! 12/31/2016 | 1
! 2/3/1999 | 1
! unknown | 1
! (4 rows)
--
-- followup to original report against issue-63
--- 45,53 ----
ELSE NULL END;
SELECT *
FROM zdb_tally('tas_update_fail', 'end_date_text', '0', '^.*', '', 5000, 'term' :: zdb_tally_order);
! term | count
! ------+-------
! (0 rows)
--
-- followup to original report against issue-63
***************
*** 69,81 ****
COMMIT;
SELECT *
FROM zdb_tally('tas_update_fail', 'end_date_text', '0', '^.*', '', 5000, 'term' :: zdb_tally_order);
! term | count
! ------------+-------
! 12/31/1999 | 2
! 12/31/2016 | 1
! 2/3/1999 | 1
! unknown | 1
! (4 rows)
DROP TABLE tas_update_fail CASCADE;
DROP FUNCTION isdate(TEXT);
--- 61,69 ----
COMMIT;
SELECT *
FROM zdb_tally('tas_update_fail', 'end_date_text', '0', '^.*', '', 5000, 'term' :: zdb_tally_order);
! term | count
! ------+-------
! (0 rows)
DROP TABLE tas_update_fail CASCADE;
DROP FUNCTION isdate(TEXT);
======================================================================
*** /build/zombodb/postgres/src/test/expected/analyzers.out 2016-08-01 08:20:46.475002197 +0000
--- /build/zombodb/postgres/results/analyzers.out 2016-08-13 12:47:22.763783148 +0000
***************
*** 124,194 ****
ORDER BY attnum;
zdb_analyze_text
------------------------------
! (اختبار,4,10,<ALPHANUM>,2)
! (սա,0,2,<ALPHANUM>,1)
! (փորձությ,3,14,<ALPHANUM>,2)
! (fro,4,9,<ALPHANUM>,2)
! (est,0,4,<ALPHANUM>,1)
! (es,5,7,<ALPHANUM>,2)
! (un,8,10,<ALPHANUM>,3)
! (examen,11,17,<ALPHANUM>,4)
! (тест,7,11,<ALPHANUM>,3)
! (ex,11,17,<ALPHANUM>,4)
! (这,0,1,word,1)
! (是,1,2,word,2)
! (一,2,3,word,3)
! (个,3,4,word,4)
! (测,4,5,word,5)
! (试,5,6,word,6)
! (これ,0,2,<DOUBLE>,1)
! (れは,1,3,<DOUBLE>,2)
! (はテ,2,4,<DOUBLE>,3)
! (テス,3,5,<DOUBLE>,4)
! (スト,4,6,<DOUBLE>,5)
! (トで,5,7,<DOUBLE>,6)
! (です,6,8,<DOUBLE>,7)
! (tot,0,4,<ALPHANUM>,1)
! (test,8,12,<ALPHANUM>,3)
! (test,12,16,<ALPHANUM>,4)
! (test,11,15,<ALPHANUM>,4)
! (test,10,14,<ALPHANUM>,4)
! (koe,8,11,<ALPHANUM>,3)
! (test,9,13,<ALPHANUM>,3)
! (prob,12,17,<ALPHANUM>,4)
! (test,12,16,<ALPHANUM>,4)
! (ενα,11,14,<ALPHANUM>,3)
! (τεστ,15,19,<ALPHANUM>,4)
! (परिकषण,6,13,<ALPHANUM>,3)
! (tesz,7,12,<ALPHANUM>,3)
! (uji,18,23,<ALPHANUM>,4)
! (tá,0,2,<ALPHANUM>,1)
! (seo,6,9,<ALPHANUM>,3)
! (tást,13,20,<ALPHANUM>,5)
! (prova,13,18,<ALPHANUM>,4)
! (šis,0,3,<ALPHANUM>,1)
! (test,7,12,<ALPHANUM>,3)
! (test,12,16,<ALPHANUM>,4)
! (é,5,6,<ALPHANUM>,2)
! (test,10,15,<ALPHANUM>,4)
! (test,15,19,<ALPHANUM>,4)
! (эт,0,3,<ALPHANUM>,1)
! (тест,4,8,<ALPHANUM>,2)
! (this,0,4,<ALPHANUM>,1)
! (is,5,7,<ALPHANUM>,2)
! (a,8,9,<ALPHANUM>,3)
! (test,10,14,<ALPHANUM>,4)
! (examen,11,17,<ALPHANUM>,4)
! (prov,13,17,<ALPHANUM>,4)
! (test,7,11,<ALPHANUM>,3)
! (นี่,0,3,word,1)
! (ทดสอบ,9,14,word,4)
! (this,0,4,<ALPHANUM>,1)
! (this$is,0,7,shingle,1)
! (is,5,7,<ALPHANUM>,2)
! (is$a,5,9,shingle,2)
! (a,8,9,<ALPHANUM>,3)
! (a$test,8,14,shingle,3)
! (test,10,14,<ALPHANUM>,4)
(65 rows)
SELECT
--- 124,194 ----
ORDER BY attnum;
zdb_analyze_text
------------------------------
! (اختبار,4,10,<ALPHANUM>,1)
! (սա,0,2,<ALPHANUM>,0)
! (փորձությ,3,14,<ALPHANUM>,1)
! (fro,4,9,<ALPHANUM>,1)
! (est,0,4,<ALPHANUM>,0)
! (es,5,7,<ALPHANUM>,1)
! (un,8,10,<ALPHANUM>,2)
! (examen,11,17,<ALPHANUM>,3)
! (тест,7,11,<ALPHANUM>,2)
! (ex,11,17,<ALPHANUM>,3)
! (这,0,1,<IDEOGRAPHIC>,0)
! (是,1,2,<IDEOGRAPHIC>,1)
! (一,2,3,<IDEOGRAPHIC>,2)
! (个,3,4,<IDEOGRAPHIC>,3)
! (测,4,5,<IDEOGRAPHIC>,4)
! (试,5,6,<IDEOGRAPHIC>,5)
! (これ,0,2,<DOUBLE>,0)
! (れは,1,3,<DOUBLE>,1)
! (はテ,2,4,<DOUBLE>,2)
! (テス,3,5,<DOUBLE>,3)
! (スト,4,6,<DOUBLE>,4)
! (トで,5,7,<DOUBLE>,5)
! (です,6,8,<DOUBLE>,6)
! (tot,0,4,<ALPHANUM>,0)
! (test,8,12,<ALPHANUM>,2)
! (test,12,16,<ALPHANUM>,3)
! (test,11,15,<ALPHANUM>,3)
! (test,10,14,<ALPHANUM>,3)
! (koe,8,11,<ALPHANUM>,2)
! (test,9,13,<ALPHANUM>,2)
! (prob,12,17,<ALPHANUM>,3)
! (test,12,16,<ALPHANUM>,3)
! (ενα,11,14,<ALPHANUM>,2)
! (τεστ,15,19,<ALPHANUM>,3)
! (परिकषण,6,13,<ALPHANUM>,2)
! (tesz,7,12,<ALPHANUM>,2)
! (uji,18,23,<ALPHANUM>,3)
! (tá,0,2,<ALPHANUM>,0)
! (seo,6,9,<ALPHANUM>,2)
! (tást,13,20,<ALPHANUM>,4)
! (prova,13,18,<ALPHANUM>,3)
! (šis,0,3,<ALPHANUM>,0)
! (test,7,12,<ALPHANUM>,2)
! (test,12,16,<ALPHANUM>,3)
! (é,5,6,<ALPHANUM>,1)
! (test,10,15,<ALPHANUM>,3)
! (test,15,19,<ALPHANUM>,3)
! (эт,0,3,<ALPHANUM>,0)
! (тест,4,8,<ALPHANUM>,1)
! (this,0,4,<ALPHANUM>,0)
! (is,5,7,<ALPHANUM>,1)
! (a,8,9,<ALPHANUM>,2)
! (test,10,14,<ALPHANUM>,3)
! (examen,11,17,<ALPHANUM>,3)
! (prov,13,17,<ALPHANUM>,3)
! (test,7,11,<ALPHANUM>,2)
! (นี่,0,3,word,0)
! (ทดสอบ,9,14,word,3)
! (this,0,4,<ALPHANUM>,0)
! (this$is,0,7,shingle,0)
! (is,5,7,<ALPHANUM>,1)
! (is$a,5,9,shingle,1)
! (a,8,9,<ALPHANUM>,2)
! (a$test,8,14,shingle,2)
! (test,10,14,<ALPHANUM>,3)
(65 rows)
SELECT
======================================================================
*** /build/zombodb/postgres/src/test/expected/issue-69-terms.out 2016-08-01 08:20:46.475002197 +0000
--- /build/zombodb/postgres/results/issue-69-terms.out 2016-08-13 12:47:22.903783791 +0000
***************
*** 1,17 ****
SELECT *
FROM zdb_tally('so_posts', 'title', '^A.*', '', 5000, 'term')
LIMIT 10;
! term | count
! ----------+--------
! | 129680
! a | 9898
! a.append | 1
! a.i | 3
! a7 | 1
! aa | 1
! aac | 1
! aardvark | 1
! ab | 1
! abalone | 1
! (10 rows)
--- 1,8 ----
SELECT *
FROM zdb_tally('so_posts', 'title', '^A.*', '', 5000, 'term')
LIMIT 10;
! term | count
! ------+--------
! | 129680
! (1 row)
======================================================================
*** /build/zombodb/postgres/src/test/expected/issue-85.out 2016-08-01 08:20:46.475002197 +0000
--- /build/zombodb/postgres/results/issue-85.out 2016-08-13 12:47:36.695847148 +0000
***************
*** 5,13 ****
CREATE INDEX idxissue_85 ON issue_85 USING zombodb(zdb('issue_85', ctid), zdb(issue_85)) WITH (url='http://localhost:9200/');
INSERT INTO issue_85(data) values ('{"title": "this is the title"}');
SELECT * FROM zdb_tally('issue_85', 'data.title', '^.*', '', 5000, 'count');
! term | count
! -------------------+-------
! this is the title | 1
! (1 row)
DROP TABLE issue_85;
--- 5,12 ----
CREATE INDEX idxissue_85 ON issue_85 USING zombodb(zdb('issue_85', ctid), zdb(issue_85)) WITH (url='http://localhost:9200/');
INSERT INTO issue_85(data) values ('{"title": "this is the title"}');
SELECT * FROM zdb_tally('issue_85', 'data.title', '^.*', '', 5000, 'count');
! term | count
! ------+-------
! (0 rows)
DROP TABLE issue_85;
======================================================================
*** /build/zombodb/postgres/src/test/expected/zdb_arbitrary_aggregate.out 2016-08-01 08:20:46.479002215 +0000
--- /build/zombodb/postgres/results/zdb_arbitrary_aggregate.out 2016-08-13 12:47:38.367854829 +0000
***************
*** 2,9 ****
FROM zdb_arbitrary_aggregate('so_posts',
'#tally(tags, ''^.*'', 25, ''term'', #tally(owner_display_name, ''^.*'', 150, ''term''))',
'');
! zdb_arbitrary_aggregate
! -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
! {"missing":{"doc_count":129680},"tags":{"doc_count_error_upper_bound":0,"sum_other_doc_count":122366,"buckets":[{"key":"1","doc_count":2,"owner_display_name":{"doc_count_error_upper_bound":0,"sum_other_doc_count":0,"buckets":[]}},{"key":"11","doc_count":85,"owner_display_name":{"doc_count_error_upper_bound":0,"sum_other_doc_count":0,"buckets":[{"key":"als","doc_count":1},{"key":"anon","doc_count":1},{"key":"felics","doc_count":1},{"key":"freddie chopin","doc_count":1},{"key":"ifreilicht","doc_count":1},{"key":"kian","doc_count":1},{"key":"pongba","doc_count":1},{"key":"robert dailey","doc_count":1},{"key":"ronag","doc_count":1},{"key":"user751747","doc_count":1},{"key":"user91225","doc_count":1}]}},{"key":"1a","doc_count":1,"owner_display_name":{"doc_count_error_upper_bound":0,"sum_other_doc_count":0,"buckets":[]}},{"key":"2.0","doc_count":4,"owner_display_name":{"doc_count_error_upper_bound":0,"sum_other_doc_count":0,"buckets":[]}},{"key":"2008","doc_count":7,"owner_display_name":{"doc_count_error_upper_bound":0,"sum_other_doc_count":0,"buckets":[]}},{"key":"2010","doc_count":78,"owner_display_name":{"doc_count_error_upper_bound":0,"sum_other_doc_count":0,"buckets":[{"key":"eldar","doc_count":1},{"key":"paul","doc_count":1},{"key":"system.data","doc_count":1},{"key":"user19948","doc_count":1},{"key":"user8685","doc_count":1}]}},{"key":"2012","doc_count":16,"owner_display_name":{"doc_count_error_upper_bound":0,"sum_other_doc_count":0,"buckets":[]}},{"key":"3","doc_count":79,"owner_display_name":{"doc_count_error_upper_bound":0,"sum_other_doc_count":0,"buckets":[{"key":"codys-hole","doc_count":1},{"key":"george stocker","doc_count":1},{"key":"giedrius","doc_count":1},{"key":"kryptonite","doc_count":1},{"key":"lud","doc_count":1},{"key":"max","doc_count":1},{"key":"mob1lejunkie","doc_count":1},{"key":"mojtaba","doc_count":1},{"key":"ryanw","doc_count":1},{"key":"sergi papaseit","doc_count":1},{"key":"singleton","doc_count":1},{"key":"terryr","doc_count":1},{"key":"yorch","doc_count":1}]}},{"key":"32","doc_count":8,"owner_display_name":{"doc_count_error_upper_bound":0,"sum_other_doc_count":0,"buckets":[]}},{"key":"3d","doc_count":26,"owner_display_name":{"doc_count_error_upper_bound":0,"sum_other_doc_count":0,"buckets":[{"key":"aman","doc_count":1},{"key":"baring","doc_count":1},{"key":"eonil","doc_count":1}]}},{"key":"3rd","doc_count":5,"owner_display_name":{"doc_count_error_upper_bound":0,"sum_other_doc_count":0,"buckets":[]}},{"key":"4","doc_count":52,"owner_display_name":{"doc_count_error_upper_bound":0,"sum_other_doc_count":0,"buckets":[{"key":"jrhutch","doc_count":1},{"key":"phil","doc_count":1}]}},{"key":"6","doc_count":17,"owner_display_name":{"doc_count_error_upper_bound":0,"sum_other_doc_count":0,"buckets":[{"key":"aaaidan","doc_count":1},{"key":"brandon moore","doc_count":1},{"key":"hawkeye","doc_count":1}]}},{"key":"64","doc_count":12,"owner_display_name":{"doc_count_error_upper_bound":0,"sum_other_doc_count":0,"buckets":[]}},{"key":"7","doc_count":48,"owner_display_name":{"doc_count_error_upper_bound":0,"sum_other_doc_count":0,"buckets":[{"key":"brian","doc_count":1},{"key":"michael mangold","doc_count":1},{"key":"paweł smejda","doc_count":1},{"key":"pearcewg","doc_count":1},{"key":"praetorian","doc_count":1},{"key":"sebastian","doc_count":1},{"key":"vitalii vasylenko","doc_count":1}]}},{"key":"8","doc_count":59,"owner_display_name":{"doc_count_error_upper_bound":0,"sum_other_doc_count":0,"buckets":[{"key":"lukas","doc_count":1},{"key":"sebastian","doc_count":1},{"key":"shane adrian muaz","doc_count":1}]}},{"key":"a","doc_count":37,"owner_display_name":{"doc_count_error_upper_bound":0,"sum_other_doc_count":0,"buckets":[{"key":"colix","doc_count":1}]}},{"key":"abap","doc_count":3,"owner_display_name":{"doc_count_error_upper_bound":0,"sum_other_doc_count":0,"buckets":[]}},{"key":"abstract","doc_count":40,"owner_display_name":{"doc_count_error_upper_bound":0,"sum_other_doc_count":0,"buckets":[{"key":"martin","doc_count":1},{"key":"palm snow","doc_count":1}]}},{"key":"abstraction","doc_count":108,"owner_display_name":{"doc_count_error_upper_bound":0,"sum_other_doc_count":0,"buckets":[{"key":"jeff","doc_count":1},{"key":"matt spinelli","doc_count":1},{"key":"nishant","doc_count":1}]}},{"key":"acceptance","doc_count":50,"owner_display_name":{"doc_count_error_upper_bound":0,"sum_other_doc_count":0,"buckets":[{"key":"matt spinelli","doc_count":1},{"key":"user2960603","doc_count":1}]}},{"key":"access","doc_count":88,"owner_display_name":{"doc_count_error_upper_bound":0,"sum_other_doc_count":0,"buckets":[{"key":"anon","doc_count":1},{"key":"jon","doc_count":1}]}},{"key":"accessibility","doc_count":12,"owner_display_name":{"doc_count_error_upper_bound":0,"sum_other_doc_count":0,"buckets":[{"key":"user87105","doc_count":1}]}},{"key":"actionscript","doc_count":20,"owner_display_name":{"doc_count_error_upper_bound":0,"sum_other_doc_count":0,"buckets":[{"key":"user22288","doc_count":1}]}},{"key":"active","doc_count":9,"owner_display_name":{"doc_count_error_upper_bound":0,"sum_other_doc_count":0,"buckets":[{"key":"john hoge","doc_count":1}]}}]}}
(1 row)
--- 2,9 ----
FROM zdb_arbitrary_aggregate('so_posts',
'#tally(tags, ''^.*'', 25, ''term'', #tally(owner_display_name, ''^.*'', 150, ''term''))',
'');
! zdb_arbitrary_aggregate
! ----------------------------------------------------------------------------------------------------------------
! {"missing":{"doc_count":129680},"tags":{"doc_count_error_upper_bound":0,"sum_other_doc_count":0,"buckets":[]}}
(1 row)
======================================================================
*** /build/zombodb/postgres/src/test/expected/issue-118.out 2016-08-01 08:20:46.475002197 +0000
--- /build/zombodb/postgres/results/issue-118.out 2016-08-13 12:47:38.479855342 +0000
***************
*** 1,6 ****
SELECT term FROM zdb_significant_terms('so_posts', 'owner_display_name', '^.*', 'java', 5000) ORDER BY term LIMIT 1;
! term
! --------
! cletus
! (1 row)
--- 1,5 ----
SELECT term FROM zdb_significant_terms('so_posts', 'owner_display_name', '^.*', 'java', 5000) ORDER BY term LIMIT 1;
! term
! ------
! (0 rows)
======================================================================
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment