Description
<dataHost name="shard1" maxCon="1000" minCon="10" balance="1" writeType="0" dbType="mysql" dbDriver="jdbc" switchType="-1" slaveThreshold="100">
表结构
CREATE TABLE `t_consumer` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`created_time` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
`name` varchar(105) NOT NULL DEFAULT '' COMMENT '名字',
`name2` varchar(106) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10019 DEFAULT CHARSET=utf8mb4;
当配置 dbDriver="jdbc" 时,varchar 类型长度小于106 ,查询结果会显示不全
Navicat 查询
mycat控制台查询
mysql> select * from t_consumer;
mysql> select * from t_consumer;
+-------+-----------------------+------------------------------------------------------------------+--------------------------------------+
| id | created_time | name | name2 |
+-------+-----------------------+------------------------------------------------------------------+--------------------------------------+
| 1 | NULL | 7febf94428054cd9a3163c27368e90067febf94428054cd9a3163c27368e9006 | 7febf944-2805-4cd9-a316-3c27368e9006 |
| 2 | NULL | 7febf944-2805-4cd9-a316-3c27368e9006 | 7febf944-2805-4cd9-a316-3c27368e9006 |
name 那列显示会有问题
将 dbDriver="jdbc" 时 修改成 dbDriver="native" 就可以正常显示