[GitHub] [incubator-shardingsphere-doc] dongzl opened a new pull request #413: add new committer, Github ID: dongzl .

2019-12-30 Thread GitBox
dongzl opened a new pull request #413: add new committer, Github ID: dongzl .
URL: https://github.com/apache/incubator-shardingsphere-doc/pull/413
 
 
   add new committer, Github ID: dongzl .


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:
us...@infra.apache.org


With regards,
Apache Git Services


[GitHub] [incubator-shardingsphere] terrymanu edited a comment on issue #3840: Why does the INSERT SQL have no routing

2019-12-30 Thread GitBox
terrymanu edited a comment on issue #3840: Why does the INSERT SQL have no 
routing
URL: 
https://github.com/apache/incubator-shardingsphere/issues/3840#issuecomment-569863703
 
 
   I guess in your SQL have some keyword of MySQL, such as `Password`, 
`Position`.
   Because of 4.0.0-RC1 is not stable, so can you try 4.0.0-RC3?


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:
us...@infra.apache.org


With regards,
Apache Git Services


[GitHub] [incubator-shardingsphere] terrymanu commented on issue #3840: Why does the INSERT SQL have no routing

2019-12-30 Thread GitBox
terrymanu commented on issue #3840: Why does the INSERT SQL have no routing
URL: 
https://github.com/apache/incubator-shardingsphere/issues/3840#issuecomment-569863703
 
 
   I guess in your SQL have some keyword of MySQL, such as `password`, 
`Position`.
   Because of 4.0.0-RC1 is not stable, so can you try 4.0.0-RC3?


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:
us...@infra.apache.org


With regards,
Apache Git Services


[GitHub] [incubator-shardingsphere] terrymanu edited a comment on issue #3840: Why does the INSERT SQL have no routing

2019-12-30 Thread GitBox
terrymanu edited a comment on issue #3840: Why does the INSERT SQL have no 
routing
URL: 
https://github.com/apache/incubator-shardingsphere/issues/3840#issuecomment-569863520
 
 
   Any exception or warning occur?


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:
us...@infra.apache.org


With regards,
Apache Git Services


[GitHub] [incubator-shardingsphere] terrymanu commented on issue #3840: Why does the INSERT SQL have no routing

2019-12-30 Thread GitBox
terrymanu commented on issue #3840: Why does the INSERT SQL have no routing
URL: 
https://github.com/apache/incubator-shardingsphere/issues/3840#issuecomment-569863520
 
 
   Any exception occur?


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:
us...@infra.apache.org


With regards,
Apache Git Services


[GitHub] [incubator-shardingsphere] beijixi edited a comment on issue #3840: Why does the INSERT SQL have no routing

2019-12-30 Thread GitBox
beijixi edited a comment on issue #3840: Why does the INSERT SQL have no routing
URL: 
https://github.com/apache/incubator-shardingsphere/issues/3840#issuecomment-569860867
 
 
   **version**:4.0.0-RC1
   
   **sql.show:**
   **Logic SQL:** INSERT INTO 
LDPerson(PersonID,CustomerNo,Name,Sex,Birthday,IDType,IDNo,Password,NativePlace,Nationality,RgtAddress,Marriage,MarriageDate,Health,Stature,Avoirdupois,Degree,CreditGrade,OthIDType,OthIDNo,ICNo,GrpNo,JoinCompanyDate,StartWorkDate,Position,Salary,OccupationType,OccupationCode,WorkType,PluralityType,DeathDate,SmokeFlag,BlacklistFlag,Proterty,Remark,State,VIPValue,Operator,MakeDate,MakeTime,ModifyDate,ModifyTime,GrpName,License,LicenseType,IDValidate,Socialinsuno)
 VALUES( ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? 
, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? 
, ? , ? , ? , ? , ? , ? , ? , ? , ?)
   
   **SQLStatement:** 
InsertStatement(super=DMLStatement(super=AbstractSQLStatement(type=DML, 
tables=Tables(tables=[Table(name=LDPerson, alias=Optional.absent())]), 
routeConditions=Conditions(orCondition=OrCondition(andConditions=[])), 
encryptConditions=Conditions(orCondition=OrCondition(andConditions=[])), 
sqlTokens=[TableToken(tableName=LDPerson, quoteCharacter=NONE, 
schemaNameLength=0)], parametersIndex=0, logicSQL=INSERT INTO 
LDPerson(PersonID,CustomerNo,Name,Sex,Birthday,IDType,IDNo,Password,NativePlace,Nationality,RgtAddress,Marriage,MarriageDate,Health,Stature,Avoirdupois,Degree,CreditGrade,OthIDType,OthIDNo,ICNo,GrpNo,JoinCompanyDate,StartWorkDate,Position,Salary,OccupationType,OccupationCode,WorkType,PluralityType,DeathDate,SmokeFlag,BlacklistFlag,Proterty,Remark,State,VIPValue,Operator,MakeDate,MakeTime,ModifyDate,ModifyTime,GrpName,License,LicenseType,IDValidate,Socialinsuno)
 VALUES( ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? 
, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? 
, ? , ? , ? , ? , ? , ? , ? , ? , ?)), deleteStatement=false, 
updateTableAlias={}, updateColumnValues={}, whereStartIndex=0, 
whereStopIndex=0, whereParameterStartIndex=0, whereParameterEndIndex=0), 
columnNames=[], values=[])
   
   **Actual SQL: ds0** ::: INSERT INTO 
LDPerson(PersonID,CustomerNo,Name,Sex,Birthday,IDType,IDNo,Password,NativePlace,Nationality,RgtAddress,Marriage,MarriageDate,Health,Stature,Avoirdupois,Degree,CreditGrade,OthIDType,OthIDNo,ICNo,GrpNo,JoinCompanyDate,StartWorkDate,Position,Salary,OccupationType,OccupationCode,WorkType,PluralityType,DeathDate,SmokeFlag,BlacklistFlag,Proterty,Remark,State,VIPValue,Operator,MakeDate,MakeTime,ModifyDate,ModifyTime,GrpName,License,LicenseType,IDValidate,Socialinsuno)
 VALUES( ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? 
, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? 
, ? , ? , ? , ? , ? , ? , ? , ? , ?) ::: [101901, 050380, Jason, 0, 
1999-01-01T00:00:00.000+0800, 0, 212365432, null, null, null, null, null, null, 
null, 0.0, 0.0, null, null, null, null, null, null, null, null, null, 0.0, 
null, null, null, null, null, null, null, null, null, 1, null, cbs, 
2019-12-31T00:00:00.000+0800, 12:14:10, 2019-12-31T00:00:00.000+0800, 12:14:10, 
null, null, null, null, null]
   
   **Actual SQL: ds1** ::: INSERT INTO 
LDPerson(PersonID,CustomerNo,Name,Sex,Birthday,IDType,IDNo,Password,NativePlace,Nationality,RgtAddress,Marriage,MarriageDate,Health,Stature,Avoirdupois,Degree,CreditGrade,OthIDType,OthIDNo,ICNo,GrpNo,JoinCompanyDate,StartWorkDate,Position,Salary,OccupationType,OccupationCode,WorkType,PluralityType,DeathDate,SmokeFlag,BlacklistFlag,Proterty,Remark,State,VIPValue,Operator,MakeDate,MakeTime,ModifyDate,ModifyTime,GrpName,License,LicenseType,IDValidate,Socialinsuno)
 VALUES( ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? 
, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? 
, ? , ? , ? , ? , ? , ? , ? , ? , ?) ::: [101901, 050380, Jason, 0, 
1999-01-01T00:00:00.000+0800, 0, 212365432, null, null, null, null, null, null, 
null, 0.0, 0.0, null, null, null, null, null, null, null, null, null, 0.0, 
null, null, null, null, null, null, null, null, null, 1, null, cbs, 
2019-12-31T00:00:00.000+0800, 12:14:10, 2019-12-31T00:00:00.000+0800, 12:14:10, 
null, null, null, null, null]


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:
us...@infra.apache.org


With regards,
Apache Git Services


[GitHub] [incubator-shardingsphere] beijixi commented on issue #3840: Why does the INSERT SQL have no routing

2019-12-30 Thread GitBox
beijixi commented on issue #3840: Why does the INSERT SQL have no routing
URL: 
https://github.com/apache/incubator-shardingsphere/issues/3840#issuecomment-569860867
 
 
   **version:**4.0.0-RC1
   
   **sql.show:**
   **Logic SQL:** INSERT INTO 
LDPerson(PersonID,CustomerNo,Name,Sex,Birthday,IDType,IDNo,Password,NativePlace,Nationality,RgtAddress,Marriage,MarriageDate,Health,Stature,Avoirdupois,Degree,CreditGrade,OthIDType,OthIDNo,ICNo,GrpNo,JoinCompanyDate,StartWorkDate,Position,Salary,OccupationType,OccupationCode,WorkType,PluralityType,DeathDate,SmokeFlag,BlacklistFlag,Proterty,Remark,State,VIPValue,Operator,MakeDate,MakeTime,ModifyDate,ModifyTime,GrpName,License,LicenseType,IDValidate,Socialinsuno)
 VALUES( ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? 
, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? 
, ? , ? , ? , ? , ? , ? , ? , ? , ?)
   
   **SQLStatement:** 
InsertStatement(super=DMLStatement(super=AbstractSQLStatement(type=DML, 
tables=Tables(tables=[Table(name=LDPerson, alias=Optional.absent())]), 
routeConditions=Conditions(orCondition=OrCondition(andConditions=[])), 
encryptConditions=Conditions(orCondition=OrCondition(andConditions=[])), 
sqlTokens=[TableToken(tableName=LDPerson, quoteCharacter=NONE, 
schemaNameLength=0)], parametersIndex=0, logicSQL=INSERT INTO 
LDPerson(PersonID,CustomerNo,Name,Sex,Birthday,IDType,IDNo,Password,NativePlace,Nationality,RgtAddress,Marriage,MarriageDate,Health,Stature,Avoirdupois,Degree,CreditGrade,OthIDType,OthIDNo,ICNo,GrpNo,JoinCompanyDate,StartWorkDate,Position,Salary,OccupationType,OccupationCode,WorkType,PluralityType,DeathDate,SmokeFlag,BlacklistFlag,Proterty,Remark,State,VIPValue,Operator,MakeDate,MakeTime,ModifyDate,ModifyTime,GrpName,License,LicenseType,IDValidate,Socialinsuno)
 VALUES( ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? 
, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? 
, ? , ? , ? , ? , ? , ? , ? , ? , ?)), deleteStatement=false, 
updateTableAlias={}, updateColumnValues={}, whereStartIndex=0, 
whereStopIndex=0, whereParameterStartIndex=0, whereParameterEndIndex=0), 
columnNames=[], values=[])
   
   **Actual SQL: ds0** ::: INSERT INTO 
LDPerson(PersonID,CustomerNo,Name,Sex,Birthday,IDType,IDNo,Password,NativePlace,Nationality,RgtAddress,Marriage,MarriageDate,Health,Stature,Avoirdupois,Degree,CreditGrade,OthIDType,OthIDNo,ICNo,GrpNo,JoinCompanyDate,StartWorkDate,Position,Salary,OccupationType,OccupationCode,WorkType,PluralityType,DeathDate,SmokeFlag,BlacklistFlag,Proterty,Remark,State,VIPValue,Operator,MakeDate,MakeTime,ModifyDate,ModifyTime,GrpName,License,LicenseType,IDValidate,Socialinsuno)
 VALUES( ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? 
, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? 
, ? , ? , ? , ? , ? , ? , ? , ? , ?) ::: [101901, 050380, Jason, 0, 
1999-01-01T00:00:00.000+0800, 0, 212365432, null, null, null, null, null, null, 
null, 0.0, 0.0, null, null, null, null, null, null, null, null, null, 0.0, 
null, null, null, null, null, null, null, null, null, 1, null, cbs, 
2019-12-31T00:00:00.000+0800, 12:14:10, 2019-12-31T00:00:00.000+0800, 12:14:10, 
null, null, null, null, null]
   
   **Actual SQL: ds1** ::: INSERT INTO 
LDPerson(PersonID,CustomerNo,Name,Sex,Birthday,IDType,IDNo,Password,NativePlace,Nationality,RgtAddress,Marriage,MarriageDate,Health,Stature,Avoirdupois,Degree,CreditGrade,OthIDType,OthIDNo,ICNo,GrpNo,JoinCompanyDate,StartWorkDate,Position,Salary,OccupationType,OccupationCode,WorkType,PluralityType,DeathDate,SmokeFlag,BlacklistFlag,Proterty,Remark,State,VIPValue,Operator,MakeDate,MakeTime,ModifyDate,ModifyTime,GrpName,License,LicenseType,IDValidate,Socialinsuno)
 VALUES( ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? 
, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? 
, ? , ? , ? , ? , ? , ? , ? , ? , ?) ::: [101901, 050380, Jason, 0, 
1999-01-01T00:00:00.000+0800, 0, 212365432, null, null, null, null, null, null, 
null, 0.0, 0.0, null, null, null, null, null, null, null, null, null, 0.0, 
null, null, null, null, null, null, null, null, null, 1, null, cbs, 
2019-12-31T00:00:00.000+0800, 12:14:10, 2019-12-31T00:00:00.000+0800, 12:14:10, 
null, null, null, null, null]


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:
us...@infra.apache.org


With regards,
Apache Git Services


[GitHub] [incubator-shardingsphere-doc] terrymanu merged pull request #412: Update asf-site(update user list)

2019-12-30 Thread GitBox
terrymanu merged pull request #412: Update asf-site(update user list)
URL: https://github.com/apache/incubator-shardingsphere-doc/pull/412
 
 
   


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:
us...@infra.apache.org


With regards,
Apache Git Services


[GitHub] [incubator-shardingsphere] terrymanu commented on issue #3840: Why does the INSERT SQL have no routing

2019-12-30 Thread GitBox
terrymanu commented on issue #3840: Why does the INSERT SQL have no routing
URL: 
https://github.com/apache/incubator-shardingsphere/issues/3840#issuecomment-569860041
 
 
   What is your version? Can you provide your `sql.show`?


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:
us...@infra.apache.org


With regards,
Apache Git Services


[GitHub] [incubator-shardingsphere] terrymanu commented on issue #3839: 广播表、绑定表配置无效 yml是否需要加spring: shardingsphere:前缀

2019-12-30 Thread GitBox
terrymanu commented on issue #3839: 广播表、绑定表配置无效 yml是否需要加spring:   
shardingsphere:前缀
URL: 
https://github.com/apache/incubator-shardingsphere/issues/3839#issuecomment-569859926
 
 
   **For English only**, other languages will not accept.


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:
us...@infra.apache.org


With regards,
Apache Git Services


[GitHub] [incubator-shardingsphere] terrymanu closed issue #3839: 广播表、绑定表配置无效 yml是否需要加spring: shardingsphere:前缀

2019-12-30 Thread GitBox
terrymanu closed issue #3839: 广播表、绑定表配置无效 yml是否需要加spring:   shardingsphere:前缀
URL: https://github.com/apache/incubator-shardingsphere/issues/3839
 
 
   


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:
us...@infra.apache.org


With regards,
Apache Git Services


[incubator-shardingsphere-benchmark] branch master updated: for performance

2019-12-30 Thread zhaoyanan
This is an automated email from the ASF dual-hosted git repository.

zhaoyanan pushed a commit to branch master
in repository 
https://gitbox.apache.org/repos/asf/incubator-shardingsphere-benchmark.git


The following commit(s) were added to refs/heads/master by this push:
 new a374c19  for performance
a374c19 is described below

commit a374c19ad77dca45e4e5772ceb02969b903331b3
Author: nancyzrh 
AuthorDate: Tue Dec 31 10:59:22 2019 +0800

for performance
---
 report/jtl_json/master_slave_test.json | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/report/jtl_json/master_slave_test.json 
b/report/jtl_json/master_slave_test.json
index 8b7973f..ad54567 100644
--- a/report/jtl_json/master_slave_test.json
+++ b/report/jtl_json/master_slave_test.json
@@ -1 +1 @@
-{"SELECT": [{"data": [], "type": "Sharding-Proxy_3.1"}, {"data": [{"99.9th": 
"3", "Err": "0.0%", "95th": "2", "50th": "1", "Max": "16", "Min": "0", 
"Throughout": "21067.69", "Samples": 99, "Date": "2019.12.19 02:40:22 ", 
"Avg": "0"}, {"99.9th": "3", "Err": "0.0%", "95th": "2", "50th": "1", "Max": 
"25", "Min": "0", "Throughout": "21041.54", "Samples": 99, "Date": 
"2019.12.20 13:39:12 ", "Avg": "0"}, {"99.9th": "3", "Err": "0.0%", "95th": 
"2", "50th": "1", "Max": "11", "Min": "0",  [...]
\ No newline at end of file
+{"INSERT+SELECT+DELETE": [{"data": [], "type": "Sharding-Proxy_3.1"}, {"data": 
[{"99.9th": "31", "Err": "0.0%", "95th": "16", "50th": "11", "Max": "44", 
"Min": "6", "Throughout": "1759.16", "Samples": 51978, "Date": "2019.12.31 
02:49:38 ", "Avg": "11"}], "type": "Sharding-Proxy"}, {"data": [{"99.9th": 
"29", "Err": "0.0%", "95th": "14", "50th": "11", "Max": "56", "Min": "5", 
"Throughout": "1900.65", "Samples": 131295, "Date": "2019.12.31 02:48:23 ", 
"Avg": "10"}], "type": "Sharding-JDBC"} [...]
\ No newline at end of file



[GitHub] [incubator-shardingsphere] yanyzy merged pull request #3838: Enhance shadow rule configuration

2019-12-30 Thread GitBox
yanyzy merged pull request #3838: Enhance shadow rule configuration
URL: https://github.com/apache/incubator-shardingsphere/pull/3838
 
 
   


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:
us...@infra.apache.org


With regards,
Apache Git Services


[GitHub] [incubator-shardingsphere] beijixi opened a new issue #3840: Why does the INSERT SQL have no routing

2019-12-30 Thread GitBox
beijixi opened a new issue #3840: Why does the INSERT SQL have no routing
URL: https://github.com/apache/incubator-shardingsphere/issues/3840
 
 
   ## Question
   
   **sql:**  
   `INSERT INTO 
LDPerson(PersonID,CustomerNo,Name,Sex,Birthday,IDType,IDNo,Password,NativePlace,Nationality,RgtAddress,Marriage,MarriageDate,Health,Stature,Avoirdupois,Degree,CreditGrade,OthIDType,OthIDNo,ICNo,GrpNo,JoinCompanyDate,StartWorkDate,Position,Salary,OccupationType,OccupationCode,WorkType,PluralityType,DeathDate,SmokeFlag,BlacklistFlag,Proterty,Remark,State,VIPValue,Operator,MakeDate,MakeTime,ModifyDate,ModifyTime,GrpName,License,LicenseType,IDValidate,Socialinsuno)
   VALUES(101802,'12323123' ,'李白11', 0 ,'1999-01-01',0, '22232223' , null , 
null , null , null , null , null , null , 0.0 , 0.0 , null , null , null , null 
, null , null , null , null , null , 0.0 , null , null , null , null , null , 
null , null , null , null , '1' , null , 'cbs' , '2019-12-30' , '18:26:52' , 
'2019-12-30' , '18:26:52' , null , null , null , null , null);`
   **sharding-config:**
   LDPerson:
     actualDataNodes: ds${0..1}.LDPerson
  databaseStrategy:
   inline:
    shardingColumn: PersonID
  algorithmExpression: ds${PersonID % 2}
  
   **description:**
   No matter which field is used as the route key,the data exists in ds0 and ds1


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:
us...@infra.apache.org


With regards,
Apache Git Services


[GitHub] [incubator-shardingsphere] yanickxia opened a new pull request #3838: Enhance shadow rule configuration

2019-12-30 Thread GitBox
yanickxia opened a new pull request #3838: Enhance shadow rule configuration
URL: https://github.com/apache/incubator-shardingsphere/pull/3838
 
 
   Changes proposed in this pull request:
   - Modify shadow rule similar sharding rule
   
   
   ---
   This change is [https://reviewable.io/review_button.svg"; 
height="34" align="absmiddle" 
alt="Reviewable"/>](https://reviewable.io/reviews/apache/incubator-shardingsphere/3838)
   
   


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:
us...@infra.apache.org


With regards,
Apache Git Services


[GitHub] [incubator-shardingsphere] yanyzy closed pull request #3838: Enhance shadow rule configuration

2019-12-30 Thread GitBox
yanyzy closed pull request #3838: Enhance shadow rule configuration
URL: https://github.com/apache/incubator-shardingsphere/pull/3838
 
 
   


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:
us...@infra.apache.org


With regards,
Apache Git Services


[GitHub] [incubator-shardingsphere] strongduanmu commented on issue #234: Welcome to leave your company's info(欢迎使用ShardingSphere的公司在此登记)

2019-12-30 Thread GitBox
strongduanmu commented on issue #234: Welcome to leave your company's 
info(欢迎使用ShardingSphere的公司在此登记)
URL: 
https://github.com/apache/incubator-shardingsphere/issues/234#issuecomment-569845946
 
 
   南京爱福路汽车科技 http://www.f6car.com/


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:
us...@infra.apache.org


With regards,
Apache Git Services


[incubator-shardingsphere-benchmark] branch master updated: for performance

2019-12-30 Thread zhaoyanan
This is an automated email from the ASF dual-hosted git repository.

zhaoyanan pushed a commit to branch master
in repository 
https://gitbox.apache.org/repos/asf/incubator-shardingsphere-benchmark.git


The following commit(s) were added to refs/heads/master by this push:
 new bc5484b  for performance
bc5484b is described below

commit bc5484b567eeab18d45e23279d5fdccab247522d
Author: nancyzrh 
AuthorDate: Tue Dec 31 02:50:52 2019 +0800

for performance
---
 report/data/3.0_single_delete_merge.log_plot| 1 +
 report/data/3.0_single_insert_merge.log_plot| 1 +
 report/data/3.0_single_select_merge.log_plot| 1 +
 report/data/3.0_single_update_merge.log_plot| 1 +
 report/data/3.0_sp_delete_raw_merge.log_plot| 1 +
 report/data/3.0_sp_insert_raw_merge.log_plot| 1 +
 report/data/3.0_sp_select_raw_merge.log_plot| 1 +
 report/data/3.0_sp_update_raw_merge.log_plot| 1 +
 report/data/4.0_single_delete_merge.log_plot| 1 +
 report/data/4.0_single_insert_merge.log_plot| 1 +
 report/data/4.0_single_update_merge.log_plot| 1 +
 report/data/4.0_sp_delete_raw_merge.log_plot| 1 +
 report/data/4.0_sp_insert_raw_merge.log_plot| 1 +
 report/data/4.0_sp_update_raw_merge.log_plot| 1 +
 report/data/direct_delete_merge.log_plot| 1 +
 report/data/direct_update_merge.log_plot| 1 +
 report/data/encrypt/4.0_sp_delete_enc.log_plot  | 1 +
 report/data/encrypt/4.0_sp_delete_enc_sharding.log_plot | 1 +
 report/data/encrypt/4.0_sp_insert_enc.log_plot  | 1 +
 report/data/encrypt/4.0_sp_insert_enc_sharding.log_plot | 1 +
 report/data/encrypt/4.0_sp_update_enc.log_plot  | 1 +
 report/data/encrypt/4.0_sp_update_enc_sharding.log_plot | 1 +
 report/data/jdbc/3.0_sj_ms_delete.log_plot  | 1 +
 report/data/jdbc/3.0_sj_ms_insert.log_plot  | 1 +
 report/data/jdbc/3.0_sj_ms_select.log_plot  | 1 +
 report/data/jdbc/3.0_sj_ms_sharding_delete.log_plot | 1 +
 report/data/jdbc/3.0_sj_ms_sharding_insert.log_plot | 1 +
 report/data/jdbc/3.0_sj_ms_sharding_update.log_plot | 1 +
 report/data/jdbc/3.0_sj_sharding_delete.log_plot| 1 +
 report/data/jdbc/3.0_sj_sharding_insert.log_plot| 1 +
 report/data/jdbc/3.0_sj_sharding_update.log_plot| 1 +
 report/data/jdbc/4.0_sj_delete_raw.log_plot | 1 +
 report/data/jdbc/4.0_sj_enc_delete.log_plot | 1 +
 report/data/jdbc/4.0_sj_enc_delete_sharding.log_plot| 1 +
 report/data/jdbc/4.0_sj_enc_insert.log_plot | 1 +
 report/data/jdbc/4.0_sj_enc_insert_sharding.log_plot| 1 +
 report/data/jdbc/4.0_sj_enc_update.log_plot | 1 +
 report/data/jdbc/4.0_sj_enc_update_sharding.log_plot| 1 +
 report/data/jdbc/4.0_sj_insert_raw.log_plot | 1 +
 report/data/jdbc/4.0_sj_ms_delete.log_plot  | 1 +
 report/data/jdbc/4.0_sj_ms_insert.log_plot  | 1 +
 report/data/jdbc/4.0_sj_ms_sharding_delete.log_plot | 1 +
 report/data/jdbc/4.0_sj_ms_sharding_insert.log_plot | 1 +
 report/data/jdbc/4.0_sj_ms_sharding_update.log_plot | 1 +
 report/data/jdbc/4.0_sj_ms_update.log_plot  | 1 +
 report/data/jdbc/4.0_sj_sharding_delete.log_plot| 1 +
 report/data/jdbc/4.0_sj_sharding_insert.log_plot| 1 +
 report/data/jdbc/4.0_sj_sharding_update.log_plot| 1 +
 report/data/jdbc/4.0_sj_update_raw.log_plot | 1 +
 report/data/master_slave/3.0_sp_delete_ms.log_plot  | 1 +
 report/data/master_slave/3.0_sp_delete_ms_sharding.log_plot | 1 +
 report/data/master_slave/3.0_sp_insert_ms.log_plot  | 1 +
 report/data/master_slave/3.0_sp_insert_ms_sharding.log_plot | 1 +
 report/data/master_slave/3.0_sp_select_ms.log_plot  | 1 +
 report/data/master_slave/3.0_sp_select_ms_sharding.log_plot | 1 +
 report/data/master_slave/3.0_sp_update_ms.log_plot  | 1 +
 report/data/master_slave/3.0_sp_update_ms_sharding.log_plot | 1 +
 report/data/master_slave/4.0_sp_delete_ms.log_plot  | 1 +
 report/data/master_slave/4.0_sp_delete_ms_sharding.log_plot | 1 +
 report/data/master_slave/4.0_sp_insert_ms.log_plot  | 1 +
 report/data/master_slave/4.0_sp_insert_ms_sharding.log_plot | 1 +
 report/data/master_slave/4.0_sp_update_ms.log_plot  | 1 +
 report/data/master_slave/4.0_sp_update_ms_sharding.log_plot | 1 +
 report/jtl_json/full_route_test.json| 2 +-
 report/jtl_json/master_slave_encrypt_sharding_test.json | 2 +-
 report/jtl_json/single_route_test.json  | 2 +-
 66 files changed, 66 insertions(+), 3 deletions(-)

diff --git a/report/data/3.0_single_delete_merge.lo

[GitHub] [incubator-shardingsphere] maojing123 commented on issue #3839: 广播表、绑定表配置无效 yml是否需要加spring: shardingsphere:前缀

2019-12-30 Thread GitBox
maojing123 commented on issue #3839: 广播表、绑定表配置无效 yml是否需要加spring:   
shardingsphere:前缀
URL: 
https://github.com/apache/incubator-shardingsphere/issues/3839#issuecomment-569733821
 
 
   不加spring:
 shardingsphere:好像按照官网的配置是dataSources:shardingRule:开头的 。是不是官网的少了部分没有写出来了?


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:
us...@infra.apache.org


With regards,
Apache Git Services


[GitHub] [incubator-shardingsphere] maojing123 opened a new issue #3839: 广播表、绑定表配置无效

2019-12-30 Thread GitBox
maojing123 opened a new issue #3839: 广播表、绑定表配置无效
URL: https://github.com/apache/incubator-shardingsphere/issues/3839
 
 
   麻烦帮忙看看 如下对应的yML配置为什么没有生效
   
   
![image](https://user-images.githubusercontent.com/48919665/71591490-874fc800-2b67-11ea-8997-f82baa0af224.png)
   
   
   官网的看yml对应广播表是broadcastTables
   
![image](https://user-images.githubusercontent.com/48919665/71591631-080ec400-2b68-11ea-80ec-bc45dd21d15c.png)
   
   但是按照官网的配置不生效 请问 如何配置了 是否有相关的demo或者文章之类的(不看官网的 官网的真的和实际的配置不一样配置好久没生效)麻烦指点
   


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:
us...@infra.apache.org


With regards,
Apache Git Services


[GitHub] [incubator-shardingsphere] yanickxia opened a new pull request #3838: Enhance shadow rule configuration

2019-12-30 Thread GitBox
yanickxia opened a new pull request #3838: Enhance shadow rule configuration
URL: https://github.com/apache/incubator-shardingsphere/pull/3838
 
 
   Changes proposed in this pull request:
   - Modify shadow rule similar sharding rule
   


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:
us...@infra.apache.org


With regards,
Apache Git Services


[GitHub] [incubator-shardingsphere] HongJinFeng commented on issue #3635: Must the table name be lowercase when set by sharding conifg?

2019-12-30 Thread GitBox
HongJinFeng commented on issue #3635: Must the table name be lowercase when set 
by sharding conifg?
URL: 
https://github.com/apache/incubator-shardingsphere/issues/3635#issuecomment-569710619
 
 
   > The reason of convert logic table name to lower case is ShardingSphere 
should case insensitive of logic table name.
   
   Got 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:
us...@infra.apache.org


With regards,
Apache Git Services


[GitHub] [incubator-shardingsphere-doc] haetao opened a new pull request #412: Update asf-site(update user list)

2019-12-30 Thread GitBox
haetao opened a new pull request #412: Update asf-site(update user list)
URL: https://github.com/apache/incubator-shardingsphere-doc/pull/412
 
 
   


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:
us...@infra.apache.org


With regards,
Apache Git Services


[GitHub] [incubator-shardingsphere] LuciferZK closed issue #3831: sharding-jdbc-spring-boot-starter 4.0.0-RC2 integration version problem

2019-12-30 Thread GitBox
LuciferZK closed issue #3831: sharding-jdbc-spring-boot-starter 4.0.0-RC2 
integration version problem
URL: https://github.com/apache/incubator-shardingsphere/issues/3831
 
 
   


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:
us...@infra.apache.org


With regards,
Apache Git Services


[GitHub] [incubator-shardingsphere] coveralls commented on issue #3837: refine wasNull()

2019-12-30 Thread GitBox
coveralls commented on issue #3837: refine wasNull()
URL: 
https://github.com/apache/incubator-shardingsphere/pull/3837#issuecomment-569650307
 
 
   ## Pull Request Test Coverage Report for [Build 
1252](https://coveralls.io/builds/27843362)
   
   * **1** of **1**   **(100.0%)**  changed or added relevant line in **1** 
file are covered.
   * No unchanged relevant lines lost coverage.
   * Overall coverage remained the same at **67.561%**
   
   ---
   
   
   
   |  Totals | [![Coverage 
Status](https://coveralls.io/builds/27843362/badge)](https://coveralls.io/builds/27843362)
 |
   | :-- | --: |
   | Change from base [Build 640](https://coveralls.io/builds/27843355): |  
0.0% |
   | Covered Lines: | 11282 |
   | Relevant Lines: | 16699 |
   
   ---
   # 💛  - [Coveralls](https://coveralls.io)
   


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:
us...@infra.apache.org


With regards,
Apache Git Services


[GitHub] [incubator-shardingsphere] coveralls commented on issue #3836: version is 4.0.0

2019-12-30 Thread GitBox
coveralls commented on issue #3836: version is 4.0.0
URL: 
https://github.com/apache/incubator-shardingsphere/pull/3836#issuecomment-569646978
 
 
   ## Pull Request Test Coverage Report for [Build 
1251](https://coveralls.io/builds/27843231)
   
   * **0** of **0**   changed or added relevant lines in **0** files are 
covered.
   * No unchanged relevant lines lost coverage.
   * Overall coverage remained the same at **67.561%**
   
   ---
   
   
   
   |  Totals | [![Coverage 
Status](https://coveralls.io/builds/27843231/badge)](https://coveralls.io/builds/27843231)
 |
   | :-- | --: |
   | Change from base [Build 639](https://coveralls.io/builds/27843134): |  
0.0% |
   | Covered Lines: | 11282 |
   | Relevant Lines: | 16699 |
   
   ---
   # 💛  - [Coveralls](https://coveralls.io)
   


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:
us...@infra.apache.org


With regards,
Apache Git Services


[GitHub] [incubator-shardingsphere] KomachiSion commented on issue #3831: sharding-jdbc-spring-boot-starter 4.0.0-RC2 integration version problem

2019-12-30 Thread GitBox
KomachiSion commented on issue #3831: sharding-jdbc-spring-boot-starter 
4.0.0-RC2 integration version problem
URL: 
https://github.com/apache/incubator-shardingsphere/issues/3831#issuecomment-569643074
 
 
   @LuciferZK , For my test, I found that the problem do not happen every time. 
So I think it maybe caused by the version conflict between spring dependence.
   
   After I exclude all spring dependence in `mybatis-plus-boot-starter`, 
`mybatis-spring-boot-starter` and `druid-spring-boot-starter`, and then specify 
all spring version 2.2.2.RELEASE, I can work well.
   
   Can you try to unite the version by exclusions and retry?
   
   [example 
code](https://github.com/KomachiSion/shardingsphere-issues/tree/master/issue3831)


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:
us...@infra.apache.org


With regards,
Apache Git Services


[GitHub] [incubator-shardingsphere] terrymanu merged pull request #3837: refine wasNull()

2019-12-30 Thread GitBox
terrymanu merged pull request #3837: refine wasNull()
URL: https://github.com/apache/incubator-shardingsphere/pull/3837
 
 
   


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:
us...@infra.apache.org


With regards,
Apache Git Services


[GitHub] [incubator-shardingsphere] tuohai666 opened a new pull request #3837: refine wasNull()

2019-12-30 Thread GitBox
tuohai666 opened a new pull request #3837: refine wasNull()
URL: https://github.com/apache/incubator-shardingsphere/pull/3837
 
 
   


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:
us...@infra.apache.org


With regards,
Apache Git Services


[GitHub] [incubator-shardingsphere] coveralls commented on issue #3835: Change version

2019-12-30 Thread GitBox
coveralls commented on issue #3835: Change version
URL: 
https://github.com/apache/incubator-shardingsphere/pull/3835#issuecomment-569639561
 
 
   ## Pull Request Test Coverage Report for [Build 
1250](https://coveralls.io/builds/27842791)
   
   * **0** of **0**   changed or added relevant lines in **0** files are 
covered.
   * No unchanged relevant lines lost coverage.
   * Overall coverage remained the same at **67.553%**
   
   ---
   
   
   
   |  Totals | [![Coverage 
Status](https://coveralls.io/builds/27842791/badge)](https://coveralls.io/builds/27842791)
 |
   | :-- | --: |
   | Change from base [Build 638](https://coveralls.io/builds/27840100): |  
0.0% |
   | Covered Lines: | 11280 |
   | Relevant Lines: | 16698 |
   
   ---
   # 💛  - [Coveralls](https://coveralls.io)
   


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:
us...@infra.apache.org


With regards,
Apache Git Services


[GitHub] [incubator-shardingsphere] terrymanu merged pull request #3836: version is 4.0.0

2019-12-30 Thread GitBox
terrymanu merged pull request #3836: version is 4.0.0
URL: https://github.com/apache/incubator-shardingsphere/pull/3836
 
 
   


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:
us...@infra.apache.org


With regards,
Apache Git Services


[GitHub] [incubator-shardingsphere] tristaZero closed pull request #3835: Change version

2019-12-30 Thread GitBox
tristaZero closed pull request #3835: Change version
URL: https://github.com/apache/incubator-shardingsphere/pull/3835
 
 
   


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:
us...@infra.apache.org


With regards,
Apache Git Services


[GitHub] [incubator-shardingsphere] tristaZero opened a new pull request #3836: version is 4.0.0

2019-12-30 Thread GitBox
tristaZero opened a new pull request #3836: version is 4.0.0
URL: https://github.com/apache/incubator-shardingsphere/pull/3836
 
 
   
   


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:
us...@infra.apache.org


With regards,
Apache Git Services


[GitHub] [incubator-shardingsphere] coveralls commented on issue #3834: wasNull() should to be called after get()

2019-12-30 Thread GitBox
coveralls commented on issue #3834: wasNull() should to be called after get()
URL: 
https://github.com/apache/incubator-shardingsphere/pull/3834#issuecomment-569635377
 
 
   ## Pull Request Test Coverage Report for [Build 
1249](https://coveralls.io/builds/27842556)
   
   * **2** of **2**   **(100.0%)**  changed or added relevant lines in **1** 
file are covered.
   * No unchanged relevant lines lost coverage.
   * Overall coverage increased (+**0.008%**) to **67.561%**
   
   ---
   
   
   
   |  Totals | [![Coverage 
Status](https://coveralls.io/builds/27842556/badge)](https://coveralls.io/builds/27842556)
 |
   | :-- | --: |
   | Change from base [Build 638](https://coveralls.io/builds/27840100): |  
0.008% |
   | Covered Lines: | 11282 |
   | Relevant Lines: | 16699 |
   
   ---
   # 💛  - [Coveralls](https://coveralls.io)
   


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:
us...@infra.apache.org


With regards,
Apache Git Services


[GitHub] [incubator-shardingsphere] tristaZero merged pull request #3834: wasNull() should to be called after get()

2019-12-30 Thread GitBox
tristaZero merged pull request #3834: wasNull() should to be called after get()
URL: https://github.com/apache/incubator-shardingsphere/pull/3834
 
 
   


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:
us...@infra.apache.org


With regards,
Apache Git Services


[GitHub] [incubator-shardingsphere] tristaZero opened a new pull request #3835: Change version

2019-12-30 Thread GitBox
tristaZero opened a new pull request #3835: Change version
URL: https://github.com/apache/incubator-shardingsphere/pull/3835
 
 
   


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:
us...@infra.apache.org


With regards,
Apache Git Services


[GitHub] [incubator-shardingsphere] tuohai666 opened a new pull request #3834: wasNull() should to be called after get()

2019-12-30 Thread GitBox
tuohai666 opened a new pull request #3834: wasNull() should to be called after 
get()
URL: https://github.com/apache/incubator-shardingsphere/pull/3834
 
 
   
   


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:
us...@infra.apache.org


With regards,
Apache Git Services


[GitHub] [incubator-shardingsphere] terrymanu closed issue #3822: SQLParseEngine parse mysql update sql fail

2019-12-30 Thread GitBox
terrymanu closed issue #3822: SQLParseEngine parse mysql update sql fail
URL: https://github.com/apache/incubator-shardingsphere/issues/3822
 
 
   


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:
us...@infra.apache.org


With regards,
Apache Git Services


[GitHub] [incubator-shardingsphere] LuciferZK commented on issue #3831: sharding-jdbc-spring-boot-starter 4.0.0-RC2 integration version problem

2019-12-30 Thread GitBox
LuciferZK commented on issue #3831: sharding-jdbc-spring-boot-starter 4.0.0-RC2 
integration version problem
URL: 
https://github.com/apache/incubator-shardingsphere/issues/3831#issuecomment-569616498
 
 
   Simple example, no code, only jar package and configuration;
   
   1.Create database order_db;
   
   CREATE DATABASE `order_db` CHARACTER SET 'utf8' COLLATE 
'utf8_general_ci';
   2.Create t_order_1, t_order_2 tables in order_db;
   
   DROP TABLE IF EXISTS `t_order_1`;
   CREATE TABLE `t_order_1` (
   `order_id` bigint(20) NOT NULL COMMENT '订单id',
   `price` decimal(10, 2) NOT NULL COMMENT '订单价格',
   `user_id` bigint(20) NOT NULL COMMENT '下单用户id',
   `status` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL 
COMMENT '订单状态',
   PRIMARY KEY (`order_id`) USING BTREE
   ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci 
ROW_FORMAT = Dynamic;
   DROP TABLE IF EXISTS `t_order_2`;
   CREATE TABLE `t_order_2` (
   `order_id` bigint(20) NOT NULL COMMENT '订单id',
   `price` decimal(10, 2) NOT NULL COMMENT '订单价格',
   `user_id` bigint(20) NOT NULL COMMENT '下单用户id',
   `status` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL 
COMMENT '订单状态',
   PRIMARY KEY (`order_id`) USING BTREE
   ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci 
ROW_FORMAT = Dynamic;
   
   3.application.yml:
   ```json
   #服务端口
   server:
 port: 56081
   #服务名
   spring:
 application:
   name: sharding-jdbc-examples
 http:
   encoding:
 enabled: true
 charset: utf-8
 force: true
 main:
  allow-bean-definition-overriding: true
 #shardingsphere相关配置
 shardingsphere:
   datasource:
 names: m1   #配置库的名字,随意
 m1:   #配置目前m1库的数据源信息
   type: com.alibaba.druid.pool.DruidDataSource
   driverClassName: com.mysql.jdbc.Driver
   url: jdbc:mysql://192.168.87.133:3306/order_db?useUnicode=true
   username: root
   password: 123456
   sharding:
 tables:
   t_order:  # 指定t_order表的数据分布情况,配置数据节点
 actualDataNodes: m1.t_order_$->{1..2}
 tableStrategy:
   inline:   # 指定t_order表的分片策略,分片策略包括分片键和分片算法
 shardingColumn: order_id
 algorithmExpression: t_order_$->{order_id % 2 + 1}
 keyGenerator:   # 指定t_order表的主键生成策略为SNOWFLAKE
   type: SNOWFLAKE  #主键生成策略为SNOWFLAKE
   column: order_id  #指定主键
   props:
 sql:
   show: true
   ```
   4.pom.xml
   ```xml
   
   http://maven.apache.org/POM/4.0.0"; 
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance";
xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 
https://maven.apache.org/xsd/maven-4.0.0.xsd";>
   4.0.0
   
   org.springframework.boot
   spring-boot-starter-parent
   2.2.2.RELEASE

   
   com.Lucifer
   sharding-jdbc-examples
   0.0.1-SNAPSHOT
   sharding-jdbc-examples
   Demo project for Spring Boot
   
   
   UTF-8
   
UTF-8
   1.8
   
   
   
   
   org.springframework.boot
   spring-boot-starter
   
   
   
   org.springframework.boot
   spring-boot-starter-test
   
   
   
   org.mybatis.spring.boot
   mybatis-spring-boot-starter
   2.1.1
   
   
   com.alibaba
   druid-spring-boot-starter
   1.1.20
   
   
   mysql
   mysql-connector-java
   5.1.47
   
   
   org.apache.shardingsphere
   sharding-jdbc-spring-boot-starter
   4.0.0-RC3
   
   
   com.baomidou
   mybatis-plus-boot-starter
   3.2.0
   
   
   
   
   
   
   org.springframework.boot
   spring-boot-maven-plugin
   
   
   
   
   
   
   ```
When sharding-jdbc-spring-boot-starter version is 4.0.0-RC2 or 4.0.0-RC3, 
even remove spring.main.allow-bean-definition-overriding: true, it still 
reports an error
   
   
![image](https://user-images.githubusercontent.com/38940745/71574167-8b0d2b80-2b22-11ea-8918-a3518670d5df.png)
   
   When sharding-jdbc-spring-boot-starter version is 4.0.0-RC1 and 
spring.main.allow-bean-definition-overriding: true is not deleted, no error is 
reported
   
   
   
   
   


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:
us...@infra.apache.org


With regards,
Apache

[GitHub] [incubator-shardingsphere] terrymanu commented on issue #3833: 两张表通过相同字段进行分表后,进行连表查询,结果有误

2019-12-30 Thread GitBox
terrymanu commented on issue #3833: 两张表通过相同字段进行分表后,进行连表查询,结果有误
URL: 
https://github.com/apache/incubator-shardingsphere/issues/3833#issuecomment-569613132
 
 
   For English only


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:
us...@infra.apache.org


With regards,
Apache Git Services


[GitHub] [incubator-shardingsphere] simayi closed issue #3833: 两张表通过相同字段进行分表后,进行连表查询,结果有误

2019-12-30 Thread GitBox
simayi closed issue #3833: 两张表通过相同字段进行分表后,进行连表查询,结果有误
URL: https://github.com/apache/incubator-shardingsphere/issues/3833
 
 
   


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:
us...@infra.apache.org


With regards,
Apache Git Services


[GitHub] [incubator-shardingsphere] simayi commented on issue #3833: 两张表通过相同字段进行分表后,进行连表查询,结果有误

2019-12-30 Thread GitBox
simayi commented on issue #3833: 两张表通过相同字段进行分表后,进行连表查询,结果有误
URL: 
https://github.com/apache/incubator-shardingsphere/issues/3833#issuecomment-569610253
 
 
   111


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:
us...@infra.apache.org


With regards,
Apache Git Services


[GitHub] [incubator-shardingsphere] simayi opened a new issue #3833: 两张表通过相同字段进行分表后,进行连表查询,结果有误

2019-12-30 Thread GitBox
simayi opened a new issue #3833: 两张表通过相同字段进行分表后,进行连表查询,结果有误
URL: https://github.com/apache/incubator-shardingsphere/issues/3833
 
 
   table1和table2都是通过TENANT_ID进行分表,table1和table2各分了8张表;
   使用Springboot+Mybatis;
   Mapper文件中的SQL为:
   select
distinct t.ITEM_ID T_ITEM_ID, t.*
from table1 t inner join table2 r on t.TENANT_ID = r.TENANT_ID 
and t.ORG_ID = r.ORG_ID
where r.TENANT_ID = 8
and t.TENANT_ID = 8
and r.ORG_ID = 12
and t.ITEM_STATUS = 1
   and t.CATEGORY_ID = 1
   启动后调用该SQL,打印的SQL日志中:
   查询结果总数的SQL返回4条,正确,查询结果却返回0条;
   
   


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:
us...@infra.apache.org


With regards,
Apache Git Services


[GitHub] [incubator-shardingsphere] simayi closed issue #3833: 两张表通过相同字段进行分表后,进行连表查询,结果有误

2019-12-30 Thread GitBox
simayi closed issue #3833: 两张表通过相同字段进行分表后,进行连表查询,结果有误
URL: https://github.com/apache/incubator-shardingsphere/issues/3833
 
 
   


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:
us...@infra.apache.org


With regards,
Apache Git Services


[GitHub] [incubator-shardingsphere] KomachiSion commented on issue #3831: sharding-jdbc-spring-boot-starter 4.0.0-RC2 integration version problem

2019-12-30 Thread GitBox
KomachiSion commented on issue #3831: sharding-jdbc-spring-boot-starter 
4.0.0-RC2 integration version problem
URL: 
https://github.com/apache/incubator-shardingsphere/issues/3831#issuecomment-569609693
 
 
   @LuciferZK , I have some advise for you, you can have a try to solve the 
problem.
   
   1. use `druid` replace `druid-spring-boot-starter`, and remove 
`main:allow-bean-definition-overriding: true` then retry.
   2. upgrade shardingsphere to 4.0.0-RC3 and retry.
   
   If the problem still happened, Please provide more detail log. Providing a 
example code to GitHub will be better.


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:
us...@infra.apache.org


With regards,
Apache Git Services


[GitHub] [incubator-shardingsphere] LuciferZK commented on issue #3831: sharding-jdbc-spring-boot-starter 4.0.0-RC2 integration version problem

2019-12-30 Thread GitBox
LuciferZK commented on issue #3831: sharding-jdbc-spring-boot-starter 4.0.0-RC2 
integration version problem
URL: 
https://github.com/apache/incubator-shardingsphere/issues/3831#issuecomment-569609523
 
 
   > Sorry, I can't get your problem.
   > Do you mean that you configure the `url` of JDBC, but `shardingsphere` 
can't find the configuration?
   
   Yes, but when I downgraded the sharding-jdbc-spring-boot-starter from 
4.0.0-RC2 to 4.0.0-RC1, no error is reported.


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:
us...@infra.apache.org


With regards,
Apache Git Services