• unknown's avatar
    allow UPDATE and DELETE stetements with tables derived from subquery if they... · fbf563e8
    unknown authored
    allow UPDATE and DELETE stetements with tables derived from subquery if they are not updated (BUG#2117)
    allow delete table by alias in multi-delete statement
    
    
    
    include/mysqld_error.h:
      new error message about non-updateable table
    mysql-test/r/derived.result:
      test of multi-update and multi-delete
    mysql-test/t/derived.test:
      test of multi-update and multi-delete
    sql/share/czech/errmsg.txt:
      new error message about non-updateable table
    sql/share/danish/errmsg.txt:
      new error message about non-updateable table
    sql/share/dutch/errmsg.txt:
      new error message about non-updateable table
    sql/share/english/errmsg.txt:
      new error message about non-updateable table
    sql/share/estonian/errmsg.txt:
      new error message about non-updateable table
    sql/share/french/errmsg.txt:
      new error message about non-updateable table
    sql/share/german/errmsg.txt:
      new error message about non-updateable table
    sql/share/greek/errmsg.txt:
      new error message about non-updateable table
    sql/share/hungarian/errmsg.txt:
      new error message about non-updateable table
    sql/share/italian/errmsg.txt:
      new error message about non-updateable table
    sql/share/japanese/errmsg.txt:
      new error message about non-updateable table
    sql/share/korean/errmsg.txt:
      new error message about non-updateable table
    sql/share/norwegian-ny/errmsg.txt:
      new error message about non-updateable table
    sql/share/norwegian/errmsg.txt:
      new error message about non-updateable table
    sql/share/polish/errmsg.txt:
      new error message about non-updateable table
    sql/share/portuguese/errmsg.txt:
      new error message about non-updateable table
    sql/share/romanian/errmsg.txt:
      new error message about non-updateable table
    sql/share/russian/errmsg.txt:
      new error message about non-updateable table
    sql/share/serbian/errmsg.txt:
      new error message about non-updateable table
    sql/share/slovak/errmsg.txt:
      new error message about non-updateable table
    sql/share/spanish/errmsg.txt:
      new error message about non-updateable table
    sql/share/swedish/errmsg.txt:
      new error message about non-updateable table
    sql/share/ukrainian/errmsg.txt:
      new error message about non-updateable table
    sql/sql_parse.cc:
      allow delete table by alias
      separate error message for try to delete derived table
    sql/sql_update.cc:
      test "is updated table derived?"
    sql/sql_yacc.yy:
      error message in case of try to update derived table
    fbf563e8
sql_update.cc 29.8 KB