support SET SESSION variable - Githubissues

tidb-incubator / weir

Apache License 2.0

97 stars 40 forks source link

support SET SESSION variable #6

Closed teckick closed 3 years ago

teckick commented 4 years ago

Development Task

weir-proxy execute client SQLs in backend connection pool, so it is need to handle session variables in frontend.

I think there are two ways to support session variables.

Frontend client connection saves the session variables, and execute a SET statement before client SQL in a backend connection.
Frontend client connection holds a backend connection when SET session variables.

Each of the above has its own advantages and disadvantages. Which one should we support, or both?