1. 04 Apr, 2007 1 commit
    • mskold/marty@mysql.com/linux.site's avatar
      Bug #26242 UPDATE with subquery and triggers failing with cluster tables · 625a2629
      mskold/marty@mysql.com/linux.site authored
      In certain cases AFTER UPDATE/DELETE triggers on NDB tables that referenced
      subject table didn't see the results of operation which caused invocation
      of those triggers. In other words AFTER trigger invoked as result of update
      (or deletion) of particular row saw version of this row before update (or
      deletion).
      
      The problem occured because NDB handler in those cases postponed actual
      update/delete operations to be able to perform them later as one batch.
      
      This fix solves the problem by disabling this optimization for particular
      operation if subject table has AFTER trigger for this operation defined.
      To achieve this we introduce two new flags for handler::extra() method:
      HA_EXTRA_DELETE_CANNOT_BATCH and HA_EXTRA_UPDATE_CANNOT_BATCH.
      These are called if there exists AFTER DELETE/UPDATE triggers during a
      statement that potentially can generate calls to delete_row()/update_row().
      This includes multi_delete/multi_update statements as well as insert statements
      that do delete/update as part of an ON DUPLICATE statement.
      625a2629
  2. 09 Feb, 2007 1 commit
  3. 07 Feb, 2007 2 commits
  4. 06 Feb, 2007 1 commit
  5. 01 Feb, 2007 1 commit
  6. 31 Jan, 2007 1 commit
  7. 08 Jan, 2007 2 commits
  8. 03 Jan, 2007 1 commit
  9. 02 Jan, 2007 1 commit
  10. 15 Dec, 2006 1 commit
  11. 14 Dec, 2006 1 commit
  12. 07 Dec, 2006 2 commits
  13. 30 Nov, 2006 3 commits
  14. 29 Nov, 2006 1 commit
  15. 13 Nov, 2006 1 commit
  16. 07 Nov, 2006 1 commit
  17. 06 Nov, 2006 2 commits
  18. 01 Nov, 2006 1 commit
  19. 31 Oct, 2006 2 commits
  20. 27 Oct, 2006 4 commits
  21. 25 Oct, 2006 9 commits
  22. 24 Oct, 2006 1 commit