• Kristian Nielsen's avatar
    MDEV-20169: main.partition_innodb fails in buildbot with wrong result · 705f7ab6
    Kristian Nielsen authored
    The problem is that background statistics can race with statistics update
    during INSERT and cause slightly inaccurate `Rows` count in table statistics
    (this is deliberate to avoid excessive locking overhead). This was seen as
    occasional .result difference in the test.
    
    Mask out the unstable `Rows` column from SHOW TABLE STATUS; the value is not
    related to what is being tested in this part of the test case.
    
    Run ANALYZE TABLE before SHOW EXPLAIN to get stable row count in output.
    Signed-off-by: default avatarKristian Nielsen <knielsen@knielsen-hq.org>
    705f7ab6
partition_innodb.result 38.3 KB