logilab-database #288604 fti test fails with random hash seed [validation pending]

with PYTHONHASHSEED=random, we sometimes get:

======================================================================
FAIL: test_fulltext_search2 (unittest_fti.IndexerTC)
----------------------------------------------------------------------
Traceback (most recent call last)
  File "/home/jcr/src/cw/logilab/common/testlib.py", line 645, in _proceed
    testfunc(*args, **kwargs)
  File "/home/jcr/src/cw/logilab/database/test/unittest_fti.py", line 97, in test_fulltext_search2
    {'word1': 'jpl', 'word0': 'ginco'})
  File "/usr/lib/python2.7/unittest/case.py", line 513, in assertEqual
    assertion_func(first, second, msg=msg)
  File "/usr/lib/python2.7/unittest/case.py", line 742, in assertListEqual
    self.assertSequenceEqual(list1, list2, msg, seq_type=list)
  File "/usr/lib/python2.7/unittest/case.py", line 724, in assertSequenceEqual
    self.fail(msg)
  File "/usr/lib/python2.7/unittest/case.py", line 410, in fail
    raise self.failureException(msg)
AssertionError: Lists differ: [('SELECT count(*) as rating, ... != [('SELECT count(*) as rating, ...

First differing element 0:
('SELECT count(*) as rating, appears0.uid FROM appears as appears0, word as word0, appears as appears1, word as word1 WHERE word0.word = %(word0)s  AND word0.word_id = appears0.word_id  AND word1.word = %(word1)s  AND word1.word_id = appears1.word_id  AND appears0.uid = appears1.uid  GROUP BY appears0.uid ;', {'word1': u'ginco', 'word0': u'jpl'})
('SELECT count(*) as rating, appears0.uid FROM appears as appears0, word as word0, appears as appears1, word as word1 WHERE word0.word = %(word0)s  AND word0.word_id = appears0.word_id  AND word1.word = %(word1)s  AND word1.word_id = appears1.word_id  AND appears0.uid = appears1.uid  GROUP BY appears0.uid ;', {'word1': 'jpl', 'word0': 'ginco'})

  [('SELECT count(*) as rating, appears0.uid FROM appears as appears0, word as word0, appears as appears1, word as word1 WHERE word0.word = %(word0)s  AND word0.word_id = appears0.word_id  AND word1.word = %(word1)s  AND word1.word_id = appears1.word_id  AND appears0.uid = appears1.uid  GROUP BY appears0.uid ;',
-   {'word0': u'jpl', 'word1': u'ginco'})]
?             - ^^^            - ^^^^^

+   {'word0': 'ginco', 'word1': 'jpl'})]
?              ^^^^^             ^^^
prioritynormal
typebug
done in1.13.3
load0.500
load left0.000
closed by#5f304b43d47c [ftiquery] make queries independent of hashing function
patch[ftiquery] make queries independent of hashing function [applied]