配置mycat中间件使用 Navicat连接时 报错There is no primary key here. Update will only use exact matching of the o

配置mycat中间件使用 Navicat连接时 报错

There is no primary key here. Update will only use exact matching of the old values of the columns here. Thus, it may update more than one record.

解决方案:

修改 mycat 配置 schema.xml

checkSQLschema=“false” 修改成 true;

checkSQLschema

当该值为true时，例如我们执行语句select * from TESTDB.company 。mycat会把语句修改为 select * from company 去掉TESTDB。