Re: BUG #8970: ts_parse incorrectly split numbers in digit token

On Sat, Jan 25, 2014 at 06:50:24AM +0000, marco(dot)atzeri(at)gmail(dot)com wrote:
> The following bug has been logged on the website:
>
> Bug reference: 8970
> Logged by: Marco Atzeri
> Email address: marco(dot)atzeri(at)gmail(dot)com
> PostgreSQL version: 9.3.2
> Operating system: Cygwin
> Description:
>
> Extract from failure comparison.
>
> =====================================
> ---
> /pub/devel/postgresql/postgresql-9.3.2-1/src/postgresql-9.3.2/src/test/regress/expected/tsearch.out
> 2013-12-02 21:57:48.000000000 +0100
> +++
> /pub/devel/postgresql/postgresql-9.3.2-1/build/src/test/regress/results/tsearch.out
> 2014-01-24 19:36:27.625466800 +0100
> @@ -267,10 +267,11 @@
> SELECT * FROM ts_parse('default', '345 qwe(at)efd(dot)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(at)stack(dot)net qwe-wer asdf <fr>qwer jf sdjk<we hjwer <werrwe> ewr1>
> ewri2 <a href="qwe<qwe>">
> /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
> <i <b> wow < jqw <> qwerty');
> - tokid | token
> --------+--------------------------------------
> - 22 | 345
> - 12 |
> + tokid | token
> +-------+-------------------------
> + 12 | 3
> + 12 | 4
> + 12 | 5

Uh, there are some known problems with Cygwin, particularly with text
search. I don't think anyone knows the cause, but I think it is problem
in the Cygwin platform.

Here is a thread that mentions the issue:

http://www.postgresql.org/message-id/51B59794.3000500@gmail.com

and here is a comment about the failures:

http://www.postgresql.org/message-id/52E1EBD0.4090304@dunslane.net

AFAICT the regression is in Cygwin. The buildfarm passes because it's
using an oldish Cygwin release, 1.7.7 rather than the current 1.7.27. I
have brought the regression the athe attention of the Cygwin people in
the past, but without response.

--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com

+ Everyone has their own god. +