• T
    Adjust timestamp regression tests to prevent two low-probability failure · 8c2ac75c
    Tom Lane 提交于
    cases.  Recent buildfarm experience shows that it is sometimes possible
    to execute several SQL commands in less time than the granularity of
    Windows' not-very-high-resolution gettimeofday(), leading to a failure
    because the tests expect the value of now() to change and it doesn't.
    Also, it was recognized some time ago that the same area of the tests
    could fail if local midnight passes between the insertion and the checking
    of the values for 'yesterday', 'tomorrow', etc.  Clean all this up per
    ideas from myself and Greg Stark.
    
    There remains a window for failure if the transaction block is entered
    exactly at local midnight (so that 'now' and 'today' have the same value),
    but that seems low-probability enough to live with.
    
    Since the point of this change is mostly to eliminate buildfarm noise,
    back-patch to all versions we are still actively testing.
    8c2ac75c
timestamp.sql 11.3 KB