From 8adce14f700e4f4aa0495bc15ee163c528d78ffe Mon Sep 17 00:00:00 2001 From: unknown Date: Wed, 18 Jan 2006 00:45:23 +0100 Subject: Updated test cases for testing Cluster Replication using the rpl* test cases mysql-test/t/rpl_row_USER.test: Changed test to allow ndbcluster engine to be use mysql-test/r/rpl_row_USER.result: Changed test to allow ndbcluster engine to be use mysql-test/t/rpl_bit.test: Changed test to allow ndbcluster engine to be use mysql-test/r/rpl_bit.result: Changed test to allow ndbcluster engine to be use mysql-test/r/rpl_log_pos.result: Changed test to allow ndbcluster engine to be use mysql-test/t/rpl_log_pos.test: Changed test to allow ndbcluster engine to be use mysql-test/r/not_ndb_table.require: Needed a way to tell some test case to skip running it default-storage-engine was set to ndb mysql-test/t/rpl_000015.test: Updated test case mysql-test/r/rpl_000015.result: Updated test case mysql-test/t/rpl_loaddata2.test: Updated test case mysql-test/r/rpl_loaddata2.result: Updated test case mysql-test/t/rpl_loadfile.test: Updated test case mysql-test/r/rpl_loadfile.result: Updated test case mysql-test/include/not_ndb_table.inc: added comment header. mysql-test/t/rpl_foreign_key_innodb.test: Skip test when NDB is forced mysql-test/t/rpl_optimize.test: Skip test when NDB is forced mysql-test/t/rpl000005.test: updated test case mysql-test/r/rpl000005.result: updated test case mysql-test/t/rpl_user_variables.test: Test clean up for CRBR testing mysql-test/r/rpl_user_variables.result: Test clean up for CRBR testing mysql-test/r/rpl_timezone.result: Test clean up for CRBR testing mysql-test/t/rpl_timezone.test: Test clean up for CRBR testing --- mysql-test/t/rpl000005.test | 9 +++++++-- 1 file changed, 7 insertions(+), 2 deletions(-) (limited to 'mysql-test/t/rpl000005.test') diff --git a/mysql-test/t/rpl000005.test b/mysql-test/t/rpl000005.test index e81ad739402..0a2b7f9458a 100644 --- a/mysql-test/t/rpl000005.test +++ b/mysql-test/t/rpl000005.test @@ -1,3 +1,8 @@ +#################### +# Change Author: JBM +# Change Date: 2006-01-17 +# Change: Added order by in select +#################### source include/master-slave.inc; # @@ -10,11 +15,11 @@ INSERT INTO t1 SET name='Andy', age=31; INSERT t1 SET name='Jacob', age=2; INSERT into t1 SET name='Caleb', age=1; ALTER TABLE t1 ADD id int(8) ZEROFILL AUTO_INCREMENT PRIMARY KEY; -select * from t1; +SELECT * FROM t1 ORDER BY id; save_master_pos; connection slave; sync_with_master; -select * from t1; +SELECT * FROM t1 ORDER BY id; connection master; drop table t1; save_master_pos; -- cgit v1.2.1