• Anurag Shekhar's avatar
    Bug #39918 memory (heap) engine crashing with b-tree index and DELETE · 609a794b
    Anurag Shekhar authored
             with seg fault
    
    Multiple-table DELETE from a table joined to itself may cause
    server crash. This was originally discovered with MEMORY engine,
    but may affect other engines with different symptoms.
    
    The problem was that the server violated SE API by performing
    parallel table scan in one handler and removing records in
    another (delete on the fly optimization).
    
    
    mysql-test/r/heap_btree.result:
      Updated test result after adding new test for this bug.
    mysql-test/t/heap_btree.test:
      Updated test result after adding new test for the bug report.
    sql/sql_delete.cc:
      Updated to check if the files in delete list appears in join list and disable 
      delete while scanning, if it appears.
    609a794b
sql_delete.cc 28.9 KB