You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by "hza2022x (via GitHub)" <gi...@apache.org> on 2023/02/08 06:34:12 UTC

[GitHub] [shardingsphere] hza2022x opened a new issue, #24057: writeRouteOnly hint comment does not work? ( comment is not in mysql packet payload)?thanks

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

   i execute the following sql via mysql client: 
   /* ShardingSphere hint: writeRouteOnly=true */ select  * from sku where id =5916249356177
   
   but the sql value in the following breakpoint doesn't contain the comment 'ShardingSphere hint';
   
       public MySQLComQueryPacket(final MySQLPacketPayload payload) {
           super(MySQLCommandPacketType.COM_QUERY);
           sql = payload.readStringEOF(); // here :sql = select  * from sku where id =5916249356177
       }
   
   shardingsphere version:   5.0.0
   
   could any one explain why this happened? many thanks. 
   
   


-- 
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] TeslaCN closed issue #24057: writeRouteOnly hint comment does not work? ( comment is not in mysql packet payload)?thanks

Posted by "TeslaCN (via GitHub)" <gi...@apache.org>.
TeslaCN closed issue #24057: writeRouteOnly hint comment does not work? ( comment is not in mysql packet payload)?thanks
URL: https://github.com/apache/shardingsphere/issues/24057


-- 
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] zhaojinchao95 commented on issue #24057: writeRouteOnly hint comment does not work? ( comment is not in mysql packet payload)?thanks

Posted by "zhaojinchao95 (via GitHub)" <gi...@apache.org>.
zhaojinchao95 commented on issue #24057:
URL: https://github.com/apache/shardingsphere/issues/24057#issuecomment-1422610969

   > it works after add -c to the connect String. thanks
   
   @hza2022x So, this problem are solved?


-- 
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] hza2022x commented on issue #24057: writeRouteOnly hint comment does not work? ( comment is not in mysql packet payload)?thanks

Posted by "hza2022x (via GitHub)" <gi...@apache.org>.
hza2022x commented on issue #24057:
URL: https://github.com/apache/shardingsphere/issues/24057#issuecomment-1422090290

   it workds after add -c to the connect String.  thanks


-- 
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] hza2022x commented on issue #24057: writeRouteOnly hint comment does not work? ( comment is not in mysql packet payload)?thanks

Posted by "hza2022x (via GitHub)" <gi...@apache.org>.
hza2022x commented on issue #24057:
URL: https://github.com/apache/shardingsphere/issues/24057#issuecomment-1423535386

   yes solved. thanks.


-- 
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