• Konstantin Osipov's avatar
    Backport of: · 5a4f8e21
    Konstantin Osipov authored
    ------------------------------------------------------------
     2599.161.3 Ingo Struewing      2009-07-21
     Bug#20667 - Truncate table fails for a write locked table
    
     TRUNCATE TABLE was not allowed under LOCK TABLES.
    
     The patch removes this restriction. mysql_truncate()
     does now handle that case.
    
    
    mysql-test/r/merge.result:
      Bug#20667 - Truncate table fails for a write locked table
      Updated test result.
    mysql-test/r/truncate.result:
      Bug#20667 - Truncate table fails for a write locked table
      Updated test result.
    mysql-test/r/truncate_coverage.result:
      Bug#20667 - Truncate table fails for a write locked table
      New test result.
    mysql-test/t/merge.test:
      Bug#20667 - Truncate table fails for a write locked table
      Updated test case due to now working TRUNCATE under LOCK TABLES.
      Added some SELECTs to show that child tables are truncated.
    mysql-test/t/truncate.test:
      Bug#20667 - Truncate table fails for a write locked table
      Added test cases for TRUNCATE under LOCK TABLE.
    mysql-test/t/truncate_coverage.test:
      Bug#20667 - Truncate table fails for a write locked table
      New test file. Coverage tests for TRUNCATE.
    sql/sql_delete.cc:
      Bug#20667 - Truncate table fails for a write locked table
      Added branches for thd->locked_tables_mode.
    sql/sql_parse.cc:
      Bug#20667 - Truncate table fails for a write locked table
      Deleted rejection of TRUNCATE in case of LOCK TABLES.
    5a4f8e21
truncate.test 3.34 KB