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

2006-08-29 Thread Teodor Sigaev
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

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

2006-08-28 Thread Phil Frost
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

2006-08-28 Thread Tom Lane
Phil Frost [EMAIL PROTECTED] writes: Things still seem to be broken for me. Among other things, the script at http://unununium.org/~indigo/testvectors.sql.bz2 fails. It performs two tests, comparing 1000 random vectors with positions and random weights, and comparing the same vectors, but

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

2006-08-25 Thread Teodor Sigaev
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 issue ?

2006-08-24 Thread Andrew J. Kopciuch
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 this on

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

2006-08-24 Thread Teodor Sigaev
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 ?

2006-08-24 Thread AgentM
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?

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

2006-08-24 Thread Tom Lane
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 HPPA (big

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

2006-08-24 Thread Stefan Kaltenbrunner
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

2006-08-24 Thread Teodor Sigaev
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

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

2006-08-24 Thread Joshua D. Drake
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 on

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

2006-08-24 Thread Joshua D. Drake
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

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

2006-08-24 Thread Joshua D. Drake
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

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

2006-08-24 Thread Tom Lane
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

2006-08-24 Thread Tom Lane
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.