• unknown's avatar
    fixed mechanism of detection selection from table wich we update · daddf263
    unknown authored
    (BUG##9398, BUG#8703)
    fixed wrong join view detection in multi-delete which lead to server crash
    
    
    mysql-test/r/lowercase_view.result:
      added new tests of updation and selection from the same table
    mysql-test/r/view.result:
      added new tests of updation and selection from the same table
      added test of multidelete command over join view which lead to server crash
      test suite from bugs #9398 and #8703
    mysql-test/t/lowercase_view.test:
      added new tests of updation and selection from the same table
    mysql-test/t/view.test:
      added new tests of updation and selection from the same table
      added test of multidelete command over join view which lead to server crash
      test suite from bugs #9398 and #8703
    sql/sql_base.cc:
      changed procedure of finding tables
    sql/sql_class.cc:
      added derived table procession detection
    sql/sql_class.h:
      added derived table procession detection
    sql/sql_delete.cc:
      fixed detection of selection from table which update for multidelete
    sql/sql_derived.cc:
      added derived table procession detection
    sql/sql_lex.cc:
      added detection os SELECTs processed inside derived tables
      removed old mechanism of multidelete/multiupdate table duplication detection (which can't work with views)
    sql/sql_lex.h:
      added detection os SELECTs processed inside derived tables
      removed old mechanism of multidelete/multiupdate table duplication detection (which can't work with views)
    sql/sql_parse.cc:
      removed wrong test of join view (for multidelete in can be not only first table)
    sql/sql_prepare.cc:
      added detection os SELECTs processed inside derived tables (reset it for reusing in PS/SP)
    sql/sql_select.cc:
      added detection os SELECTs processed inside derived tables
    sql/sql_update.cc:
      fixed detection of selection from table which update for multiupdate
    daddf263
sql_delete.cc 22.2 KB