~drizzle-trunk/drizzle/development : contents of tests/r/mysql

~drizzle-trunk/drizzle/development : (revision 2200.2.15)

browse files
view without revision information
view revision
view changes to this file
download file

CREATE TABLE t1 (a int);
CREATE TABLE t3 (a int);
FLUSH TABLES WITH READ LOCK;
RENAME TABLE t1 TO t2, t3 to t4;
show tables;
Tables_in_test
t1
t3
UNLOCK TABLES;
show tables;
Tables_in_test
t2
t4
drop table t2, t4;

673.3.12 by Stewart Smith fix RENAME TABLE	1	CREATE TABLE t1 (a int);
	2	CREATE TABLE t3 (a int);
	3	FLUSH TABLES WITH READ LOCK;
	4	RENAME TABLE t1 TO t2, t3 to t4;
	5	show tables;
	6	Tables_in_test
	7	t1
	8	t3
	9	UNLOCK TABLES;
	10	show tables;
	11	Tables_in_test
	12	t2
	13	t4
	14	drop table t2, t4;