• Tom Lane's avatar
    Improve stability of identity.sql regression test. · e8997420
    Tom Lane authored
    I noticed while trying to run the regression tests under a low
    geqo_threshold that one query on information_schema.columns had
    unstable (as in, variable from one run to the next) output order.
    This is pretty unsurprising given the complexity of the underlying
    plan.  Interestingly, of this test's three nigh-identical queries on
    information_schema.columns, the other two already had ORDER BY clauses
    guaranteeing stable output.  Let's make this one look the same.
    
    Back-patch to v10 where this test was added.  We've not heard field
    reports of the test failing, but this experience shows that it can
    happen when testing under even slightly unusual conditions.
    e8997420
identity.out 18.3 KB