search

apache / shardingsphere

Distributed SQL transaction & query engine for data sharding, scaling, encryption, and more - on any database.
Apache License 2.0
19.77k stars 6.69k forks source link

The set names statement does not take effect. #18860

Open JiekerTime opened 2 years ago

JiekerTime commented 2 years ago

Which version of ShardingSphere did you use?

master

Which project did you use? ShardingSphere-JDBC or ShardingSphere-Proxy?

ShardingSphere-Proxy + MySQL

Expected behavior

image

This statement sets the three session system variables character_set_client, character_set_connection, and character_set_results to the given character set.

refer to: https://dev.mysql.com/doc/refman/8.0/en/set-names.html

Actual behavior

image

Reason analyze (If you can)

Missing functions.

dongzl commented 2 years ago

I want to try fix it.

dongzl commented 2 years ago

Hi ShardingSphere community and @JiekerTime:

At first I thought the problem was caused by the unsupported SQL parser, But set names was supported for SQL parser.

I discuss this issue with @strongduanmu and @TeslaCN.

If we want to solve this issue, it depend on the #18738 . we should save status at the shardingsphere-proxy for set handle. and this work is doing on the #18738 and @TeslaCN is in charge of this work.

If shardingsphere-proxy support save status, I will continue to work it.

github-actions[bot] commented 1 year ago

Hello , this issue has not received a reply for several days. This issue is supposed to be closed.