error "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."

[Myshiner]

project: sharding-proxy
version: v3.1.0 & v4.0.0-RC2

question:
when i use navicate to connect sharding-proxy, and do double-click the table(any table), it can load all the datas but just threw the errors like "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."

[Myshiner]

All the tables do have primary key.

[dongzl]

I am glad to finish it.

[dongzl]

I get the network packet through Wireshark software, and find some problem.

When MySQL transfer data to Sharding-Proxy:

When Sharding-Proxy transfer data to Navicat:

the two byte data 03 50 is missing, it is the table Primary Key flag.

I think this make the mistake.

[dongzl]

I debug Sharding-Proxy source code, when execute a query SQL, it should return column metadata.
But in MySQLColumnDefinition41Packet class, the this.flags = 0 :

this is the table column primary key flag, so the Navicat prompt a error message.

the MySQLColumnDefinition41Packet build by ResultSetMetadata, but ResultSetMetadata don't have primary key info, we can find primary key info in DatabaseMetadata, but it will be a huge change.

Is this a good way?