MySQL Lists are EOL. Please join:

List:Commits« Previous MessageNext Message »
From:gni Date:November 7 2007 3:48am
Subject:bk commit into 5.1 tree (gni:1.2669) BUG#32095
View as plain text  
Below is the list of changes that have just been committed into a local
5.1 repository of root. When root 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@stripped, 2007-11-07 11:48:11+08:00, gni@stripped +15 -0
  WL#3829 Extending testing of the online alter table
    Fix the problem caused by bug#32095  
    Here just shorten the double type and avoid the problem.  
    Because the bug#32095 has been comment in rpl_ndb_add_column.test,
    Don't want to be affected more than twice by the bug.

  mysql-test/std_data/ndb_backup51_d2_be/BACKUP-1-0.1.Data@stripped, 2007-11-07 11:48:08+08:00, gni@stripped +12 -12
    New backup file for big endian (shorten the double data)

  mysql-test/std_data/ndb_backup51_d2_be/BACKUP-1-0.2.Data@stripped, 2007-11-07 11:48:08+08:00, gni@stripped +11 -11
    New backup file for big endian (shorten the double data)

  mysql-test/std_data/ndb_backup51_d2_be/BACKUP-1.1.ctl@stripped, 2007-11-07 11:48:08+08:00, gni@stripped +2 -2
    New backup file for big endian (shorten the double data)

  mysql-test/std_data/ndb_backup51_d2_be/BACKUP-1.1.log@stripped, 2007-11-07 11:48:08+08:00, gni@stripped +1 -1
    New backup file for big endian (shorten the double data)

  mysql-test/std_data/ndb_backup51_d2_be/BACKUP-1.2.ctl@stripped, 2007-11-07 11:48:08+08:00, gni@stripped +2 -2
    New backup file for big endian (shorten the double data)

  mysql-test/std_data/ndb_backup51_d2_be/BACKUP-1.2.log@stripped, 2007-11-07 11:48:08+08:00, gni@stripped +1 -1
    New backup file for big endian (shorten the double data)

  mysql-test/std_data/ndb_backup51_d2_le/BACKUP-1-0.1.Data@stripped, 2007-11-07 11:48:08+08:00, gni@stripped +12 -12
    New backup file for little endian (shorten the double data)

  mysql-test/std_data/ndb_backup51_d2_le/BACKUP-1-0.2.Data@stripped, 2007-11-07 11:48:08+08:00, gni@stripped +12 -12
    New backup file for little endian (shorten the double data)

  mysql-test/std_data/ndb_backup51_d2_le/BACKUP-1.1.ctl@stripped, 2007-11-07 11:48:08+08:00, gni@stripped +2 -2
    New backup file for little endian (shorten the double data)

  mysql-test/std_data/ndb_backup51_d2_le/BACKUP-1.1.log@stripped, 2007-11-07 11:48:08+08:00, gni@stripped +1 -1
    New backup file for little endian (shorten the double data)

  mysql-test/std_data/ndb_backup51_d2_le/BACKUP-1.2.ctl@stripped, 2007-11-07 11:48:08+08:00, gni@stripped +2 -2
    New backup file for little endian (shorten the double data)

  mysql-test/std_data/ndb_backup51_d2_le/BACKUP-1.2.log@stripped, 2007-11-07 11:48:08+08:00, gni@stripped +1 -1
    New backup file for little endian (shorten the double data)

  mysql-test/suite/ndb/r/ndb_alter_table_backup.result@stripped, 2007-11-07 11:48:08+08:00, gni@stripped +6 -6
    New result for shortening the double data

  mysql-test/suite/ndb/r/ndb_alter_table_online.result@stripped, 2007-11-07 11:48:08+08:00, gni@stripped +4 -4
    New result for shortening the double data

  mysql-test/suite/ndb/t/ndb_alter_table_online.test@stripped, 2007-11-07 11:48:08+08:00, gni@stripped +5 -5
    Shorten the double type for the bug#32095. 
    Because the bug#32095 has been comment in rpl_ndb_add_column.test,
    Here just avoid the problem.

Binary files a/mysql-test/std_data/ndb_backup51_d2_be/BACKUP-1-0.1.Data and b/mysql-test/std_data/ndb_backup51_d2_be/BACKUP-1-0.1.Data differ
Binary files a/mysql-test/std_data/ndb_backup51_d2_be/BACKUP-1-0.2.Data and b/mysql-test/std_data/ndb_backup51_d2_be/BACKUP-1-0.2.Data differ
Binary files a/mysql-test/std_data/ndb_backup51_d2_be/BACKUP-1.1.ctl and b/mysql-test/std_data/ndb_backup51_d2_be/BACKUP-1.1.ctl differ
Binary files a/mysql-test/std_data/ndb_backup51_d2_be/BACKUP-1.1.log and b/mysql-test/std_data/ndb_backup51_d2_be/BACKUP-1.1.log differ
Binary files a/mysql-test/std_data/ndb_backup51_d2_be/BACKUP-1.2.ctl and b/mysql-test/std_data/ndb_backup51_d2_be/BACKUP-1.2.ctl differ
Binary files a/mysql-test/std_data/ndb_backup51_d2_be/BACKUP-1.2.log and b/mysql-test/std_data/ndb_backup51_d2_be/BACKUP-1.2.log differ
Binary files a/mysql-test/std_data/ndb_backup51_d2_le/BACKUP-1-0.1.Data and b/mysql-test/std_data/ndb_backup51_d2_le/BACKUP-1-0.1.Data differ
Binary files a/mysql-test/std_data/ndb_backup51_d2_le/BACKUP-1-0.2.Data and b/mysql-test/std_data/ndb_backup51_d2_le/BACKUP-1-0.2.Data differ
Binary files a/mysql-test/std_data/ndb_backup51_d2_le/BACKUP-1.1.ctl and b/mysql-test/std_data/ndb_backup51_d2_le/BACKUP-1.1.ctl differ
Binary files a/mysql-test/std_data/ndb_backup51_d2_le/BACKUP-1.1.log and b/mysql-test/std_data/ndb_backup51_d2_le/BACKUP-1.1.log differ
Binary files a/mysql-test/std_data/ndb_backup51_d2_le/BACKUP-1.2.ctl and b/mysql-test/std_data/ndb_backup51_d2_le/BACKUP-1.2.ctl differ
Binary files a/mysql-test/std_data/ndb_backup51_d2_le/BACKUP-1.2.log and b/mysql-test/std_data/ndb_backup51_d2_le/BACKUP-1.2.log differ
diff -Nrup a/mysql-test/suite/ndb/r/ndb_alter_table_backup.result b/mysql-test/suite/ndb/r/ndb_alter_table_backup.result
--- a/mysql-test/suite/ndb/r/ndb_alter_table_backup.result	2007-11-03 07:10:50 +08:00
+++ b/mysql-test/suite/ndb/r/ndb_alter_table_backup.result	2007-11-07 11:48:08 +08:00
@@ -20,10 +20,10 @@ t1	CREATE TABLE `t1` (
 ) ENGINE=ndbcluster DEFAULT CHARSET=latin1
 SELECT * FROM t1 WHERE a = 1 or a = 10 or a = 20 or a = 30 ORDER BY a;
 a	b	c	d	e	f	g
-1	5	3.40282e+38	1.2686868689899e+308	666.66	2007-10-23 23:23:23	1111
+1	5	3.40282e+38	1.2686868689898e+308	666.66	2007-10-23 23:23:23	1111
 10	1	-3.40282e+38	NULL	NULL	NULL	NULL
-20	1	-3.40282e+38	1.79769313486232e+308	345.21	NULL	NULL
-30	1	-3.40282e+38	1.79769313486232e+308	345.21	1000-01-01 00:00:00	0101
+20	1	-3.40282e+38	1.7976931348623e+308	345.21	NULL	NULL
+30	1	-3.40282e+38	1.7976931348623e+308	345.21	1000-01-01 00:00:00	0101
 DROP TABLE t1;
 *********************************
 * restore tables w/ new column from big endian
@@ -45,8 +45,8 @@ t1	CREATE TABLE `t1` (
 ) ENGINE=ndbcluster DEFAULT CHARSET=latin1
 SELECT * FROM t1 WHERE a = 1 or a = 10 or a = 20 or a = 30 ORDER BY a;
 a	b	c	d	e	f	g
-1	5	3.40282e+38	1.2686868689899e+308	666.66	2007-10-23 23:23:23	1111
+1	5	3.40282e+38	1.2686868689898e+308	666.66	2007-10-23 23:23:23	1111
 10	1	-3.40282e+38	NULL	NULL	NULL	NULL
-20	1	-3.40282e+38	1.79769313486232e+308	345.21	NULL	NULL
-30	1	-3.40282e+38	1.79769313486232e+308	345.21	1000-01-01 00:00:00	0101
+20	1	-3.40282e+38	1.7976931348623e+308	345.21	NULL	NULL
+30	1	-3.40282e+38	1.7976931348623e+308	345.21	1000-01-01 00:00:00	0101
 DROP TABLE t1;
diff -Nrup a/mysql-test/suite/ndb/r/ndb_alter_table_online.result b/mysql-test/suite/ndb/r/ndb_alter_table_online.result
--- a/mysql-test/suite/ndb/r/ndb_alter_table_online.result	2007-11-02 19:10:15 +08:00
+++ b/mysql-test/suite/ndb/r/ndb_alter_table_online.result	2007-11-07 11:48:08 +08:00
@@ -545,13 +545,13 @@ COUNT(*)
 SELECT COUNT(*) FROM t1 WHERE g IS NULL;
 COUNT(*)
 25
-UPDATE t1 SET c = 3.402823466E+38, d = 1.2686868689898989E+308, e = 666.66, f = '2007-10-23 23:23:23', g = '1111' WHERE a = 1;
+UPDATE t1 SET c = 3.402823466E+38, d = 1.2686868689898E+308, e = 666.66, f = '2007-10-23 23:23:23', g = '1111' WHERE a = 1;
 SELECT * FROM t1 WHERE a = 1 or a = 10 or a = 20 or a = 30 ORDER BY a;
 a	b	c	d	e	f	g
-1	5	3.40282e+38	1.2686868689899e+308	666.66	2007-10-23 23:23:23	1111
+1	5	3.40282e+38	1.2686868689898e+308	666.66	2007-10-23 23:23:23	1111
 10	1	-3.40282e+38	NULL	NULL	NULL	NULL
-20	1	-3.40282e+38	1.79769313486232e+308	345.21	NULL	NULL
-30	1	-3.40282e+38	1.79769313486232e+308	345.21	1000-01-01 00:00:00	0101
+20	1	-3.40282e+38	1.7976931348623e+308	345.21	NULL	NULL
+30	1	-3.40282e+38	1.7976931348623e+308	345.21	1000-01-01 00:00:00	0101
 *********************************
 * Backup and restore tables w/ new column
 *********************************
diff -Nrup a/mysql-test/suite/ndb/t/ndb_alter_table_online.test b/mysql-test/suite/ndb/t/ndb_alter_table_online.test
--- a/mysql-test/suite/ndb/t/ndb_alter_table_online.test	2007-11-02 19:10:15 +08:00
+++ b/mysql-test/suite/ndb/t/ndb_alter_table_online.test	2007-11-07 11:48:08 +08:00
@@ -511,7 +511,7 @@ let $v=5;
 disable_query_log;
 while ($v)
 {
-  --eval INSERT INTO t1 VALUES(NULL, $v, -3.402823466E+38, 1.7976931348623157E+308); 
+  --eval INSERT INTO t1 VALUES(NULL, $v, -3.402823466E+38, 1.7976931348623E+308); 
   dec $v;
 }
 enable_query_log;
@@ -525,7 +525,7 @@ let $v=5;
 disable_query_log;
 while ($v)
 {
-  --eval INSERT INTO t1 VALUES(NULL, $v, -3.402823466E+38, 1.7976931348623157E+308, 345.21); 
+  --eval INSERT INTO t1 VALUES(NULL, $v, -3.402823466E+38, 1.7976931348623E+308, 345.21); 
   dec $v;
 }
 enable_query_log;
@@ -539,7 +539,7 @@ let $v=5;
 disable_query_log;
 while ($v)
 {
-  --eval INSERT INTO t1 VALUES(NULL, $v, -3.402823466E+38, 1.7976931348623157E+308, 345.21, '1000-01-01 00:00:00'); 
+  --eval INSERT INTO t1 VALUES(NULL, $v, -3.402823466E+38, 1.7976931348623E+308, 345.21, '1000-01-01 00:00:00'); 
   dec $v;
 }
 enable_query_log;
@@ -553,7 +553,7 @@ let $v=5;
 disable_query_log;
 while ($v)
 {
-  --eval INSERT INTO t1 VALUES(NULL, $v, -3.402823466E+38, 1.7976931348623157E+308, 345.21, '1000-01-01 00:00:00', '0101');
+  --eval INSERT INTO t1 VALUES(NULL, $v, -3.402823466E+38, 1.7976931348623E+308, 345.21, '1000-01-01 00:00:00', '0101');
   dec $v;
 }
 enable_query_log;
@@ -570,7 +570,7 @@ SELECT COUNT(*) FROM t1 WHERE e IS NULL;
 SELECT COUNT(*) FROM t1 WHERE f IS NULL;
 SELECT COUNT(*) FROM t1 WHERE g IS NULL;
 
-UPDATE t1 SET c = 3.402823466E+38, d = 1.2686868689898989E+308, e = 666.66, f = '2007-10-23 23:23:23', g = '1111' WHERE a = 1;
+UPDATE t1 SET c = 3.402823466E+38, d = 1.2686868689898E+308, e = 666.66, f = '2007-10-23 23:23:23', g = '1111' WHERE a = 1;
 SELECT * FROM t1 WHERE a = 1 or a = 10 or a = 20 or a = 30 ORDER BY a;
 
 ##############################
Thread
bk commit into 5.1 tree (gni:1.2669) BUG#32095gni7 Nov