Re: [HACKERS] tsvector/tsearch equality and/or portability issue

comparing the same vectors, but stripped. Oddly, the unstripped comparisons all pass, which is not consistant with what I am seeing in my database. However, I'm yet unable to reproduce those problems. Fixed: strncmp was called with wrong length parameter. It looks to me like tsvector comparis

Re: [HACKERS] tsvector/tsearch equality and/or portability issue

Phil Frost <[EMAIL PROTECTED]> writes: > Things still seem to be broken for me. Among other things, the script at > fails. It performs two > tests, comparing 1000 random vectors with positions and random weights, and > comparing the same vectors, b

Re: [HACKERS] tsvector/tsearch equality and/or portability issue

On Thu, Aug 24, 2006 at 09:40:13PM +0400, Teodor Sigaev wrote: > >devel=# select 'blah foo bar'::tsvector = 'blah foo bar'::tsvector; > > ?column? > >-- > > f > >(1 row) > > Fixed in 8.1 and HEAD. Thank you Things still seem to be broken for me. Among other things, the script at

Re: [HACKERS] tsvector/tsearch equality and/or portability issue

Oops. Fixed. Tom Lane wrote: Teodor Sigaev <[EMAIL PROTECTED]> writes: Fixed in 8.1 and HEAD. Thank you This appears to have created a regression test failure: *** ./expected/tsearch2.out Sun Jun 18 12:55:28 2006 --- ./results/tsearch2.out Thu Aug 24 14:30:02 2006 *** **

Re: [HACKERS] tsvector/tsearch equality and/or portability issue

"Joshua D. Drake" <[EMAIL PROTECTED]> writes: >>> Can some other people try this? We need to get a handle on which >>> machines show the problem. >> >> I am trying on current copy of HEAD.. however: Looks like Teodor already solved the problem, so no need for a fire drill anymore.

Re: [HACKERS] tsvector/tsearch equality and/or portability issue

Teodor Sigaev <[EMAIL PROTECTED]> writes: > Fixed in 8.1 and HEAD. Thank you This appears to have created a regression test failure: *** ./expected/tsearch2.out Sun Jun 18 12:55:28 2006 --- ./results/tsearch2.out Thu Aug 24 14:30:02 2006 *** *** 2496,2503 f|

Re: [HACKERS] tsvector/tsearch equality and/or portability issue

Can some other people try this? We need to get a handle on which machines show the problem. I am trying on current copy of HEAD.. however: Ignore the below... This is an error with my linker/ld.so.conf Joshua D. Drake [EMAIL PROTECTED]:~/pgsqldev$ bin/psql -U postgres postgres < share/

Re: [HACKERS] tsvector/tsearch equality and/or portability issue

Can some other people try this? We need to get a handle on which machines show the problem. [EMAIL PROTECTED]:~/pgsqldev$ /usr/local/pgsql/bin/psql -U postgres postgres Welcome to psql 8.1.3, the PostgreSQL interactive terminal. Type: \copyright for distribution terms \h for help wit

Re: [HACKERS] tsvector/tsearch equality and/or portability issue

Tom Lane wrote: "Andrew J. Kopciuch" <[EMAIL PROTECTED]> writes: On Thursday 24 August 2006 10:34, Stefan Kaltenbrunner wrote: devel=# select 'blah foo bar'::tsvector = 'blah foo bar'::tsvector; ?column? -- f (1 row) This could be an endianess issue? Apparently not, it works for me

Re: [HACKERS] tsvector/tsearch equality and/or portability issue

Stefan said he reproduced on OpenBSD/i386 so it is unlikely to be an endianness issue. Anyway, here's the comparison code- I guess it doesn't use strcmp to avoid encoding silliness. (?) I suppose that ordering for tsvector type is some strange and it hasn't any matter. For me, it's a secret wh

Re: [HACKERS] tsvector/tsearch equality and/or portability issue

Teodor Sigaev wrote: >> devel=# select 'blah foo bar'::tsvector = 'blah foo bar'::tsvector; >> ?column? >> -- >> f >> (1 row) > > Fixed in 8.1 and HEAD. Thank you thanks for the fast response - would it maybe be worthwhile to add regression tests for this kind of thing though ? Stefan

Re: [HACKERS] tsvector/tsearch equality and/or portability issue issue ?

"Andrew J. Kopciuch" <[EMAIL PROTECTED]> writes: > On Thursday 24 August 2006 10:34, Stefan Kaltenbrunner wrote: >> devel=# select 'blah foo bar'::tsvector = 'blah foo bar'::tsvector; >> ?column? >> -- >> f >> (1 row) > This could be an endianess issue? Apparently not, it works for me on

Re: [HACKERS] tsvector/tsearch equality and/or portability issue issue ?

On Aug 24, 2006, at 12:58 , Andrew J. Kopciuch wrote: On Thursday 24 August 2006 10:34, Stefan Kaltenbrunner wrote: We just had a complaint on IRC that: devel=# select 'blah foo bar'::tsvector = 'blah foo bar'::tsvector; ?column? -- f (1 row) This could be an endianess issue? T

Re: [HACKERS] tsvector/tsearch equality and/or portability issue

devel=# select 'blah foo bar'::tsvector = 'blah foo bar'::tsvector; ?column? -- f (1 row) Fixed in 8.1 and HEAD. Thank you -- Teodor Sigaev E-mail: [EMAIL PROTECTED] WWW: http://www.sigaev.ru/ --

Re: [HACKERS] tsvector/tsearch equality and/or portability issue issue ?

On Thursday 24 August 2006 10:34, Stefan Kaltenbrunner wrote: > We just had a complaint on IRC that: > > devel=# select 'blah foo bar'::tsvector = 'blah foo bar'::tsvector; > ?column? > -- > f > (1 row) > This could be an endianess issue? This was probably the same person who posted th

[HACKERS] tsvector/tsearch equality and/or portability issue issue ?

We just had a complaint on IRC that: devel=# select 'blah foo bar'::tsvector = 'blah foo bar'::tsvector; ?column? -- f (1 row) and that searches for certain values would not return all matches under some circumstances. a little bit of testing shows the following: postgres=# create tab