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 2020/08/20 04:45:23 UTC
[GitHub] [shardingsphere] zhaopinglu commented on issue #6938: ss-proxy 4.1.1 doesn't support "WHERE (( USER, HOST ) IN (( 'root', 'localhost' ),( '', '' )))"
zhaopinglu commented on issue #6938:
URL: https://github.com/apache/shardingsphere/issues/6938#issuecomment-677052282
> @zhaopinglu Hi You mean the SQL below runs well for MySQL but badly for ShardingProxy?
>
> > SELECT USER, HOST FROM PERFORMANCE_SCHEMA.accounts WHERE (( USER, HOST ) IN (( 'root', 'localhost' ),( '', '' )));
>
> How about the following one? @jingshanglu Do you think it can work fine in our `master branch`?
>
> > SELECT USER, HOST FROM PERFORMANCE_SCHEMA.accounts WHERE ( USER, HOST ) IN (( 'root', 'localhost' ),( '', '' ));
Yes. Exactly.
Both 2 SQLs run well on MySQL (5.7.31) directly, but run to fail on ss-proxy 4.1.1
BTW, is there a guide described how to build ss-proxy from master branch? If yes, I'd like to test 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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org