MySQL Bugs: #90696: Support specifying default schema in X protocol handshake

Bug #90696	Support specifying default schema in X protocol handshake
Submitted:	30 Apr 2018 17:41	Modified:	28 Feb 2020 4:43
Reporter:	Jason Rahman	Email Updates:
Status:	Verified	Impact on me:	None
Category:	MySQL Server: Document Store: X Plugin	Severity:	S4 (Feature request)
Version:	8.0	OS:	Any
Assigned to:		CPU Architecture:	Any

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
From the documentation, the X protocol does not appear to support specifying the default database for the session during the initial handshake. 

How to repeat:
Documentation indicates this is not possible.

Suggested fix:
Allow optionally specifying the default database of a connection on initial connection establishment. By sending the default database up front, clients can avoid a round trip to set the default schema for the session. Also, support this feature for the reset message, since connection pools can use a reset to clear a connection and set a new database in one round trip.

Hello Jason,

Thank you for the feature request!

regards,
Umesh