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

On Sat, Jan 25, 2014 at 06:50:24AM +0000, marco.atzeri@gmail.com wrote:
> The following bug has been logged on the website:
>
> Bug reference:      8970
> Logged by:          Marco Atzeri
> Email address:      marco.atzeri@gmail.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@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 <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@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + Everyone has their own god. +