• Tom Lane's avatar
    Fix potential platform dependence in gist regression test. · e39c4afc
    Tom Lane authored
    The results of the KNN-search test cases were indeterminate, as they asked
    the system to sort pairs of points that are exactly equidistant from the
    query reference point.  It's a bit surprising that we've seen no
    platform-specific failures from this in the buildfarm.  Perhaps IEEE-float
    math is well enough standardized that no such failures will ever occur on
    supported platforms ... but since this entire regression test has yet to be
    shipped in any non-alpha release, that seems like an unduly optimistic
    assumption.  Tweak the queries so that the correct output is uniquely
    defined.
    
    (The other queries in this test are also underdetermined; but it looks like
    they are regurgitating index rows in insertion order, so for the moment
    assume that that behavior is stable enough.)
    
    Per Greg Stark's experiments with VAX.  Back-patch to 9.5 where this test
    script was introduced.
    e39c4afc
gist.sql 3.06 KB