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 <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 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. It's worth noting that in running this script I have seen the number of failures change, which seems to indicate that some uninitialized memory is still being compared. test=# \i testvectors.sql BEGIN CREATE FUNCTION CREATE TABLE total vectors in test set --------------------------- 1000 (1 row) failing unstripped equality ----------------------------- 0 (1 row) failing stripped equality --------------------------- 389 (1 row) ROLLBACK test=# ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
