← Back to branch summary

~vadim-tk/percona-server/percona-galera-5.1.57-0.8.1

« back to all changes in this revision

Viewing changes to mysql-test/suite/engines/funcs/t/tc_rename_error.test

  • Committer: root
  • Date: 2011-07-28 00:14:23 UTC
  • Revision ID: root@r815.office.percona.com-20110728001423-6pw0v4b7r0dkbsr4
Ported to Galera 0.8.1

Show diffs side-by-side

added added

removed removed

Lines of Context:
mysql-test/suite/engines/funcs/t/tc_rename_error.test
 
1
--disable_warnings
 
2
DROP TABLE IF EXISTS t1,t2;
 
3
--enable_warnings
 
4
CREATE TABLE t1(c1 INTEGER NULL);
 
5
CREATE TABLE t2(c1 INTEGER NULL);
 
6
SHOW TABLES; 
 
7
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 
 
8
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
 
9
 SHOW CREATE TABLE t1; 
 
10
--error 1050
 
11
RENAME TABLE t2 TO t1;
 
12
--error 1050
 
13
RENAME TABLE t3 TO t1;
 
14
--error 1017
 
15
RENAME TABLE t3 TO doesnotexist.t1;
 
16
SHOW TABLES; 
 
17
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 
 
18
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
 
19
 SHOW CREATE TABLE t1;
 
20
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 
 
21
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
 
22
SHOW CREATE TABLE t2;
 
23
DROP TABLE t2;
 
24
SHOW TABLES;
 
25
 
 
26
DROP TABLE t1;