TeslaCN opened a new issue #11276:
URL: https://github.com/apache/shardingsphere/issues/11276
## Bug Report
### Which version of ShardingSphere did you use?
5.0.0-beta
### Which project did you use? ShardingSphere-JDBC or ShardingSphere-Proxy?
Proxy
### Expected behavior
### Actual behavior
Client sent:
```
MySQL Protocol
Packet Length: 20
Packet Number: 0
Request Command Execute Statement
Command: Execute Statement (23)
Statement ID: 1
Flags: Defaults (0)
Iterations (unused): 1
New parameter bound flag: Subsequent call (0)
Payload: 0100000000000000
```
Proxy replied:
```
MySQL Protocol
Packet Length: 1
Packet Number: 1
Number of fields: 5
MySQL Protocol
Packet Length: 63
Packet Number: 2
Catalog: def
Database: sharding_db
Table: t_order
Original table: t_order
Name: order_id
Original name: order_id
Charset number: utf8 COLLATE utf8_general_ci (33)
Length: 20
Type: FIELD_TYPE_LONGLONG (8)
Flags: 0x0001
Decimals: 0
MySQL Protocol
Packet Length: 61
Packet Number: 3
Catalog: def
Database: sharding_db
Table: t_order
Original table: t_order
Name: user_id
Original name: user_id
Charset number: utf8 COLLATE utf8_general_ci (33)
Length: 20
Type: FIELD_TYPE_LONGLONG (8)
Flags: 0x0001
Decimals: 0
MySQL Protocol
Packet Length: 69
Packet Number: 4
Catalog: def
Database: sharding_db
Table: t_order
Original table: t_order
Name: create_time
Original name: create_time
Charset number: utf8 COLLATE utf8_general_ci (33)
Length: 19
Type: FIELD_TYPE_TIMESTAMP (7)
Flags: 0x0021
Decimals: 0
MySQL Protocol
Packet Length: 67
Packet Number: 5
Catalog: def
Database: sharding_db
Table: t_order
Original table: t_order
Name: order_name
Original name: order_name
Charset number: utf8 COLLATE utf8_general_ci (33)
Length: 100
Type: FIELD_TYPE_VAR_STRING (253)
Flags: 0x0021
Decimals: 0
MySQL Protocol
Packet Length: 59
Packet Number: 6
Catalog: def
Database: sharding_db
Table: t_order
Original table: t_order
Name: amount
Original name: amount
Charset number: utf8 COLLATE utf8_general_ci (33)
Length: 11
Type: FIELD_TYPE_LONG (3)
Flags: 0x0001
Decimals: 0
MySQL Protocol
Packet Length: 5
Packet Number: 7
Response Code: EOF Packet (0xfe)
EOF marker: 254
Warnings: 0
Server Status: 0x0002
MySQL Protocol
Packet Length: 34
Packet Number: 8
Response Code: OK Packet (0x00)
Affected Rows: 0
Last INSERT ID: 1
Server Status: 0x0000
Warnings: 0
Message:
MySQL Protocol
Packet Length: 5
Packet Number: 9
Response Code: EOF Packet (0xfe)
EOF marker: 254
Warnings: 0
Server Status: 0x0002
```
The 7th EOF packet is unnecessary here, which may increase the I/O cost.
### Reason analyze (If you can)
### Steps to reproduce the behavior, such as: SQL to execute, sharding rule
configuration, when exception occur etc.
### Example codes for reproduce this issue (such as a github link).
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
