gt-check 遇到特殊字符 "\" 同步失败
gt-check 遇到特殊字符 "\" 同步失败源库：
CREATE DATABASE `testdb1` /*!40100 DEFAULT CHARACTER SET utf8 */ ;
use testdb1;
CREATE TABLE `t1` (
`id` int(11) DEFAULT NULL,
`addr` varchar(30) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
INSERT INTO `t1` (`id`, `addr`) VALUES (1, '7#\\8#');
(product)root@localhost > select * from t1;
+----+-------+
| id | addr|
+----+-------+
|1 | 7#\8# |
+----+-------+
1 row in set (0.00 sec)
目的库:
(product)root@localhost > select * from t1;
+----+------+
| id | addr |
+----+------+
|1 | 7#8# | -- 同步过来的结果少了 "\"
+----+------+
1 row in set (0.00 sec)
每次gt-checksum 的 Differences 都是 yes
# ./gt-checksum -f ./gc.conf
-- gt-checksum init configuration files --
-- gt-checksum init log files --
-- gt-checksum init check parameter --
-- gt-checksum init check table name --
-- gt-checksum init check table column --
-- gt-checksum init check table index column --
-- gt-checksum init source and dest transaction snapshoot conn pool --
-- gt-checksum init cehck table query plan and check data --
begin checkSum index table TESTDB1.T1
[█ ]100%task: 1/1
table TESTDB1.T1 checksum complete
** gt-checksum Overview of results **
Check time:0.30s (Seconds)
SchemaTable IndexCol checkMod Rows Differences Datafix
TESTDB1 T1 id rows 1,0 yes table
页:
[1]