You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by GitBox <gi...@apache.org> on 2022/10/10 06:37:56 UTC

[GitHub] [shardingsphere] JiekerTime opened a new issue, #18860: The set names statement does not take effect.

JiekerTime opened a new issue, #18860:
URL: https://github.com/apache/shardingsphere/issues/18860

   ### Which version of ShardingSphere did you use?
   master
   
   ### Which project did you use? ShardingSphere-JDBC or ShardingSphere-Proxy?
   ShardingSphere-Proxy + MySQL
   
   ### Expected behavior
   ![image](https://user-images.githubusercontent.com/76552510/177270100-6234a093-0160-447d-be1d-695b215806e8.png)
   
   > This statement sets the three session system variables [character_set_client](https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html#sysvar_character_set_client), [character_set_connection](https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html#sysvar_character_set_connection), and [character_set_results](https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html#sysvar_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](https://user-images.githubusercontent.com/76552510/177270557-e75998c8-2e03-466f-85f2-db31ad57b8d7.png)
   
   ### Reason analyze (If you can)
   Missing functions.
   


-- 
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: notifications-unsubscribe@shardingsphere.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


[GitHub] [shardingsphere] github-actions[bot] commented on issue #18860: The set names statement does not take effect.

Posted by GitBox <gi...@apache.org>.
github-actions[bot] commented on issue #18860:
URL: https://github.com/apache/shardingsphere/issues/18860#issuecomment-1272349492

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


-- 
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: notifications-unsubscribe@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


[GitHub] [shardingsphere] dongzl commented on issue #18860: The set names statement does not take effect.

Posted by GitBox <gi...@apache.org>.
dongzl commented on issue #18860:
URL: https://github.com/apache/shardingsphere/issues/18860#issuecomment-1186691011

   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. 


-- 
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: notifications-unsubscribe@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


[GitHub] [shardingsphere] dongzl commented on issue #18860: The set names statement does not take effect.

Posted by GitBox <gi...@apache.org>.
dongzl commented on issue #18860:
URL: https://github.com/apache/shardingsphere/issues/18860#issuecomment-1176982979

   I want to try fix it.


-- 
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: notifications-unsubscribe@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


[GitHub] [shardingsphere] github-actions[bot] closed issue #18860: The set names statement does not take effect.

Posted by GitBox <gi...@apache.org>.
github-actions[bot] closed issue #18860: The set names statement does not take effect.
URL: https://github.com/apache/shardingsphere/issues/18860


-- 
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: notifications-unsubscribe@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org