Below is the list of changes that have just been committed into a local
5.1 repository of zhl. When zhl 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-08-01 15:46:48+00:00, lzhou@dev3-63.(none) +15 -0
Bug#27543 Backup and Restore can compatible with different endians for blob attribute
mysql-test/r/ndb_restore_different_endian_data.result@stripped, 2007-08-01 15:46:39+00:00, lzhou@dev3-63.(none) +200 -0
Test result of endian test
mysql-test/r/ndb_restore_different_endian_data.result@stripped, 2007-08-01 15:46:39+00:00, lzhou@dev3-63.(none) +0 -0
mysql-test/std_data/ndb_backup51_data_be/BACKUP-1-0.1.Data@stripped, 2007-08-01 15:46:39+00:00, lzhou@dev3-63.(none) +959 -0
Test data for endian test
mysql-test/std_data/ndb_backup51_data_be/BACKUP-1-0.1.Data@stripped, 2007-08-01 15:46:39+00:00, lzhou@dev3-63.(none) +0 -0
mysql-test/std_data/ndb_backup51_data_be/BACKUP-1-0.2.Data@stripped, 2007-08-01 15:46:39+00:00, lzhou@dev3-63.(none) +674 -0
Test data for endian test
mysql-test/std_data/ndb_backup51_data_be/BACKUP-1-0.2.Data@stripped, 2007-08-01 15:46:39+00:00, lzhou@dev3-63.(none) +0 -0
mysql-test/std_data/ndb_backup51_data_be/BACKUP-1.1.ctl@stripped, 2007-08-01 15:46:39+00:00, lzhou@dev3-63.(none) +756 -0
Test data for endian test
mysql-test/std_data/ndb_backup51_data_be/BACKUP-1.1.ctl@stripped, 2007-08-01 15:46:39+00:00, lzhou@dev3-63.(none) +0 -0
mysql-test/std_data/ndb_backup51_data_be/BACKUP-1.1.log@stripped, 2007-08-01 15:46:39+00:00, lzhou@dev3-63.(none) +2 -0
Test data for endian test
mysql-test/std_data/ndb_backup51_data_be/BACKUP-1.1.log@stripped, 2007-08-01 15:46:39+00:00, lzhou@dev3-63.(none) +0 -0
mysql-test/std_data/ndb_backup51_data_be/BACKUP-1.2.ctl@stripped, 2007-08-01 15:46:39+00:00, lzhou@dev3-63.(none) +756 -0
Test data for endian test
mysql-test/std_data/ndb_backup51_data_be/BACKUP-1.2.ctl@stripped, 2007-08-01 15:46:39+00:00, lzhou@dev3-63.(none) +0 -0
mysql-test/std_data/ndb_backup51_data_be/BACKUP-1.2.log@stripped, 2007-08-01 15:46:39+00:00, lzhou@dev3-63.(none) +2 -0
Test data for endian test
mysql-test/std_data/ndb_backup51_data_be/BACKUP-1.2.log@stripped, 2007-08-01 15:46:39+00:00, lzhou@dev3-63.(none) +0 -0
mysql-test/std_data/ndb_backup51_data_le/BACKUP-1-0.1.Data@stripped, 2007-08-01 15:46:39+00:00, lzhou@dev3-63.(none) +530 -0
Test data for endian test
mysql-test/std_data/ndb_backup51_data_le/BACKUP-1-0.1.Data@stripped, 2007-08-01 15:46:39+00:00, lzhou@dev3-63.(none) +0 -0
mysql-test/std_data/ndb_backup51_data_le/BACKUP-1-0.2.Data@stripped, 2007-08-01 15:46:39+00:00, lzhou@dev3-63.(none) +1103 -0
Test data for endian test
mysql-test/std_data/ndb_backup51_data_le/BACKUP-1-0.2.Data@stripped, 2007-08-01 15:46:39+00:00, lzhou@dev3-63.(none) +0 -0
mysql-test/std_data/ndb_backup51_data_le/BACKUP-1.1.ctl@stripped, 2007-08-01 15:46:39+00:00, lzhou@dev3-63.(none) +756 -0
Test data for endian test
mysql-test/std_data/ndb_backup51_data_le/BACKUP-1.1.ctl@stripped, 2007-08-01 15:46:39+00:00, lzhou@dev3-63.(none) +0 -0
mysql-test/std_data/ndb_backup51_data_le/BACKUP-1.1.log@stripped, 2007-08-01 15:46:39+00:00, lzhou@dev3-63.(none) +2 -0
Test data for endian test
mysql-test/std_data/ndb_backup51_data_le/BACKUP-1.1.log@stripped, 2007-08-01 15:46:39+00:00, lzhou@dev3-63.(none) +0 -0
mysql-test/std_data/ndb_backup51_data_le/BACKUP-1.2.ctl@stripped, 2007-08-01 15:46:39+00:00, lzhou@dev3-63.(none) +756 -0
Test data for endian test
mysql-test/std_data/ndb_backup51_data_le/BACKUP-1.2.ctl@stripped, 2007-08-01 15:46:39+00:00, lzhou@dev3-63.(none) +0 -0
mysql-test/std_data/ndb_backup51_data_le/BACKUP-1.2.log@stripped, 2007-08-01 15:46:39+00:00, lzhou@dev3-63.(none) +2 -0
Test data for endian test
mysql-test/std_data/ndb_backup51_data_le/BACKUP-1.2.log@stripped, 2007-08-01 15:46:39+00:00, lzhou@dev3-63.(none) +0 -0
mysql-test/t/ndb_restore_different_endian_data.test@stripped, 2007-08-01 15:46:39+00:00, lzhou@dev3-63.(none) +185 -0
Test case for endian test
mysql-test/t/ndb_restore_different_endian_data.test@stripped, 2007-08-01 15:46:39+00:00, lzhou@dev3-63.(none) +0 -0
storage/ndb/tools/restore/Restore.cpp@stripped, 2007-08-01 15:46:39+00:00, lzhou@dev3-63.(none) +14 -0
Convert blob length stored in main table
# 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: lzhou
# Host: dev3-63.(none)
# Root: /home/zhl/mysql/mysql-5.1/bug27543
--- New file ---
+++ mysql-test/r/ndb_restore_different_endian_data.result 07/08/01 15:46:39
USE test;
DROP TABLE IF EXISTS t_num,t_datetime,t_string_1,t_string_2,t_gis;
SHOW TABLES;
Tables_in_test
t_gis
t_string_1
t_datetime
t_num
t_string_2
SHOW CREATE TABLE t_num;
Table Create Table
t_num CREATE TABLE `t_num` (
`t_pk` int(11) NOT NULL,
`t_bit` bit(64) DEFAULT NULL,
`t_tinyint` tinyint(4) DEFAULT NULL,
`t_bool` tinyint(1) DEFAULT NULL,
`t_smallint` smallint(6) DEFAULT NULL,
`t_mediumint` mediumint(9) DEFAULT NULL,
`t_int` int(11) DEFAULT NULL,
`t_bigint` bigint(20) DEFAULT NULL,
`t_float` float DEFAULT NULL,
`t_double` double DEFAULT NULL,
`t_decimal` decimal(37,16) DEFAULT NULL,
PRIMARY KEY (`t_pk`)
) ENGINE=ndbcluster DEFAULT CHARSET=latin1
SHOW CREATE TABLE t_datetime;
Table Create Table
t_datetime CREATE TABLE `t_datetime` (
`t_pk` int(11) NOT NULL,
`t_date` date DEFAULT NULL,
`t_datetime` datetime DEFAULT NULL,
`t_timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`t_time` time DEFAULT NULL,
`t_year` year(4) DEFAULT NULL,
PRIMARY KEY (`t_pk`)
) ENGINE=ndbcluster DEFAULT CHARSET=latin1
SHOW CREATE TABLE t_string_1;
Table Create Table
t_string_1 CREATE TABLE `t_string_1` (
`t_pk` int(11) NOT NULL,
`t_char` char(255) DEFAULT NULL,
`t_varchar` varchar(655) DEFAULT NULL,
`t_binary` binary(255) DEFAULT NULL,
`t_varbinary` varbinary(6553) DEFAULT NULL,
PRIMARY KEY (`t_pk`)
) ENGINE=ndbcluster DEFAULT CHARSET=latin1
SHOW CREATE TABLE t_string_2;
Table Create Table
t_string_2 CREATE TABLE `t_string_2` (
`t_pk` int(11) NOT NULL,
`t_tinyblob` tinyblob,
`t_tinytext` tinytext,
`t_blob` blob,
`t_text` text,
`t_mediumblob` mediumblob,
`t_mediumtext` mediumtext,
`t_longblob` longblob,
`t_longtext` longtext,
`t_enum` enum('001001','001004','001010','001018','001019','001020','001021','001027','001028','001029','001030','001031','001100','002003','002004','002005','002007') NOT NULL DEFAULT '001001',
`t_set` set('a','B') DEFAULT NULL,
PRIMARY KEY (`t_pk`)
) ENGINE=ndbcluster DEFAULT CHARSET=latin1
SHOW CREATE TABLE t_gis;
Table Create Table
t_gis CREATE TABLE `t_gis` (
`t_pk` int(11) NOT NULL,
`t_point` point DEFAULT NULL,
`t_linestring` linestring DEFAULT NULL,
`t_polygon` polygon DEFAULT NULL,
`t_multipoint` multipoint DEFAULT NULL,
`t_multilinestring` multilinestring DEFAULT NULL,
`t_multipolygon` multipolygon DEFAULT NULL,
`t_geometrycollection` geometrycollection DEFAULT NULL,
`t_geometry` geometry DEFAULT NULL,
PRIMARY KEY (`t_pk`)
) ENGINE=ndbcluster DEFAULT CHARSET=latin1
SELECT * FROM t_datetime;
t_pk t_date t_datetime t_timestamp t_time t_year
1 1998-01-01 2006-08-10 10:11:12 2002-10-29 16:51:06 19:38:34 2155
SELECT t_pk,hex(t_bit),t_tinyint,t_bool,t_smallint,t_mediumint,t_int,t_bigint,t_float,t_double,t_decimal FROM t_num;
t_pk hex(t_bit) t_tinyint t_bool t_smallint t_mediumint t_int t_bigint t_float t_double t_decimal
1 AAAAAAAAAAAAAAAA 125 1 32765 8388606 2147483647 9223372036854775807 1e+20 1e+150 331.0000000000000000
SELECT t_pk,t_char,t_varchar,hex(t_binary),hex(t_varbinary) FROM t_string_1;
t_pk t_char t_varchar hex(t_binary) hex(t_varbinary)
1 abcdefghijklmn abcdefghijklmnabcdefghijklmnabcdefghijklmnabcdefghijklmn 612020000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 4100
SELECT * FROM t_string_2;
t_pk t_tinyblob t_tinytext t_blob t_text t_mediumblob t_mediumtext t_longblob t_longtext t_enum t_set
1 abcdefghijklmnabcdefghijklmn abcdefghijklmnabcdefghijklmn a123456789b123456789c123456789d123456789e123456789f123456789g123456789 a123456789b123456789c123456789d123456789e123456789f123456789g123456789 a123456789b123456789c123456789d123456789e123456789f123456789g123456789 a123456789b123456789c123456789d123456789e123456789f123456789g123456789 a123456789b123456789c123456789d123456789e123456789f123456789g123456789 a123456789b123456789c123456789d123456789e123456789f123456789g123456789 001001 a
SELECT AsText(t_point), AsText(t_linestring),AsText(t_polygon) FROM t_gis ORDER by t_pk;
AsText(t_point) AsText(t_linestring) AsText(t_polygon)
POINT(10 10) LINESTRING(10 10,20 10,20 20,10 20,10 10) POLYGON((0 0,50 0,50 50,0 50,0 0),(10 10,20 10,20 20,10 20,10 10))
POINT(10 20) LINESTRING(10 10,40 10) POLYGON((0 0,30 0,30 30,0 0))
SELECT AsText(t_multipoint), AsText(t_multilinestring),AsText(t_multipolygon) FROM t_gis ORDER by t_pk;
AsText(t_multipoint) AsText(t_multilinestring) AsText(t_multipolygon)
MULTIPOINT(1 1,11 11,11 21,21 21) MULTILINESTRING((10 48,10 21,10 0)) MULTIPOLYGON(((28 26,28 0,84 0,84 42,28 26),(52 18,66 23,73 9,48 6,52 18)),((59 18,67 18,67 13,59 13,59 18)))
MULTIPOINT(3 6,4 10) MULTILINESTRING((1 2,3 5),(2 5,5 8,21 7)) MULTIPOLYGON(((0 3,3 3,3 0,0 3)))
SELECT AsText(t_geometrycollection), AsText(t_geometry) FROM t_gis ORDER by t_pk;
AsText(t_geometrycollection) AsText(t_geometry)
GEOMETRYCOLLECTION(POINT(0 0),LINESTRING(0 0,10 10)) MULTIPOLYGON(((28 26,28 0,84 0,84 42,28 26),(52 18,66 23,73 9,48 6,52 18)),((59 18,67 18,67 13,59 13,59 18)))
GEOMETRYCOLLECTION(POINT(44 6),LINESTRING(3 6,7 9)) GEOMETRYCOLLECTION(POINT(44 6),LINESTRING(3 6,7 9))
DROP TABLE t_num,t_datetime,t_string_1,t_string_2,t_gis;
SHOW TABLES;
Tables_in_test
t_gis
t_string_1
t_datetime
t_num
t_string_2
SHOW CREATE TABLE t_num;
Table Create Table
t_num CREATE TABLE `t_num` (
`t_pk` int(11) NOT NULL,
`t_bit` bit(64) DEFAULT NULL,
`t_tinyint` tinyint(4) DEFAULT NULL,
`t_bool` tinyint(1) DEFAULT NULL,
`t_smallint` smallint(6) DEFAULT NULL,
`t_mediumint` mediumint(9) DEFAULT NULL,
`t_int` int(11) DEFAULT NULL,
`t_bigint` bigint(20) DEFAULT NULL,
`t_float` float DEFAULT NULL,
`t_double` double DEFAULT NULL,
`t_decimal` decimal(37,16) DEFAULT NULL,
PRIMARY KEY (`t_pk`)
) ENGINE=ndbcluster DEFAULT CHARSET=latin1
SHOW CREATE TABLE t_datetime;
Table Create Table
t_datetime CREATE TABLE `t_datetime` (
`t_pk` int(11) NOT NULL,
`t_date` date DEFAULT NULL,
`t_datetime` datetime DEFAULT NULL,
`t_timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`t_time` time DEFAULT NULL,
`t_year` year(4) DEFAULT NULL,
PRIMARY KEY (`t_pk`)
) ENGINE=ndbcluster DEFAULT CHARSET=latin1
SHOW CREATE TABLE t_string_1;
Table Create Table
t_string_1 CREATE TABLE `t_string_1` (
`t_pk` int(11) NOT NULL,
`t_char` char(255) DEFAULT NULL,
`t_varchar` varchar(655) DEFAULT NULL,
`t_binary` binary(255) DEFAULT NULL,
`t_varbinary` varbinary(6553) DEFAULT NULL,
PRIMARY KEY (`t_pk`)
) ENGINE=ndbcluster DEFAULT CHARSET=latin1
SHOW CREATE TABLE t_string_2;
Table Create Table
t_string_2 CREATE TABLE `t_string_2` (
`t_pk` int(11) NOT NULL,
`t_tinyblob` tinyblob,
`t_tinytext` tinytext,
`t_blob` blob,
`t_text` text,
`t_mediumblob` mediumblob,
`t_mediumtext` mediumtext,
`t_longblob` longblob,
`t_longtext` longtext,
`t_enum` enum('001001','001004','001010','001018','001019','001020','001021','001027','001028','001029','001030','001031','001100','002003','002004','002005','002007') NOT NULL DEFAULT '001001',
`t_set` set('a','B') DEFAULT NULL,
PRIMARY KEY (`t_pk`)
) ENGINE=ndbcluster DEFAULT CHARSET=latin1
SHOW CREATE TABLE t_gis;
Table Create Table
t_gis CREATE TABLE `t_gis` (
`t_pk` int(11) NOT NULL,
`t_point` point DEFAULT NULL,
`t_linestring` linestring DEFAULT NULL,
`t_polygon` polygon DEFAULT NULL,
`t_multipoint` multipoint DEFAULT NULL,
`t_multilinestring` multilinestring DEFAULT NULL,
`t_multipolygon` multipolygon DEFAULT NULL,
`t_geometrycollection` geometrycollection DEFAULT NULL,
`t_geometry` geometry DEFAULT NULL,
PRIMARY KEY (`t_pk`)
) ENGINE=ndbcluster DEFAULT CHARSET=latin1
SELECT * FROM t_datetime;
t_pk t_date t_datetime t_timestamp t_time t_year
1 1998-01-01 2006-08-10 10:11:12 2002-10-29 16:51:06 19:38:34 2155
SELECT t_pk,hex(t_bit),t_tinyint,t_bool,t_smallint,t_mediumint,t_int,t_bigint,t_float,t_double,t_decimal FROM t_num;
t_pk hex(t_bit) t_tinyint t_bool t_smallint t_mediumint t_int t_bigint t_float t_double t_decimal
1 AAAAAAAAAAAAAAAA 125 1 32765 8388606 2147483647 9223372036854775807 1e+20 1e+150 331.0000000000000000
SELECT t_pk,t_char,t_varchar,hex(t_binary),hex(t_varbinary) FROM t_string_1;
t_pk t_char t_varchar hex(t_binary) hex(t_varbinary)
1 abcdefghijklmn abcdefghijklmnabcdefghijklmnabcdefghijklmnabcdefghijklmn 612020000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 4100
SELECT * FROM t_string_2;
t_pk t_tinyblob t_tinytext t_blob t_text t_mediumblob t_mediumtext t_longblob t_longtext t_enum t_set
1 abcdefghijklmnabcdefghijklmn abcdefghijklmnabcdefghijklmn a123456789b123456789c123456789d123456789e123456789f123456789g123456789 a123456789b123456789c123456789d123456789e123456789f123456789g123456789 a123456789b123456789c123456789d123456789e123456789f123456789g123456789 a123456789b123456789c123456789d123456789e123456789f123456789g123456789 a123456789b123456789c123456789d123456789e123456789f123456789g123456789 a123456789b123456789c123456789d123456789e123456789f123456789g123456789 001001 a
SELECT AsText(t_point), AsText(t_linestring),AsText(t_polygon) FROM t_gis ORDER by t_pk;
AsText(t_point) AsText(t_linestring) AsText(t_polygon)
POINT(10 10) LINESTRING(10 10,20 10,20 20,10 20,10 10) POLYGON((0 0,50 0,50 50,0 50,0 0),(10 10,20 10,20 20,10 20,10 10))
POINT(10 20) LINESTRING(10 10,40 10) POLYGON((0 0,30 0,30 30,0 0))
SELECT AsText(t_multipoint), AsText(t_multilinestring),AsText(t_multipolygon) FROM t_gis ORDER by t_pk;
AsText(t_multipoint) AsText(t_multilinestring) AsText(t_multipolygon)
MULTIPOINT(1 1,11 11,11 21,21 21) MULTILINESTRING((10 48,10 21,10 0)) MULTIPOLYGON(((28 26,28 0,84 0,84 42,28 26),(52 18,66 23,73 9,48 6,52 18)),((59 18,67 18,67 13,59 13,59 18)))
MULTIPOINT(3 6,4 10) MULTILINESTRING((1 2,3 5),(2 5,5 8,21 7)) MULTIPOLYGON(((0 3,3 3,3 0,0 3)))
SELECT AsText(t_geometrycollection), AsText(t_geometry) FROM t_gis ORDER by t_pk;
AsText(t_geometrycollection) AsText(t_geometry)
GEOMETRYCOLLECTION(POINT(0 0),LINESTRING(0 0,10 10)) MULTIPOLYGON(((28 26,28 0,84 0,84 42,28 26),(52 18,66 23,73 9,48 6,52 18)),((59 18,67 18,67 13,59 13,59 18)))
GEOMETRYCOLLECTION(POINT(44 6),LINESTRING(3 6,7 9)) GEOMETRYCOLLECTION(POINT(44 6),LINESTRING(3 6,7 9))
DROP TABLE t_num,t_datetime,t_string_1,t_string_2,t_gis;
--- New file ---
+++ mysql-test/std_data/ndb_backup51_data_be/BACKUP-1-0.1.Data 07/08/01 15:46:39
NDBBCKUP
t_pk INT PRIMARY KEY,
t_date DATE,
t_datetime DATETIME,
t_timestamp TIMESTAMP,
t_time TIME,
t_year YEAR
) ENGINE=NDBCLUSTER
t_datetime
t_pk INT PRIMARY KEY,
t_tinyblob TINYBLOB,
t_tinytext TINYTEXT,
t_blob BLOB,
t_text TEXT,
t_mediumblob MEDIUMBLOB,
t_mediumtext MEDIUMTEXT,
t_longblob LONGBLOB,
t_longtext LONGTEXT,
t_enum ENUM('001001','0010
t_string_2
--- New file ---
+++ mysql-test/std_data/ndb_backup51_data_be/BACKUP-1-0.2.Data 07/08/01 15:46:39
NDBBCKUP
) ENGINE=NDBCLUSTER
t_string_2
t_set SET('a','B')
) ENGINE=NDBCLUSTER
I
&
t_pk INT PRIMARY KEY,
t_point POINT,
t_linestring LINESTRING,
t_polygon POLYGON,
t_multipoint MULTIPOINT,
t_multilinestring MULTILINESTRING,
t_multipolygon MULTIPOLYGON,
t_geometrycollection GEOMETRYCOLLECTION,
t_pk INT PRIMARY KEY,
t_char CHAR(255),
t_varchar VARCHAR(655),
t_binary BINARY(255),
t_varbinary VARBINARY(6553)
) ENGINE=NDBCLUSTER
t_string_1
t_pk INT PRIMARY KEY,
t_bit BIT(64),
t_tinyint TINYINT,
t_bool BOOL,
t_smallint SMALLINT,
t_mediumint MEDIUMINT,
t_int INT,
t_bigint BIGINT,
t_float FLOAT,
t_double DOUBLE,
t_decimal DECIMAL (37, 16)
) ENGI
--- New file ---
+++ mysql-test/std_data/ndb_backup51_data_be/BACKUP-1.1.ctl 07/08/01 15:46:39
NDBBCKUP
NDB$TNODE
t_polygon
NDB$TNODE
server_id
start_pos
t_tinyint
t_decimal
NDB$TNODE
t_varchar
NDB$TNODE
NDB$TNODE
--- New file ---
+++ mysql-test/std_data/ndb_backup51_data_be/BACKUP-1.1.log 07/08/01 15:46:39
NDBBCKUP
--- New file ---
+++ mysql-test/std_data/ndb_backup51_data_be/BACKUP-1.2.ctl 07/08/01 15:46:39
NDBBCKUP
NDB$TNODE
t_polygon
NDB$TNODE
server_id
start_pos
t_tinyint
t_decimal
NDB$TNODE
t_varchar
NDB$TNODE
NDB$TNODE
--- New file ---
+++ mysql-test/std_data/ndb_backup51_data_be/BACKUP-1.2.log 07/08/01 15:46:39
NDBBCKUP
--- New file ---
+++ mysql-test/std_data/ndb_backup51_data_le/BACKUP-1-0.1.Data 07/08/01 15:46:39
NDBBCKUP
t_string_2
t_set SET('a','B')
) ENGINE=NDBCLUSTER
--- New file ---
+++ mysql-test/std_data/ndb_backup51_data_le/BACKUP-1-0.2.Data 07/08/01 15:46:39
NDBBCKUP
est/def/NDB$BLOB_11_6
) ENGINE=NDBCLUSTER
t_pk INT PRIMARY KEY,
t_point POINT,
t_linestring LINESTRING,
t_polygon POLYGON,
t_multipoint MULTIPOINT,
t_multilinestring MULTILINESTRING,
t_multipolygon MULTIPOLYGON,
t_geometrycollection GEOMETRYCOLLECTION,
t_pk INT PRIMARY KEY,
t_date DATE,
t_datetime DATETIME,
t_timestamp TIMESTAMP,
t_time TIME,
t_year YEAR
) ENGINE=NDBCLUSTER
t_datetime
t_pk INT PRIMARY KEY,
t_char CHAR(255),
t_varchar VARCHAR(655),
t_binary BINARY(255),
t_varbinary VARBINARY(6553)
) ENGINE=NDBCLUSTER
t_string_1
t_pk INT PRIMARY KEY,
t_bit BIT(64),
t_tinyint TINYINT,
t_bool BOOL,
t_smallint SMALLINT,
t_mediumint MEDIUMINT,
t_int INT,
t_bigint BIGINT,
t_float FLOAT,
t_double DOUBLE,
t_decimal DECIMAL (37, 16)
) ENGI
t_pk INT PRIMARY KEY,
t_tinyblob TINYBLOB,
t_tinytext TINYTEXT,
t_blob BLOB,
t_text TEXT,
t_mediumblob MEDIUMBLOB,
t_mediumtext MEDIUMTEXT,
t_longblob LONGBLOB,
t_longtext LONGTEXT,
t_enum ENUM('001001','0010
t_string_2
--- New file ---
+++ mysql-test/std_data/ndb_backup51_data_le/BACKUP-1.1.ctl 07/08/01 15:46:39
NDBBCKUP
NDB$TNODE
t_polygon
NDB$TNODE
server_id
start_pos
t_tinyint
t_decimal
NDB$TNODE
t_varchar
NDB$TNODE
NDB$TNODE
--- New file ---
+++ mysql-test/std_data/ndb_backup51_data_le/BACKUP-1.1.log 07/08/01 15:46:39
NDBBCKUP
--- New file ---
+++ mysql-test/std_data/ndb_backup51_data_le/BACKUP-1.2.ctl 07/08/01 15:46:39
NDBBCKUP
NDB$TNODE
t_polygon
NDB$TNODE
server_id
start_pos
t_tinyint
t_decimal
NDB$TNODE
t_varchar
NDB$TNODE
NDB$TNODE
--- New file ---
+++ mysql-test/std_data/ndb_backup51_data_le/BACKUP-1.2.log 07/08/01 15:46:39
NDBBCKUP
--- New file ---
+++ mysql-test/t/ndb_restore_different_endian_data.test 07/08/01 15:46:39
-- source include/have_ndb.inc
-- source include/ndb_default_cluster.inc
-- source include/not_embedded.inc
#
# Bug #27543 restore of backup from different endian does not work for blob column
# Bug #30024 restore of backup from different endian does not work for datetime column
# Bug #28674 backup will run forever if disk full and later write succes will kill ndb node
#
# The table structure and data list below
#
# CREATE TABLE t_num (
# t_pk INT PRIMARY KEY,
# t_bit BIT(64),
# t_tinyint TINYINT,
# t_bool BOOL,
# t_smallint SMALLINT,
# t_mediumint MEDIUMINT,
# t_int INT,
# t_bigint BIGINT,
# t_float FLOAT,
# t_double DOUBLE,
# t_decimal DECIMAL (37, 16)
# ) ENGINE=NDBCLUSTER;
#
# INSERT INTO t_num VALUE (
# 1,
# b'1010101010101010101010101010101010101010101010101010101010101010',
# 125,
# 1,
# 32765,
# 8388606,
# 2147483647,
# 9223372036854775807,
# 1e+20,
# 1e+150,
# '331.0000000000'
# );
#
# CREATE TABLE t_datetime (
# t_pk INT PRIMARY KEY,
# t_date DATE,
# t_datetime DATETIME,
# t_timestamp TIMESTAMP,
# t_time TIME,
# t_year YEAR
# ) ENGINE=NDBCLUSTER;
#
# INSERT INTO t_datetime VALUE (
# 1,
# '1998-01-01',
# '2006-08-10 10:11:12',
# 20021029165106,
# '19:38:34',
# 2155
# );
#
# CREATE TABLE t_string_1 (
# t_pk INT PRIMARY KEY,
# t_char CHAR(255),
# t_varchar VARCHAR(655),
# t_binary BINARY(255),
# t_varbinary VARBINARY(6553)
# ) ENGINE=NDBCLUSTER;
#
# CREATE TABLE t_string_2 (
# t_pk INT PRIMARY KEY,
# t_tinyblob TINYBLOB,
# t_tinytext TINYTEXT,
# t_blob BLOB,
# t_text TEXT,
# t_mediumblob MEDIUMBLOB,
# t_mediumtext MEDIUMTEXT,
# t_longblob LONGBLOB,
# t_longtext LONGTEXT,
# t_enum ENUM('001001','001004','001010','001018','001019','001020','001021','001027','001028','001029','001030','001031','001100','002003','002004','002005','002007')DEFAULT '001001' NOT NULL,
# t_set SET('a','B')
# ) ENGINE=NDBCLUSTER;
#
# INSERT INTO t_string_1 VALUE (
# 1,
# 'abcdefghijklmn',
# 'abcdefghijklmnabcdefghijklmnabcdefghijklmnabcdefghijklmn',
# 0x612020,
# 0x4100
# );
#
# INSERT INTO t_string_2 VALUE (
# 1,
# 'abcdefghijklmnabcdefghijklmn',
# 'abcdefghijklmnabcdefghijklmn',
# 'a123456789b123456789c123456789d123456789e123456789f123456789g123456789',
# 'a123456789b123456789c123456789d123456789e123456789f123456789g123456789',
# 'a123456789b123456789c123456789d123456789e123456789f123456789g123456789',
# 'a123456789b123456789c123456789d123456789e123456789f123456789g123456789',
# 'a123456789b123456789c123456789d123456789e123456789f123456789g123456789',
# 'a123456789b123456789c123456789d123456789e123456789f123456789g123456789',
# '001001',
# 'a'
# );
#
# CREATE TABLE t_gis (
# t_pk INT PRIMARY KEY,
# t_point POINT,
# t_linestring LINESTRING,
# t_polygon POLYGON,
# t_multipoint MULTIPOINT,
# t_multilinestring MULTILINESTRING,
# t_multipolygon MULTIPOLYGON,
# t_geometrycollection GEOMETRYCOLLECTION,
# t_geometry GEOMETRY
# ) ENGINE=NDBCLUSTER;
#
# INSERT INTO t_gis VALUE (
# 1,
# PointFromText('POINT(10 10)'),
# LineStringFromText('LINESTRING(10 10,20 10,20 20,10 20,10 10)'),
# PolyFromText('POLYGON((0 0,50 0,50 50,0 50,0 0), (10 10,20 10,20 20,10 20,10 10))'),
# MPointFromText('MULTIPOINT(1 1,11 11,11 21,21 21)'),
# MLineFromText('MULTILINESTRING((10 48,10 21,10 0))'),
# MPolyFromText('MULTIPOLYGON(((28 26,28 0,84 0,84 42,28 26),(52 18,66 23,73 9,48 6,52 18)),((59 18,67 18,67 13,59 13,59 18)))'),
# GeomCollFromText('GEOMETRYCOLLECTION(POINT(0 0), LINESTRING(0 0,10 10))'),
# MPolyFromText('MULTIPOLYGON(((28 26,28 0,84 0,84 42,28 26),(52 18,66 23,73 9,48 6,52 18)),((59 18,67 18,67 13,59 13,59 18)))')
# );
#
# INSERT INTO t_gis VALUE (
# 2,
# PointFromWKB(AsWKB(PointFromText('POINT(10 20)'))),
# LineStringFromWKB(LineString(Point(10, 10), Point(40, 10))),
# PolyFromWKB(Polygon(LineString(Point(0, 0), Point(30, 0), Point(30, 30), Point(0, 0)))),
# MPointFromWKB(MultiPoint(Point(3, 6), Point(4, 10))),
# MLineFromWKB(MultiLineString(LineString(Point(1, 2), Point(3, 5)), LineString(Point(2, 5), Point(5, 8), Point(21, 7)))),
# MPolyFromWKB(MultiPolygon(Polygon(LineString(Point(0, 3), Point(3, 3), Point(3, 0), Point(0, 3))))),
# GeometryFromWKB(GeometryCollection(Point(44, 6), LineString(Point(3, 6), Point(7, 9)))),
# GeometryFromWKB(GeometryCollection(Point(44, 6), LineString(Point(3, 6), Point(7, 9))))
# );
#
# Restore backup files (from little endian)
#
--disable_warnings
USE test;
DROP TABLE IF EXISTS t_num,t_datetime,t_string_1,t_string_2,t_gis;
--enable_warnings
--exec $NDB_TOOLS_DIR/ndb_restore --no-defaults -b 1 -n 1 -m -r $MYSQL_TEST_DIR/std_data/ndb_backup51_data_le >> $NDB_TOOLS_OUTPUT
--exec $NDB_TOOLS_DIR/ndb_restore --no-defaults -b 1 -n 2 -r $MYSQL_TEST_DIR/std_data/ndb_backup51_data_le >> $NDB_TOOLS_OUTPUT
SHOW TABLES;
SHOW CREATE TABLE t_num;
SHOW CREATE TABLE t_datetime;
SHOW CREATE TABLE t_string_1;
SHOW CREATE TABLE t_string_2;
SHOW CREATE TABLE t_gis;
SELECT * FROM t_datetime;
SELECT t_pk,hex(t_bit),t_tinyint,t_bool,t_smallint,t_mediumint,t_int,t_bigint,t_float,t_double,t_decimal FROM t_num;
SELECT t_pk,t_char,t_varchar,hex(t_binary),hex(t_varbinary) FROM t_string_1;
SELECT * FROM t_string_2;
SELECT AsText(t_point), AsText(t_linestring),AsText(t_polygon) FROM t_gis ORDER by t_pk;
SELECT AsText(t_multipoint), AsText(t_multilinestring),AsText(t_multipolygon) FROM t_gis ORDER by t_pk;
SELECT AsText(t_geometrycollection), AsText(t_geometry) FROM t_gis ORDER by t_pk;
#
# Restore backup files (from big endian)
#
DROP TABLE t_num,t_datetime,t_string_1,t_string_2,t_gis;
--exec $NDB_TOOLS_DIR/ndb_restore --no-defaults -b 1 -n 1 -m -r $MYSQL_TEST_DIR/std_data/ndb_backup51_data_be >> $NDB_TOOLS_OUTPUT
--exec $NDB_TOOLS_DIR/ndb_restore --no-defaults -b 1 -n 2 -r $MYSQL_TEST_DIR/std_data/ndb_backup51_data_be >> $NDB_TOOLS_OUTPUT
SHOW TABLES;
SHOW CREATE TABLE t_num;
SHOW CREATE TABLE t_datetime;
SHOW CREATE TABLE t_string_1;
SHOW CREATE TABLE t_string_2;
SHOW CREATE TABLE t_gis;
SELECT * FROM t_datetime;
SELECT t_pk,hex(t_bit),t_tinyint,t_bool,t_smallint,t_mediumint,t_int,t_bigint,t_float,t_double,t_decimal FROM t_num;
SELECT t_pk,t_char,t_varchar,hex(t_binary),hex(t_varbinary) FROM t_string_1;
SELECT * FROM t_string_2;
SELECT AsText(t_point), AsText(t_linestring),AsText(t_polygon) FROM t_gis ORDER by t_pk;
SELECT AsText(t_multipoint), AsText(t_multilinestring),AsText(t_multipolygon) FROM t_gis ORDER by t_pk;
SELECT AsText(t_geometrycollection), AsText(t_geometry) FROM t_gis ORDER by t_pk;
DROP TABLE t_num,t_datetime,t_string_1,t_string_2,t_gis;
--- 1.50/storage/ndb/tools/restore/Restore.cpp 2007-08-01 15:47:07 +00:00
+++ 1.51/storage/ndb/tools/restore/Restore.cpp 2007-08-01 15:47:07 +00:00
@@ -664,6 +664,20 @@ RestoreDataIterator::getNextTuple(int &
*/
const Uint32 arraySize = sz / (attr_desc->size / 8);
assert(arraySize <= attr_desc->arraySize);
+
+ //convert the length of blob(v1) and text(v1)
+ if(!m_hostByteOrder
+ && (attr_desc->m_column->getType() == NdbDictionary::Column::Blob
+ || attr_desc->m_column->getType() == NdbDictionary::Column::Text)
+ && attr_desc->m_column->getArrayType() == NdbDictionary::Column::ArrayTypeFixed)
+ {
+ char* p = (char*)&attr_data->u_int64_value[0];
+ Uint64 x;
+ memcpy(&x, p, sizeof(Uint64));
+ x = Twiddle64(x);
+ memcpy(p, &x, sizeof(Uint64));
+ }
+
if(!Twiddle(attr_desc, attr_data, attr_desc->arraySize))
{
res = -1;
| Thread |
|---|
| • bk commit into 5.1 tree (lzhou:1.2552) BUG#27543 | lzhou | 1 Aug |
