• Igor Babaev's avatar
    Fixed the problem of mdev-5970: · 12eb6d88
    Igor Babaev authored
    back-ported the patch for bug #13256831 from mysql-5.6 code line.
    
      Here's the comment this patch was provided with:
    
      Fixed bug#13256831 - ERROR 1032 (HY000): CAN'T FIND RECORD.
    
      This bug only occurs if a user tries to update a base table using
      an updatable view and this view was created as a join for which
      the clause 'WITH CHECK OPTION' was specified.
    
      The reason for the bug was that when such an update was
      executed, row positions were not properly handled for tables
      that were not updated but had constraints that had to be
      checked due to the 'WITH CHECK OPTION' clause.
    
      The reason for the bug was that when such update is executed
      then for tables specified in the view definition and
      also listed in the 'WITH CHECK OPTION' clause the positioning to
      row being updated is not performed.
    12eb6d88
multi_update.test 24.6 KB