• Monty's avatar
    MDEV-30256 Wrong result (missing rows) upon join with empty table · 9a4110aa
    Monty authored
    The problem was an assignment in test_quick_select() that flagged empty
    tables with "Impossible where". This test was however wrong as it
    didn't work correctly for left join.
    
    Removed the test, but added checking of empty tables in DELETE and UPDATE
    to get similar EXPLAIN as before.
    
    The new tests is a bit more strict (better) than before as it catches all
    cases of empty tables in single table DELETE/UPDATE.
    9a4110aa
binlog_unsafe.result 188 KB