← Back to branch summary

~ubuntu-branches/ubuntu/maverick/mysql-5.1/maverick-proposed

« back to all changes in this revision

Viewing changes to mysql-test/r/log_tables.result

  • Committer: Package Import Robot
  • Author(s): Marc Deslauriers
  • Date: 2012-02-22 14:16:05 UTC
  • mto: This revision was merged to the branch mainline in revision 20.
  • Revision ID: package-import@ubuntu.com-20120222141605-nxlu9yzc6attylc2
Tags: upstream-5.1.61
Import upstream version 5.1.61

Show diffs side-by-side

added added

removed removed

Lines of Context:
mysql-test/r/log_tables.result
899
899
TIMESTAMP       1       1       SELECT SQL_NO_CACHE 'Bug#31700 - PK',  f1,f2,f3,SLEEP(1.1) FROM t1 WHERE f1=2
900
900
DROP TABLE t1;
901
901
TRUNCATE TABLE mysql.slow_log;
 
902
use mysql;
 
903
drop table if exists renamed_general_log;
 
904
drop table if exists renamed_slow_log;
 
905
RENAME TABLE general_log TO renamed_general_log;
 
906
ERROR HY000: Cannot rename 'general_log'. When logging enabled, rename to/from log table must rename two tables: the log table to an archive table and another table back to 'general_log'
 
907
RENAME TABLE slow_log TO renamed_slow_log;
 
908
ERROR HY000: Cannot rename 'slow_log'. When logging enabled, rename to/from log table must rename two tables: the log table to an archive table and another table back to 'slow_log'
 
909
use test;
 
910
flush tables with read lock;
 
911
unlock tables;
902
912
SET @@session.long_query_time= @old_long_query_time;
903
913
SET @@global.log_output=       @old_log_output;
904
914
SET @@global.slow_query_log=   @old_slow_query_log;