• unknown's avatar
    BUG#18036 - update of table joined to self reports table as crashed · 46cdd39e
    unknown authored
    Certain updates of table joined to self results in unexpected
    behavior.
    
    The problem was that record cache was mistakenly enabled for
    self-joined table updates. Normally record cache must be disabled
    for such updates.
    
    Fixed wrong condition in code that determines whether to use
    record cache for self-joined table updates.
    
    Only MyISAM tables were affected.
    
    
    mysql-test/r/myisam.result:
      Test case for BUG#18036.
    mysql-test/t/myisam.test:
      Test case for BUG#18036.
    sql/sql_update.cc:
      Fixed wrong condition in code that determines whether to use
      record cache for self-joined table updates.
    46cdd39e
sql_update.cc 37.2 KB