*** /pub/devel/postgresql/postgresql-9.3beta1-1/src/postgresql-9.3beta1/src/test/regress/expected/tsearch.out 2013-05-06 22:57:06.000000000 +0200 --- /pub/devel/postgresql/postgresql-9.3beta1-1/build/src/test/regress/results/tsearch.out 2013-06-10 10:22:21.369652800 +0200 *************** *** 267,276 **** SELECT * FROM ts_parse('default', '345 qwe@efd.r '' http://www.com/ http://aew.werc.ewr/?ad=qwe&dw 1aew.werc.ewr/?ad=qwe&dw 2aew.werc.ewr http://3aew.werc.ewr/?ad=qwe&dw http://4aew.werc.ewr http://5aew.werc.ewr:8100/? ad=qwe&dw 6aew.werc.ewr:8100/?ad=qwe&dw 7aew.werc.ewr:8100/?ad=qwe&dw=%20%32 +4.0e-10 qwe qwe qwqwe 234.435 455 5.005 teodor@stack.net qwe-wer asdf qwer jf sdjk ewr1> ewri2 /usr/local/fff /awdf/dwqe/4325 rewt/ewr wefjn /wqe-324/ewr gist.h gist.h.c gist.c. readline 4.2 4.2. 4.2, readline-4.2 readline-4.2. 234 wow < jqw <> qwerty'); ! tokid | token ! -------+-------------------------------------- ! 22 | 345 ! 12 | 1 | qwe 12 | @ 19 | efd.r --- 267,277 ---- SELECT * FROM ts_parse('default', '345 qwe@efd.r '' http://www.com/ http://aew.werc.ewr/?ad=qwe&dw 1aew.werc.ewr/?ad=qwe&dw 2aew.werc.ewr http://3aew.werc.ewr/?ad=qwe&dw http://4aew.werc.ewr http://5aew.werc.ewr:8100/? ad=qwe&dw 6aew.werc.ewr:8100/?ad=qwe&dw 7aew.werc.ewr:8100/?ad=qwe&dw=%20%32 +4.0e-10 qwe qwe qwqwe 234.435 455 5.005 teodor@stack.net qwe-wer asdf qwer jf sdjk ewr1> ewri2 /usr/local/fff /awdf/dwqe/4325 rewt/ewr wefjn /wqe-324/ewr gist.h gist.h.c gist.c. readline 4.2 4.2. 4.2, readline-4.2 readline-4.2. 234 wow < jqw <> qwerty'); ! tokid | token ! -------+------------------------- ! 12 | 3 ! 12 | 4 ! 12 | 5 1 | qwe 12 | @ 19 | efd.r *************** *** 283,335 **** 6 | aew.werc.ewr 18 | /?ad=qwe&dw 12 | ! 5 | 1aew.werc.ewr/?ad=qwe&dw ! 6 | 1aew.werc.ewr 18 | /?ad=qwe&dw 12 | ! 6 | 2aew.werc.ewr 12 | 14 | http:// ! 5 | 3aew.werc.ewr/?ad=qwe&dw ! 6 | 3aew.werc.ewr 18 | /?ad=qwe&dw 12 | 14 | http:// ! 6 | 4aew.werc.ewr 12 | 14 | http:// ! 5 | 5aew.werc.ewr:8100/? ! 6 | 5aew.werc.ewr:8100 ! 18 | /? ! 12 | 1 | ad 12 | = 1 | qwe 12 | & 1 | dw 12 | ! 5 | 6aew.werc.ewr:8100/?ad=qwe&dw ! 6 | 6aew.werc.ewr:8100 ! 18 | /?ad=qwe&dw ! 12 | ! 5 | 7aew.werc.ewr:8100/?ad=qwe&dw=%20%32 ! 6 | 7aew.werc.ewr:8100 ! 18 | /?ad=qwe&dw=%20%32 ! 12 | ! 7 | +4.0e-10 12 | 1 | qwe 12 | 1 | qwe 12 | 1 | qwqwe 12 | ! 20 | 234.435 ! 12 | ! 22 | 455 ! 12 | ! 20 | 5.005 ! 12 | 4 | teodor@stack.net 12 | 16 | qwe-wer --- 284,380 ---- 6 | aew.werc.ewr 18 | /?ad=qwe&dw 12 | ! 12 | 1 ! 5 | aew.werc.ewr/?ad=qwe&dw ! 6 | aew.werc.ewr 18 | /?ad=qwe&dw 12 | ! 12 | 2 ! 6 | aew.werc.ewr 12 | 14 | http:// ! 12 | 3 ! 5 | aew.werc.ewr/?ad=qwe&dw ! 6 | aew.werc.ewr 18 | /?ad=qwe&dw 12 | 14 | http:// ! 12 | 4 ! 6 | aew.werc.ewr 12 | 14 | http:// ! 12 | 5 ! 6 | aew.werc.ewr ! 12 | : ! 12 | 8 ! 12 | 1 ! 12 | 0 ! 12 | 0 ! 12 | /? 1 | ad 12 | = 1 | qwe 12 | & 1 | dw 12 | ! 12 | 6 ! 6 | aew.werc.ewr ! 12 | : ! 12 | 8 ! 12 | 1 ! 12 | 0 ! 12 | 0 ! 12 | /? ! 1 | ad ! 12 | = ! 1 | qwe ! 12 | & ! 1 | dw 12 | + 12 | 7 + 6 | aew.werc.ewr + 12 | : + 12 | 8 + 12 | 1 + 12 | 0 + 12 | 0 + 12 | /? + 1 | ad + 12 | = + 1 | qwe + 12 | & + 1 | dw + 12 | =% + 12 | 2 + 12 | 0% + 12 | 3 + 12 | 2 + 12 | + + 12 | 4. + 12 | 0 + 1 | e + 12 | - + 12 | 1 + 12 | 0 1 | qwe 12 | 1 | qwe 12 | 1 | qwqwe 12 | ! 12 | 2 ! 12 | 3 ! 12 | 4. ! 12 | 4 ! 12 | 3 ! 12 | 5 ! 12 | 4 ! 12 | 5 ! 12 | 5 ! 12 | 5. ! 12 | 0 ! 12 | 0 ! 12 | 5 4 | teodor@stack.net 12 | 16 | qwe-wer *************** *** 352,373 **** 12 | 13 | 12 | ! 3 | ewr1 ! 12 | > ! 3 | ewri2 12 | ! 13 | ! 12 | + | 19 | /usr/local/fff 12 | ! 19 | /awdf/dwqe/4325 ! 12 | 19 | rewt/ewr 12 | 1 | wefjn 12 | ! 19 | /wqe-324/ewr 12 | 19 | gist.h 12 | --- 397,432 ---- 12 | 13 | 12 | ! 1 | ewr ! 12 | 1> ! 1 | ewri ! 12 | 2 ! 12 | < ! 1 | a 12 | ! 1 | href ! 12 | =" ! 1 | qwe ! 13 | ! 12 | "> + | 19 | /usr/local/fff 12 | ! 19 | /awdf/dwqe ! 12 | / ! 12 | 4 ! 12 | 3 ! 12 | 2 ! 12 | 5 19 | rewt/ewr 12 | 1 | wefjn 12 | ! 19 | /wqe- ! 12 | 3 ! 12 | 2 ! 12 | 4 ! 19 | /ewr 12 | 19 | gist.h 12 | *************** *** 377,396 **** 12 | . 1 | readline 12 | ! 20 | 4.2 ! 12 | ! 20 | 4.2 ! 12 | . ! 20 | 4.2 ! 12 | , 1 | readline ! 20 | -4.2 ! 12 | 1 | readline ! 20 | -4.2 ! 12 | . ! 22 | 234 ! 12 | + | 12 | < 1 | i --- 436,458 ---- 12 | . 1 | readline 12 | ! 12 | 4. ! 12 | 2 ! 12 | 4. ! 12 | 2. ! 12 | 4. ! 12 | 2, 1 | readline ! 12 | - ! 12 | 4. ! 12 | 2 1 | readline ! 12 | - ! 12 | 4. ! 12 | 2. ! 12 | 2 ! 12 | 3 ! 12 | 4 + | 12 | < 1 | i *************** *** 404,417 **** 12 | 12 | <> 1 | qwerty ! (133 rows) SELECT to_tsvector('english', '345 qwe@efd.r '' http://www.com/ http://aew.werc.ewr/?ad=qwe&dw 1aew.werc.ewr/?ad=qwe&dw 2aew.werc.ewr http://3aew.werc.ewr/?ad=qwe&dw http://4aew.werc.ewr http://5aew.werc.ewr:8100/? ad=qwe&dw 6aew.werc.ewr:8100/?ad=qwe&dw 7aew.werc.ewr:8100/?ad=qwe&dw=%20%32 +4.0e-10 qwe qwe qwqwe 234.435 455 5.005 teodor@stack.net qwe-wer asdf qwer jf sdjk ewr1> ewri2 /usr/local/fff /awdf/dwqe/4325 rewt/ewr wefjn /wqe-324/ewr gist.h gist.h.c gist.c. readline 4.2 4.2. 4.2, readline-4.2 readline-4.2. 234 wow < jqw <> qwerty'); ! to_tsvector ! ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ ! '+4.0e-10':28 '-4.2':60,62 '/?':18 '/?ad=qwe&dw':7,10,14,24 '/?ad=qwe&dw=%20%32':27 '/awdf/dwqe/4325':48 '/usr/local/fff':47 '/wqe-324/ewr':51 '1aew.werc.ewr':9 '1aew.werc.ewr/?ad=qwe&dw':8 '234':63 '234.435':32 '2aew.werc.ewr':11 '345':1 '3aew.werc.ewr':13 '3aew.werc.ewr/?ad=qwe&dw':12 '4.2':56,57,58 '455':33 '4aew.werc.ewr':15 '5.005':34 '5aew.werc.ewr:8100':17 '5aew.werc.ewr:8100/?':16 '6aew.werc.ewr:8100':23 '6aew.werc.ewr:8100/?ad=qwe&dw':22 '7aew.werc.ewr:8100':26 '7aew.werc.ewr:8100/?ad=qwe&dw=%20%32':25 'ad':19 'aew.werc.ewr':6 'aew.werc.ewr/?ad=qwe&dw':5 'asdf':39 'dw':21 'efd.r':3 'ewr1':45 'ewri2':46 'gist.c':54 'gist.h':52 'gist.h.c':53 'hjwer':44 'jf':41 'jqw':66 'qwe':2,20,29,30,37 'qwe-wer':36 'qwer':40 'qwerti':67 'qwqwe':31 'readlin':55,59,61 'rewt/ewr':49 'sdjk':42 'teodor@stack.net':35 'wefjn':50 'wer':38 'wow':65 'www.com':4 (1 row) SELECT length(to_tsvector('english', '345 qwe@efd.r '' http://www.com/ http://aew.werc.ewr/?ad=qwe&dw 1aew.werc.ewr/?ad=qwe&dw 2aew.werc.ewr http://3aew.werc.ewr/?ad=qwe&dw http://4aew.werc.ewr http://5aew.werc.ewr:8100/? ad=qwe&dw 6aew.werc.ewr:8100/?ad=qwe&dw 7aew.werc.ewr:8100/?ad=qwe&dw=%20%32 +4.0e-10 qwe qwe qwqwe 234.435 455 5.005 teodor@stack.net qwe-wer asdf qwer jf sdjk ewr1> ewri2 --- 466,479 ---- 12 | 12 | <> 1 | qwerty ! (195 rows) SELECT to_tsvector('english', '345 qwe@efd.r '' http://www.com/ http://aew.werc.ewr/?ad=qwe&dw 1aew.werc.ewr/?ad=qwe&dw 2aew.werc.ewr http://3aew.werc.ewr/?ad=qwe&dw http://4aew.werc.ewr http://5aew.werc.ewr:8100/? ad=qwe&dw 6aew.werc.ewr:8100/?ad=qwe&dw 7aew.werc.ewr:8100/?ad=qwe&dw=%20%32 +4.0e-10 qwe qwe qwqwe 234.435 455 5.005 teodor@stack.net qwe-wer asdf qwer jf sdjk ewr1> ewri2 /usr/local/fff /awdf/dwqe/4325 rewt/ewr wefjn /wqe-324/ewr gist.h gist.h.c gist.c. readline 4.2 4.2. 4.2, readline-4.2 readline-4.2. 234 wow < jqw <> qwerty'); ! to_tsvector ! ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ ! '/?ad=qwe&dw':6,9,13 '/awdf/dwqe':47 '/ewr':51 '/usr/local/fff':46 '/wqe-':50 'ad':16,20,24 'aew.werc.ewr':5,8,10,12,14,15,19,23 'aew.werc.ewr/?ad=qwe&dw':4,7,11 'asdf':35 'dw':18,22,26 'e':27 'efd.r':2 'ewr':41 'ewri':42 'gist.c':54 'gist.h':52 'gist.h.c':53 'hjwer':40 'href':44 'jf':37 'jqw':60 'qwe':1,17,21,25,28,29,33,45 'qwe-wer':32 'qwer':36 'qwerti':61 'qwqwe':30 'readlin':55,56,57 'rewt/ewr':48 'sdjk':38 'teodor@stack.net':31 'wefjn':49 'wer':34 'wow':59 'www.com':3 (1 row) SELECT length(to_tsvector('english', '345 qwe@efd.r '' http://www.com/ http://aew.werc.ewr/?ad=qwe&dw 1aew.werc.ewr/?ad=qwe&dw 2aew.werc.ewr http://3aew.werc.ewr/?ad=qwe&dw http://4aew.werc.ewr http://5aew.werc.ewr:8100/? ad=qwe&dw 6aew.werc.ewr:8100/?ad=qwe&dw 7aew.werc.ewr:8100/?ad=qwe&dw=%20%32 +4.0e-10 qwe qwe qwqwe 234.435 455 5.005 teodor@stack.net qwe-wer asdf qwer jf sdjk ewr1> ewri2 *************** *** 419,425 **** wow < jqw <> qwerty')); length -------- ! 53 (1 row) -- ts_debug --- 481,487 ---- wow < jqw <> qwerty')); length -------- ! 34 (1 row) -- ts_debug *************** *** 430,441 **** asciiword | Word, all ASCII | abc | {english_stem} | english_stem | {abc} entity | XML entity | &nm1; | {} | | asciiword | Word, all ASCII | def | {english_stem} | english_stem | {def} ! entity | XML entity | © | {} | | asciiword | Word, all ASCII | ghi | {english_stem} | english_stem | {ghi} ! entity | XML entity | õ | {} | | asciiword | Word, all ASCII | jkl | {english_stem} | english_stem | {jkl} tag | XML tag | | {} | | ! (9 rows) -- check parsing of URLs SELECT * from ts_debug('english', 'http://www.harewoodsolutions.co.uk/press.aspx'); --- 492,508 ---- asciiword | Word, all ASCII | abc | {english_stem} | english_stem | {abc} entity | XML entity | &nm1; | {} | | asciiword | Word, all ASCII | def | {english_stem} | english_stem | {def} ! blank | Space symbols | &# | {} | | ! asciiword | Word, all ASCII | xa | {english_stem} | english_stem | {xa} ! blank | Space symbols | 9; | {} | | asciiword | Word, all ASCII | ghi | {english_stem} | english_stem | {ghi} ! blank | Space symbols | &# | {} | | ! blank | Space symbols | 2 | {} | | ! blank | Space symbols | 4 | {} | | ! blank | Space symbols | 5; | {} | | asciiword | Word, all ASCII | jkl | {english_stem} | english_stem | {jkl} tag | XML tag | | {} | | ! (14 rows) -- check parsing of URLs SELECT * from ts_debug('english', 'http://www.harewoodsolutions.co.uk/press.aspx'); *************** *** 449,479 **** (5 rows) SELECT * from ts_debug('english', 'http://aew.wer0c.ewr/id?ad=qwe&dw'); ! alias | description | token | dictionaries | dictionary | lexemes ! ----------+---------------+----------------------------+--------------+------------+------------------------------ ! protocol | Protocol head | http:// | {} | | ! url | URL | aew.wer0c.ewr/id?ad=qwe&dw | {simple} | simple | {aew.wer0c.ewr/id?ad=qwe&dw} ! host | Host | aew.wer0c.ewr | {simple} | simple | {aew.wer0c.ewr} ! url_path | URL path | /id?ad=qwe&dw | {simple} | simple | {/id?ad=qwe&dw} ! tag | XML tag | | {} | | ! (5 rows) SELECT * from ts_debug('english', 'http://5aew.werc.ewr:8100/?'); ! alias | description | token | dictionaries | dictionary | lexemes ! ----------+---------------+----------------------+--------------+------------+------------------------ ! protocol | Protocol head | http:// | {} | | ! url | URL | 5aew.werc.ewr:8100/? | {simple} | simple | {5aew.werc.ewr:8100/?} ! host | Host | 5aew.werc.ewr:8100 | {simple} | simple | {5aew.werc.ewr:8100} ! url_path | URL path | /? | {simple} | simple | {/?} ! (4 rows) SELECT * from ts_debug('english', '5aew.werc.ewr:8100/?xx'); ! alias | description | token | dictionaries | dictionary | lexemes ! ----------+-------------+------------------------+--------------+------------+-------------------------- ! url | URL | 5aew.werc.ewr:8100/?xx | {simple} | simple | {5aew.werc.ewr:8100/?xx} ! host | Host | 5aew.werc.ewr:8100 | {simple} | simple | {5aew.werc.ewr:8100} ! url_path | URL path | /?xx | {simple} | simple | {/?xx} ! (3 rows) -- to_tsquery SELECT to_tsquery('english', 'qwe & sKies '); --- 516,559 ---- (5 rows) SELECT * from ts_debug('english', 'http://aew.wer0c.ewr/id?ad=qwe&dw'); ! alias | description | token | dictionaries | dictionary | lexemes ! ----------+---------------+--------------------+--------------+------------+---------------------- ! protocol | Protocol head | http:// | {} | | ! host | Host | aew.wer | {simple} | simple | {aew.wer} ! blank | Space symbols | 0 | {} | | ! url | URL | c.ewr/id?ad=qwe&dw | {simple} | simple | {c.ewr/id?ad=qwe&dw} ! host | Host | c.ewr | {simple} | simple | {c.ewr} ! url_path | URL path | /id?ad=qwe&dw | {simple} | simple | {/id?ad=qwe&dw} ! tag | XML tag | | {} | | ! (7 rows) SELECT * from ts_debug('english', 'http://5aew.werc.ewr:8100/?'); ! alias | description | token | dictionaries | dictionary | lexemes ! ----------+---------------+--------------+--------------+------------+---------------- ! protocol | Protocol head | http:// | {} | | ! blank | Space symbols | 5 | {} | | ! host | Host | aew.werc.ewr | {simple} | simple | {aew.werc.ewr} ! blank | Space symbols | : | {} | | ! blank | Space symbols | 8 | {} | | ! blank | Space symbols | 1 | {} | | ! blank | Space symbols | 0 | {} | | ! blank | Space symbols | 0 | {} | | ! blank | Space symbols | /? | {} | | ! (9 rows) SELECT * from ts_debug('english', '5aew.werc.ewr:8100/?xx'); ! alias | description | token | dictionaries | dictionary | lexemes ! -----------+-----------------+--------------+----------------+--------------+---------------- ! blank | Space symbols | 5 | {} | | ! host | Host | aew.werc.ewr | {simple} | simple | {aew.werc.ewr} ! blank | Space symbols | : | {} | | ! blank | Space symbols | 8 | {} | | ! blank | Space symbols | 1 | {} | | ! blank | Space symbols | 0 | {} | | ! blank | Space symbols | 0 | {} | | ! blank | Space symbols | /? | {} | | ! asciiword | Word, all ASCII | xx | {english_stem} | english_stem | {xx} ! (9 rows) -- to_tsquery SELECT to_tsquery('english', 'qwe & sKies '); *************** *** 519,527 **** (1 row) SELECT plainto_tsquery('english', 'the and z 1))& fghj'); ! plainto_tsquery ! -------------------- ! 'z' & '1' & 'fghj' (1 row) SELECT plainto_tsquery('english', 'foo bar') && plainto_tsquery('english', 'asd'); --- 599,607 ---- (1 row) SELECT plainto_tsquery('english', 'the and z 1))& fghj'); ! plainto_tsquery ! ----------------- ! 'z' & 'fghj' (1 row) SELECT plainto_tsquery('english', 'foo bar') && plainto_tsquery('english', 'asd'); *************** *** 1061,1067 **** SELECT count(*) FROM test_tsvector WHERE a @@ to_tsquery('345&qwerty'); count ------- ! 1 (1 row) UPDATE test_tsvector SET t = null WHERE t = '345 qwerty'; --- 1141,1147 ---- SELECT count(*) FROM test_tsvector WHERE a @@ to_tsquery('345&qwerty'); count ------- ! 0 (1 row) UPDATE test_tsvector SET t = null WHERE t = '345 qwerty'; *************** *** 1075,1081 **** SELECT count(*) FROM test_tsvector WHERE a @@ to_tsquery('345&qwerty'); count ------- ! 1 (1 row) -- test finding items in GIN's pending list --- 1155,1161 ---- SELECT count(*) FROM test_tsvector WHERE a @@ to_tsquery('345&qwerty'); count ------- ! 0 (1 row) -- test finding items in GIN's pending list ====================================================================== *** /pub/devel/postgresql/postgresql-9.3beta1-1/src/postgresql-9.3beta1/src/test/regress/expected/without_oid.out 2013-05-06 22:57:06.000000000 +0200 --- /pub/devel/postgresql/postgresql-9.3beta1-1/build/src/test/regress/results/without_oid.out 2013-06-10 10:22:39.130668700 +0200 *************** *** 47,52 **** --- 47,53 ---- LINE 1: SELECT count(oid) FROM wo; ^ VACUUM ANALYZE wi; + WARNING: could not open statistics file "pg_stat_tmp/global.stat": Device or resource busy VACUUM ANALYZE wo; SELECT min(relpages) < max(relpages), min(reltuples) - max(reltuples) FROM pg_class ======================================================================