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/03/06 07:41:12 UTC

[GitHub] [incubator-shardingsphere] brzone opened a new issue #4629: rangeAlgorithmClassName can't work ?

brzone opened a new issue #4629: rangeAlgorithmClassName can't work ?
URL: https://github.com/apache/incubator-shardingsphere/issues/4629
 
 
   I use 4.0 proxy version.
   
   here is config-sharding.yaml  :
   ![image](https://user-images.githubusercontent.com/7804031/76062241-47bab780-5fc0-11ea-904d-8e233451cfd0.png)
   
   If i use = or in ,the preciseAlgorithmClassName can be work.
   but i user >= & <= ,the rangeAlgorithmClassName can't be work, 
   
   here is the sql excute:
   ![image](https://user-images.githubusercontent.com/7804031/76062407-9b2d0580-5fc0-11ea-804a-93a8e9309481.png)
   ![image](https://user-images.githubusercontent.com/7804031/76062450-b0a22f80-5fc0-11ea-8355-e1c3aff0d296.png)
   
   but i really config rangeAlgorithmClassName , may be something is error ?
   
   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.
 
For queries about this service, please contact Infrastructure at:
users@infra.apache.org


With regards,
Apache Git Services

[GitHub] [incubator-shardingsphere] kimmking edited a comment on issue #4629: rangeAlgorithmClassName can't work ?

Posted by GitBox <gi...@apache.org>.
kimmking edited a comment on issue #4629: rangeAlgorithmClassName can't work ?
URL: https://github.com/apache/incubator-shardingsphere/issues/4629#issuecomment-597578901
 
 
   
   
   
   > i know the truth, because the databaseStrategy i use inline , so , the proxy think the table is inline ,but i set tableStrategy set standard 。
   > so tableStrategy is standard ,databaseStrategy must be standard ?
   
    @brzone 
   Can you make a simple demo to reproduce this issue for me to profiling 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


With regards,
Apache Git Services

[GitHub] [incubator-shardingsphere] kimmking edited a comment on issue #4629: rangeAlgorithmClassName can't work ?

Posted by GitBox <gi...@apache.org>.
kimmking edited a comment on issue #4629: rangeAlgorithmClassName can't work ?
URL: https://github.com/apache/incubator-shardingsphere/issues/4629#issuecomment-597578901
 
 
   
   
   
   > i know the truth, because the databaseStrategy i use inline , so , the proxy think the table is inline ,but i set tableStrategy set standard 。
   > so tableStrategy is standard ,databaseStrategy must be standard ?
   
    
   Can you make a simple demo to reproduce this issue for me to profiling 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


With regards,
Apache Git Services

[GitHub] [incubator-shardingsphere] kimmking commented on issue #4629: rangeAlgorithmClassName can't work ?

Posted by GitBox <gi...@apache.org>.
kimmking commented on issue #4629: rangeAlgorithmClassName can't work ?
URL: https://github.com/apache/incubator-shardingsphere/issues/4629#issuecomment-597578901
 
 
   Can you make a simple demo to reproduce this issue for me to profiling 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


With regards,
Apache Git Services

[GitHub] [incubator-shardingsphere] brzone commented on issue #4629: rangeAlgorithmClassName can't work ?

Posted by GitBox <gi...@apache.org>.
brzone commented on issue #4629: rangeAlgorithmClassName can't work ?
URL: https://github.com/apache/incubator-shardingsphere/issues/4629#issuecomment-597582349
 
 
   ![image](https://user-images.githubusercontent.com/7804031/76412530-b936a380-63ce-11ea-93ad-3299611c2146.png)
   this config throw : Inline strategy cannot suppory range sharding
   
   ![image](https://user-images.githubusercontent.com/7804031/76412696-00bd2f80-63cf-11ea-833d-2bc545090ccb.png)
   no databaseStrategy  inline config can be ok .
   
   i means ,  databaseStrategy of inline can affect tableStrategy's standard  .
   
   

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


With regards,
Apache Git Services

[GitHub] [incubator-shardingsphere] terrymanu closed issue #4629: rangeAlgorithmClassName can't work ?

Posted by GitBox <gi...@apache.org>.
terrymanu closed issue #4629: rangeAlgorithmClassName can't work ?
URL: https://github.com/apache/incubator-shardingsphere/issues/4629
 
 
   

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


With regards,
Apache Git Services

[GitHub] [incubator-shardingsphere] brzone commented on issue #4629: rangeAlgorithmClassName can't work ?

Posted by GitBox <gi...@apache.org>.
brzone commented on issue #4629: rangeAlgorithmClassName can't work ?
URL: https://github.com/apache/incubator-shardingsphere/issues/4629#issuecomment-595677091
 
 
   yes，see the log must be config a inline strategy.
   but the picture,  i really config stardard,  user myself RangeShardingAlgorithm

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


With regards,
Apache Git Services

[GitHub] [incubator-shardingsphere] kimmking commented on issue #4629: rangeAlgorithmClassName can't work ?

Posted by GitBox <gi...@apache.org>.
kimmking commented on issue #4629: rangeAlgorithmClassName can't work ?
URL: https://github.com/apache/incubator-shardingsphere/issues/4629#issuecomment-595676162
 
 
   According the log, you config a inline strategy, plz check 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


With regards,
Apache Git Services

[GitHub] [incubator-shardingsphere] brzone commented on issue #4629: rangeAlgorithmClassName can't work ?

Posted by GitBox <gi...@apache.org>.
brzone commented on issue #4629: rangeAlgorithmClassName can't work ?
URL: https://github.com/apache/incubator-shardingsphere/issues/4629#issuecomment-595681943
 
 
   i know the truth,   because the databaseStrategy i use inline , so , the proxy think the table is inline ,but i set tableStrategy set standard 。
   so  tableStrategy  is standard ,databaseStrategy  must be standard  ? 
   

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


With regards,
Apache Git Services

[GitHub] [incubator-shardingsphere] terrymanu commented on issue #4629: rangeAlgorithmClassName can't work ?

Posted by GitBox <gi...@apache.org>.
terrymanu commented on issue #4629: rangeAlgorithmClassName can't work ?
URL: https://github.com/apache/incubator-shardingsphere/issues/4629#issuecomment-607016324
 
 
   Just the information said: Inline strategy cannot suppory range sharding
   
   If you want use range sharding, please config range algorithm, please see example to get more information.

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


With regards,
Apache Git Services