Below is the list of changes that have just been committed into a local
5.1 repository of ndbdev. When ndbdev does a push these changes will
be propagated to the main repository and, within 24 hours after the
push, to the public repository.
For information on how to access the public repository
see http://dev.mysql.com/doc/mysql/en/installing-source-tree.html
ChangeSet
1.2058 06/01/18 00:45:23 jmiller@stripped +22 -0
Updated test cases for testing Cluster Replication using the rpl* test cases
mysql-test/t/rpl_timezone.test
1.13 06/01/18 00:43:31 jmiller@stripped +19 -14
Test clean up for CRBR testing
mysql-test/r/rpl_timezone.result
1.16 06/01/18 00:43:22 jmiller@stripped +13 -13
Test clean up for CRBR testing
mysql-test/r/rpl_user_variables.result
1.17 06/01/18 00:23:27 jmiller@stripped +32 -32
Test clean up for CRBR testing
mysql-test/t/rpl_user_variables.test
1.16 06/01/18 00:23:18 jmiller@stripped +9 -2
Test clean up for CRBR testing
mysql-test/r/rpl000005.result
1.13 06/01/17 20:39:49 jmiller@stripped +2 -2
updated test case
mysql-test/t/rpl000005.test
1.15 06/01/17 20:39:36 jmiller@stripped +7 -2
updated test case
mysql-test/t/rpl_optimize.test
1.5 06/01/17 20:35:09 jmiller@stripped +7 -1
Skip test when NDB is forced
mysql-test/t/rpl_foreign_key_innodb.test
1.2 06/01/17 20:25:17 jmiller@stripped +5 -0
Skip test when NDB is forced
mysql-test/include/not_ndb_table.inc
1.2 06/01/17 20:07:56 jmiller@stripped +5 -0
added comment header.
mysql-test/r/rpl_loadfile.result
1.2 06/01/17 19:44:50 jmiller@stripped +2 -9
Updated test case
mysql-test/t/rpl_loadfile.test
1.2 06/01/17 19:44:38 jmiller@stripped +7 -7
Updated test case
mysql-test/r/rpl_loaddata2.result
1.2 06/01/17 19:41:19 jmiller@stripped +20 -20
Updated test case
mysql-test/t/rpl_loaddata2.test
1.2 06/01/17 19:40:47 jmiller@stripped +8 -2
Updated test case
mysql-test/r/rpl_000015.result
1.36 06/01/17 19:37:54 jmiller@stripped +2 -2
Updated test case
mysql-test/t/rpl_000015.test
1.33 06/01/17 19:37:43 jmiller@stripped +8 -2
Updated test case
mysql-test/r/not_ndb_table.require
1.1 06/01/17 19:34:14 jmiller@stripped +2 -0
Needed a way to tell some test case to skip running it default-storage-engine was set to ndb
mysql-test/r/not_ndb_table.require
1.0 06/01/17 19:34:14 jmiller@stripped +0 -0
BitKeeper file /home/ndbdev/jmiller/clones/mysql-5.1-new/mysql-test/r/not_ndb_table.require
mysql-test/include/not_ndb_table.inc
1.1 06/01/17 19:34:02 jmiller@stripped +5 -0
Needed a way to tell some test case to skip running it default-storage-engine was set to ndb
mysql-test/include/not_ndb_table.inc
1.0 06/01/17 19:34:02 jmiller@stripped +0 -0
BitKeeper file /home/ndbdev/jmiller/clones/mysql-5.1-new/mysql-test/include/not_ndb_table.inc
mysql-test/t/rpl_log_pos.test
1.36 06/01/17 13:14:35 jmiller@stripped +7 -1
Changed test to allow ndbcluster engine to be use
mysql-test/r/rpl_log_pos.result
1.44 06/01/17 13:14:24 jmiller@stripped +1 -1
Changed test to allow ndbcluster engine to be use
mysql-test/r/rpl_bit.result
1.2 06/01/17 13:08:53 jmiller@stripped +24 -24
Changed test to allow ndbcluster engine to be use
mysql-test/t/rpl_bit.test
1.2 06/01/17 13:08:42 jmiller@stripped +10 -6
Changed test to allow ndbcluster engine to be use
mysql-test/r/rpl_row_USER.result
1.2 06/01/17 12:59:04 jmiller@stripped +2 -2
Changed test to allow ndbcluster engine to be use
mysql-test/t/rpl_row_USER.test
1.2 06/01/17 12:58:51 jmiller@stripped +6 -2
Changed test to allow ndbcluster engine to be use
# This is a BitKeeper patch. What follows are the unified diffs for the
# set of deltas contained in the patch. The rest of the patch, the part
# that BitKeeper cares about, is below these diffs.
# User: jmiller
# Host: ndb08.mysql.com
# Root: /home/ndbdev/jmiller/clones/mysql-5.1-new
--- 1.15/mysql-test/r/rpl_timezone.result 2005-12-22 19:57:01 +01:00
+++ 1.16/mysql-test/r/rpl_timezone.result 2006-01-18 00:43:22 +01:00
@@ -15,13 +15,13 @@
Europe/Moscow
insert into t1 values ('20050101000000', NULL), ('20050611093902',NULL);
insert into t1 values ('20040101000000',NULL), ('20040611093902',NULL);
-select * from t1;
+SELECT * FROM t1 ORDER BY n;
t n
2005-01-01 00:00:00 1
2005-06-11 09:39:02 2
2004-01-01 00:00:00 3
2004-06-11 09:39:02 4
-select * from t1;
+SELECT * FROM t1 ORDER BY n;
t n
2005-01-01 06:00:00 1
2005-06-11 14:39:02 2
@@ -30,12 +30,12 @@
delete from t1;
set time_zone='Europe/Moscow';
insert into t1 values ('20040101000000',NULL), ('20040611093902',NULL);
-select * from t1;
+SELECT * FROM t1 ORDER BY n;
t n
2004-01-01 00:00:00 5
2004-06-11 09:39:02 6
set time_zone='Europe/Moscow';
-select * from t1;
+SELECT * FROM t1 ORDER BY n;
t n
2004-01-01 00:00:00 5
2004-06-11 09:39:02 6
@@ -47,12 +47,12 @@
Warning 1261 Row 1 doesn't contain data for all columns
Warning 1265 Data truncated for column 't' at row 2
Warning 1261 Row 2 doesn't contain data for all columns
-select * from t1;
+SELECT * FROM t1 ORDER BY n;
t n
0000-00-00 00:00:00 7
0000-00-00 00:00:00 8
set time_zone='UTC';
-select * from t1;
+SELECT * FROM t1 ORDER BY n;
t n
0000-00-00 00:00:00 7
0000-00-00 00:00:00 8
@@ -62,18 +62,18 @@
insert into t1 values ('20040101000000',NULL), ('20040611093902',NULL);
set time_zone='MET';
insert into t2 (select * from t1);
-select * from t1;
+SELECT * FROM t1 ORDER BY n;
t n
2003-12-31 22:00:00 9
2004-06-11 07:39:02 10
-select * from t2;
+SELECT * FROM t2 ORDER BY n;
t n
2003-12-31 22:00:00 9
2004-06-11 07:39:02 10
delete from t2;
set timestamp=1000072000;
insert into t2 values (current_timestamp,NULL), (current_date,NULL), (current_time,NULL);
-select * from t2;
+SELECT * FROM t2 ORDER BY n;
t n
2001-09-09 23:46:40 11
2001-09-09 12
@@ -81,11 +81,11 @@
delete from t2;
insert into t2 values (from_unixtime(1000000000),NULL),
(unix_timestamp('2001-09-09 03:46:40'),NULL);
-select * from t2;
+SELECT * FROM t2 ORDER BY n;
t n
2001-09-09 03:46:40 14
1000000000 15
-select * from t2;
+SELECT * FROM t2 ORDER BY n;
t n
2001-09-09 03:46:40 14
1000000000 15
@@ -94,11 +94,11 @@
set time_zone='UTC';
insert into t2 values(convert_tz('2004-01-01 00:00:00','MET',@@time_zone),NULL);
insert into t2 values(convert_tz('2005-01-01 00:00:00','MET','Japan'),NULL);
-select * from t2;
+SELECT * FROM t2 ORDER BY n;
t n
2003-12-31 23:00:00 16
2005-01-01 08:00:00 17
-select * from t2;
+SELECT * FROM t2 ORDER BY n;
t n
2003-12-31 23:00:00 16
2005-01-01 08:00:00 17
--- 1.12/mysql-test/t/rpl_timezone.test 2005-12-22 19:59:25 +01:00
+++ 1.13/mysql-test/t/rpl_timezone.test 2006-01-18 00:43:31 +01:00
@@ -1,5 +1,10 @@
+#######################################
+# Change Author: JBM
+# Change Date: 2006-01-17
+# Change: Added order by
+#######################################
# Test of replication of time zones.
-
+######################################
# There is currently some bug possibly in prepared statements (this
# test fails with --ps-protocol): sys_var_thd_time_zone::value_ptr()
# is called only at prepare time, not at execution time. So,
@@ -32,10 +37,10 @@
#select @@time_zone;
insert into t1 values ('20050101000000', NULL), ('20050611093902',NULL);
insert into t1 values ('20040101000000',NULL), ('20040611093902',NULL);
-select * from t1;
+SELECT * FROM t1 ORDER BY n;
sync_slave_with_master;
#set time_zone='UTC';
-select * from t1;
+SELECT * FROM t1 ORDER BY n;
# Let us check also that setting of time_zone back to default also works
# well
@@ -43,10 +48,10 @@
delete from t1;
set time_zone='Europe/Moscow';
insert into t1 values ('20040101000000',NULL), ('20040611093902',NULL);
-select * from t1;
+SELECT * FROM t1 ORDER BY n;
sync_slave_with_master;
set time_zone='Europe/Moscow';
-select * from t1;
+SELECT * FROM t1 ORDER BY n;
connection master;
# Change Author: JBM
# Change Date: 2005-12-22
@@ -60,10 +65,10 @@
delete from t1;
set time_zone='UTC';
load data infile '../../std_data/rpl_timezone2.dat' into table t1;
-select * from t1;
+SELECT * FROM t1 ORDER BY n;
sync_slave_with_master;
set time_zone='UTC';
-select * from t1;
+SELECT * FROM t1 ORDER BY n;
set time_zone='Europe/Moscow';
# Put back values of before the LOAD
@@ -79,9 +84,9 @@
#
set time_zone='MET';
insert into t2 (select * from t1);
-select * from t1;
+SELECT * FROM t1 ORDER BY n;
sync_slave_with_master;
-select * from t2;
+SELECT * FROM t2 ORDER BY n;
#
# Now let us check how well we replicate various CURRENT_* functions
@@ -91,7 +96,7 @@
set timestamp=1000072000;
insert into t2 values (current_timestamp,NULL), (current_date,NULL), (current_time,NULL);
sync_slave_with_master;
-select * from t2;
+SELECT * FROM t2 ORDER BY n;
#
# At last let us check replication of FROM_UNIXTIME/UNIX_TIMESTAMP functions.
@@ -100,10 +105,10 @@
delete from t2;
insert into t2 values (from_unixtime(1000000000),NULL),
(unix_timestamp('2001-09-09 03:46:40'),NULL);
-select * from t2;
+SELECT * FROM t2 ORDER BY n;
sync_slave_with_master;
# We should get same result on slave as on master
-select * from t2;
+SELECT * FROM t2 ORDER BY n;
#
# Let us check that we are allowing to set global time_zone with
@@ -119,9 +124,9 @@
set time_zone='UTC';
insert into t2 values(convert_tz('2004-01-01 00:00:00','MET',@@time_zone),NULL);
insert into t2 values(convert_tz('2005-01-01 00:00:00','MET','Japan'),NULL);
-select * from t2;
+SELECT * FROM t2 ORDER BY n;
sync_slave_with_master;
-select * from t2;
+SELECT * FROM t2 ORDER BY n;
# Clean up
connection master;
--- 1.16/mysql-test/r/rpl_user_variables.result 2005-12-23 13:24:37 +01:00
+++ 1.17/mysql-test/r/rpl_user_variables.result 2006-01-18 00:23:27 +01:00
@@ -24,59 +24,59 @@
select * from t1 where n = '<nonexistant>';
n
insert into t1 values (@a),(@a),(@a*5);
-select * from t1;
+SELECT * FROM t1 ORDER BY n;
n
-12345678901234
--12345678901234
-0
--1
-12.5
--12.5
-This is a test
-
-abc'def
-abc\def
-abc'def
NULL
NULL
+NULL
+NULL
+NULL
+
+-1
+-12.5
+-12345678901234
+0
0
1
+12.5
+12345678901234
2
5
+5
+5
abc
+abc'def
+abc'def
abcn1
abcn1n2
-5
-5
+abc\def
+This is a test
+SELECT * FROM t1 ORDER BY n;
+n
NULL
NULL
NULL
-select * from t1;
-n
-12345678901234
--12345678901234
-0
--1
-12.5
--12.5
-This is a test
-
-abc'def
-abc\def
-abc'def
NULL
NULL
+
+-1
+-12.5
+-12345678901234
+0
0
1
+12.5
+12345678901234
2
5
+5
+5
abc
+abc'def
+abc'def
abcn1
abcn1n2
-5
-5
-NULL
-NULL
-NULL
+abc\def
+This is a test
drop table t1;
stop slave;
--- 1.15/mysql-test/t/rpl_user_variables.test 2005-12-23 13:23:55 +01:00
+++ 1.16/mysql-test/t/rpl_user_variables.test 2006-01-18 00:23:18 +01:00
@@ -1,6 +1,13 @@
+###################################
+# Change Author: JBM
+# Change Date: 2006-01-17
+# Change: Added order by
+###################################
#
# Test of replicating user variables
#
+###################################
+
-- source include/master-slave.inc
# Disable PS as the log positions differs
--disable_ps_protocol
@@ -44,9 +51,9 @@
select * from t1 where n = '<nonexistant>';
connection master1; # see if variable is reset in binlog when thread changes
insert into t1 values (@a),(@a),(@a*5);
-select * from t1;
+SELECT * FROM t1 ORDER BY n;
sync_slave_with_master;
-select * from t1;
+SELECT * FROM t1 ORDER BY n;
connection master;
drop table t1;
sync_slave_with_master;
--- 1.4/mysql-test/t/rpl_optimize.test 2005-09-15 16:17:20 +02:00
+++ 1.5/mysql-test/t/rpl_optimize.test 2006-01-17 20:35:09 +01:00
@@ -1,8 +1,14 @@
# Test for BUG#1858 "OPTIMIZE TABLE done by a client
# thread stops the slave SQL thread".
# You can replace OPTIMIZE by REPAIR.
+#####################################
+# Change Author: JBM
+# Change Date: 2006-01-17
+# Change: Skip test when default table = ndb
+#####################################
-source include/master-slave.inc;
+-- source include/not_ndb_table.inc
+-- source include/master-slave.inc
create table t1 (a int not null auto_increment primary key, b int, key(b));
INSERT INTO t1 (a) VALUES (1),(2),(3),(4),(5),(6),(7),(8),(9),(10);
--- New file ---
+++ mysql-test/include/not_ndb_table.inc 06/01/17 19:34:02
#######################
# Author: JBM
# Date: 2006-01-17
# Purpose: To skip a test when default-storage-engine=ndb
#######################
-- require r/not_ndb_table.require
disable_query_log;
show variables like "table_type";
enable_query_log;
--- New file ---
+++ mysql-test/r/not_ndb_table.require 06/01/17 19:34:14
Variable_name Value
table_type MyISAM
--- 1.1/mysql-test/r/rpl_bit.result 2005-12-22 06:34:51 +01:00
+++ 1.2/mysql-test/r/rpl_bit.result 2006-01-17 13:08:53 +01:00
@@ -65,36 +65,36 @@
5 5 3 2 1
5 5 3 2 1
5 5 3 2 1
-SELECT hex(bit1) from test.t1;
+SELECT hex(bit1) FROM test.t1 ORDER BY bit1;
hex(bit1)
-3F
-3F
0
-2A
0
0
0
0
-SELECT hex(bit2) from test.t1;
-hex(bit2)
-3E
-0
2A
3F
+3F
+SELECT hex(bit2) from test.t1 ORDER BY bit2;
+hex(bit2)
+0
1
1
1
1
-SELECT hex(bit3) from test.t1;
+2A
+3E
+3F
+SELECT hex(bit3) from test.t1 ORDER BY bit3;
hex(bit3)
-35
-24
-15
0
1
1
1
1
+15
+24
+35
SELECT oSupp, sSuppD, GSuppDf, VNotSupp, x034 FROM test.t1;
oSupp sSuppD GSuppDf VNotSupp x034
5 5 3 2 1
@@ -105,34 +105,34 @@
5 5 3 2 1
5 5 3 2 1
5 5 3 2 1
-SELECT hex(bit1) from test.t1;
+SELECT hex(bit1) FROM test.t1 ORDER BY bit1;
hex(bit1)
-3F
-3F
0
-2A
0
0
0
0
-SELECT hex(bit2) from test.t1;
-hex(bit2)
-3E
-0
2A
3F
+3F
+SELECT hex(bit2) from test.t1 ORDER BY bit2;
+hex(bit2)
+0
1
1
1
1
-SELECT hex(bit3) from test.t1;
+2A
+3E
+3F
+SELECT hex(bit3) from test.t1 ORDER BY bit3;
hex(bit3)
-35
-24
-15
0
1
1
1
1
+15
+24
+35
DROP TABLE IF EXISTS test.t1;
--- 1.1/mysql-test/r/rpl_loaddata2.result 2005-12-22 06:34:51 +01:00
+++ 1.2/mysql-test/r/rpl_loaddata2.result 2006-01-17 19:41:19 +01:00
@@ -6,27 +6,27 @@
start slave;
CREATE TABLE t1 (word CHAR(20) NOT NULL);
LOAD DATA INFILE '../../std_data/words.dat' INTO TABLE t1;
-SELECT * FROM t1;
+SELECT * FROM t1 ORDER BY word;
word
Aarhus
-Aaron
-Ababa
-aback
-abaft
-abandon
-abandoned
-abandoning
-abandonment
-abandons
Aarhus
Aaron
+Aaron
+Ababa
Ababa
aback
+aback
abaft
+abaft
+abandon
abandon
abandoned
+abandoned
+abandoning
abandoning
abandonment
+abandonment
+abandons
abandons
abase
abased
@@ -78,27 +78,27 @@
Abernathy
aberrant
aberration
-SELECT * FROM t1;
+SELECT * FROM t1 ORDER BY word;
word
Aarhus
-Aaron
-Ababa
-aback
-abaft
-abandon
-abandoned
-abandoning
-abandonment
-abandons
Aarhus
Aaron
+Aaron
+Ababa
Ababa
aback
+aback
abaft
+abaft
+abandon
abandon
abandoned
+abandoned
+abandoning
abandoning
abandonment
+abandonment
+abandons
abandons
abase
abased
--- 1.1/mysql-test/r/rpl_loadfile.result 2005-12-22 06:34:51 +01:00
+++ 1.2/mysql-test/r/rpl_loadfile.result 2006-01-17 19:44:50 +01:00
@@ -15,7 +15,7 @@
UPDATE test.t1 SET blob_column=LOAD_FILE('../../std_data/words2.dat') WHERE a=2;
end|
CALL test.p1();
-SELECT * FROM test.t1;
+SELECT * FROM test.t1 ORDER BY blob_column;
a blob_column
1 abase
abased
@@ -119,14 +119,7 @@
aberrant
aberration
-SHOW CREATE TABLE test.t1;
-Table Create Table
-t1 CREATE TABLE `t1` (
- `a` int(11) NOT NULL default '0',
- `blob_column` longblob,
- PRIMARY KEY (`a`)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1
-SELECT * FROM test.t1;
+SELECT * FROM test.t1 ORDER BY blob_column;
a blob_column
1 abase
abased
--- 1.1/mysql-test/r/rpl_row_USER.result 2005-12-22 06:34:52 +01:00
+++ 1.2/mysql-test/r/rpl_row_USER.result 2006-01-17 12:59:04 +01:00
@@ -19,13 +19,13 @@
INSERT INTO mysqltest1.t1 VALUES(4,CURRENT_USER());
end|
CALL mysqltest1.p1();
-SELECT * FROM mysqltest1.t1;
+SELECT * FROM mysqltest1.t1 ORDER BY a;
a users
1 tester@localhost
2 @localhost
3 tester@localhost
4 @localhost
-SELECT * FROM mysqltest1.t1;
+SELECT * FROM mysqltest1.t1 ORDER BY a;
a users
1 tester@localhost
2 @localhost
--- 1.1/mysql-test/t/rpl_bit.test 2005-12-22 06:34:59 +01:00
+++ 1.2/mysql-test/t/rpl_bit.test 2006-01-17 13:08:42 +01:00
@@ -4,6 +4,10 @@
#############################################################################
# Test: To test the replication of the bit field #
#############################################################################
+# Change Author: JBM
+# Change Date: 2006-01-16
+# Change: Added Order by for NDB
+##########
-- source include/master-slave.inc
@@ -71,17 +75,17 @@
SELECT oSupp, sSuppD, GSuppDf, VNotSupp, x034 FROM test.t1;
-SELECT hex(bit1) from test.t1;
-SELECT hex(bit2) from test.t1;
-SELECT hex(bit3) from test.t1;
+SELECT hex(bit1) FROM test.t1 ORDER BY bit1;
+SELECT hex(bit2) from test.t1 ORDER BY bit2;
+SELECT hex(bit3) from test.t1 ORDER BY bit3;
save_master_pos;
connection slave;
sync_with_master;
SELECT oSupp, sSuppD, GSuppDf, VNotSupp, x034 FROM test.t1;
-SELECT hex(bit1) from test.t1;
-SELECT hex(bit2) from test.t1;
-SELECT hex(bit3) from test.t1;
+SELECT hex(bit1) FROM test.t1 ORDER BY bit1;
+SELECT hex(bit2) from test.t1 ORDER BY bit2;
+SELECT hex(bit3) from test.t1 ORDER BY bit3;
connection master;
DROP TABLE IF EXISTS test.t1;
--- 1.1/mysql-test/t/rpl_foreign_key_innodb.test 2005-12-22 06:34:59 +01:00
+++ 1.2/mysql-test/t/rpl_foreign_key_innodb.test 2006-01-17 20:25:17 +01:00
@@ -1,6 +1,11 @@
###################################
# Wrapper for rpl_foreign_key.test#
###################################
+# Change Author: JBM
+# Change Date: 2006-01-17
+# Change: FK not supported, skip test when NDB is forced
+####################################
+-- source include/not_ndb_table.inc
-- source include/have_innodb.inc
let $engine_type=INNODB;
-- source extra/rpl_tests/rpl_foreign_key.test
--- 1.1/mysql-test/t/rpl_loaddata2.test 2005-12-22 06:34:59 +01:00
+++ 1.2/mysql-test/t/rpl_loaddata2.test 2006-01-17 19:40:47 +01:00
@@ -2,7 +2,13 @@
CREATE TABLE t1 (word CHAR(20) NOT NULL);
LOAD DATA INFILE '../../std_data/words.dat' INTO TABLE t1;
-SELECT * FROM t1;
+SELECT * FROM t1 ORDER BY word;
sync_slave_with_master;
-SELECT * FROM t1;
+SELECT * FROM t1 ORDER BY word;
+
+##########
+# Change Author: JBM
+# Change Date: 2006-01-16
+# Change: Added Order by for NDB
+##########
--- 1.1/mysql-test/t/rpl_loadfile.test 2005-12-22 06:34:59 +01:00
+++ 1.2/mysql-test/t/rpl_loadfile.test 2006-01-17 19:44:38 +01:00
@@ -4,6 +4,10 @@
#############################################################################
# TEST: To test the LOAD_FILE() in rbr #
#############################################################################
+# Change Author: JBM
+# Change Date: 2006-01-16
+# Change: Added Order by for NDB
+##########
# Includes
-- source include/master-slave.inc
@@ -30,18 +34,14 @@
delimiter ;|
CALL test.p1();
-SELECT * FROM test.t1;
+SELECT * FROM test.t1 ORDER BY blob_column;
save_master_pos;
sync_slave_with_master;
connection slave;
-SHOW CREATE TABLE test.t1;
-SELECT * FROM test.t1;
+SELECT * FROM test.t1 ORDER BY blob_column;
-connection master;
# Lets cleanup
-#show binlog events;
-
+connection master;
DROP PROCEDURE IF EXISTS test.p1;
DROP TABLE test.t1;
-
# End of 5.0 test case
--- 1.1/mysql-test/t/rpl_row_USER.test 2005-12-22 06:35:00 +01:00
+++ 1.2/mysql-test/t/rpl_row_USER.test 2006-01-17 12:58:51 +01:00
@@ -4,6 +4,10 @@
#############################################################################
# TEST: To test the UUID() in rbr #
#############################################################################
+# Change Author: JBM
+# Change Date: 2006-01-16
+# Change: Added Order by for NDB
+##########
# Includes
-- source include/have_binlog_format_row.inc
@@ -37,9 +41,9 @@
CALL mysqltest1.p1();
connection master;
-SELECT * FROM mysqltest1.t1;
+SELECT * FROM mysqltest1.t1 ORDER BY a;
sync_slave_with_master;
-SELECT * FROM mysqltest1.t1;
+SELECT * FROM mysqltest1.t1 ORDER BY a;
connection master;
# Lets cleanup
--- 1.12/mysql-test/r/rpl000005.result 2005-03-16 13:57:51 +01:00
+++ 1.13/mysql-test/r/rpl000005.result 2006-01-17 20:39:49 +01:00
@@ -12,12 +12,12 @@
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;
name age id
Andy 31 00000001
Jacob 2 00000002
Caleb 1 00000003
-select * from t1;
+SELECT * FROM t1 ORDER BY id;
name age id
Andy 31 00000001
Jacob 2 00000002
--- 1.43/mysql-test/r/rpl_log_pos.result 2005-12-22 05:10:56 +01:00
+++ 1.44/mysql-test/r/rpl_log_pos.result 2006-01-17 13:14:24 +01:00
@@ -38,7 +38,7 @@
stop slave;
change master to master_log_pos=102;
start slave;
-select * from t1;
+select * from t1 ORDER BY n;
n
1
2
--- 1.35/mysql-test/r/rpl_000015.result 2005-12-22 05:10:59 +01:00
+++ 1.36/mysql-test/r/rpl_000015.result 2006-01-17 19:37:54 +01:00
@@ -21,12 +21,12 @@
drop table if exists t1;
create table t1 (n int, PRIMARY KEY(n));
insert into t1 values (10),(45),(90);
-select * from t1;
+SELECT * FROM t1 ORDER BY n;
n
10
45
90
-select * from t1;
+SELECT * FROM t1 ORDER BY n;
n
10
45
--- 1.14/mysql-test/t/rpl000005.test 2005-07-28 02:21:47 +02:00
+++ 1.15/mysql-test/t/rpl000005.test 2006-01-17 20:39:36 +01:00
@@ -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 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;
--- 1.35/mysql-test/t/rpl_log_pos.test 2005-12-22 05:10:56 +01:00
+++ 1.36/mysql-test/t/rpl_log_pos.test 2006-01-17 13:14:35 +01:00
@@ -1,3 +1,9 @@
+##########
+# Change Author: JBM
+# Change Date: 2006-01-16
+# Change: Added Order by for NDB
+##########
+
#
# Testing of setting slave to wrong log position with master_log_pos
#
@@ -46,7 +52,7 @@
change master to master_log_pos=102;
start slave;
sync_with_master;
-select * from t1;
+select * from t1 ORDER BY n;
connection master;
drop table t1;
sync_slave_with_master;
--- 1.32/mysql-test/t/rpl_000015.test 2005-12-22 05:10:58 +01:00
+++ 1.33/mysql-test/t/rpl_000015.test 2006-01-17 19:37:43 +01:00
@@ -1,3 +1,9 @@
+#####################
+# Change Author: JBM
+# Change Date: 2006-01-17
+# Change: added order by in select
+#####################
+
connect (master,localhost,root,,test,$MASTER_MYPORT,$MASTER_MYSOCK);
connect (slave,localhost,root,,test,$SLAVE_MYPORT,slave.sock);
connection master;
@@ -34,8 +40,8 @@
insert into t1 values (10),(45),(90);
sync_slave_with_master;
connection slave;
-select * from t1;
+SELECT * FROM t1 ORDER BY n;
connection master;
-select * from t1;
+SELECT * FROM t1 ORDER BY n;
drop table t1;
sync_slave_with_master;
| Thread |
|---|
| • bk commit into 5.1 tree (jmiller:1.2058) | Jonathan Miller | 18 Jan |
