[GitHub] [incubator-shardingsphere-doc] dongzl opened a new pull request #413: add new committer, Github ID: dongzl .
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
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
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
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
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
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
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)
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
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:前缀
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:前缀
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
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
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
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
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
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的公司在此登记)
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
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:前缀
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: 广播表、绑定表配置无效
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
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?
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)
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
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()
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
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
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()
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()
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
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
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
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
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()
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()
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
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()
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
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
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: 两张表通过相同字段进行分表后,进行连表查询,结果有误
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: 两张表通过相同字段进行分表后,进行连表查询,结果有误
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: 两张表通过相同字段进行分表后,进行连表查询,结果有误
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: 两张表通过相同字段进行分表后,进行连表查询,结果有误
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: 两张表通过相同字段进行分表后,进行连表查询,结果有误
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
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
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