A bug in mycat1.5~1.6

The following statements are performed normally in MySQL single library:

SELECT * from Device WHERE devicetype= ' AMS. Monitoring.XlCloud.QKL8154.XLCloudDevice '

But if you open it in Mycat/conf/schema.xml,

Checksqlschema= "true"

You cannot perform the correct execution on Mycat:

Explain SELECT * from device WHERE devicetype= ' AMS. Monitoring.XlCloud.QKL8154.XLCloudDevice '

The query condition error is parsed into:

SELECT * from Device WHERE devicetype= ' AMS. Xlcloud.qkl8154xlclouddevice '

If you want to turn on checksqlschema= "true" and want to query normally, you need to escape the English dot in the query condition:

SELECT * from Device WHERE devicetype= ' ams\. monitoring\. Xlcloud\. Qkl8154\. Xlclouddevice '

Don't know if it's a bug.

A bug in mycat1.5~1.6