You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by GitBox <gi...@apache.org> on 2020/10/28 05:11:29 UTC
[GitHub] [shardingsphere] duzhanfei opened a new issue #7940: 【sharding-proxy】Actual SQL execution results are incorrect (data should have been returned, but no data was returned),
duzhanfei opened a new issue #7940:
URL: https://github.com/apache/shardingsphere/issues/7940
I has tried all shardingproxy versions，the result is same：
The ShardingProxy log shows that the Actual SQL for the query is ok, but the SQL execution results are incorrect (data should have been returned, but no data was returned)
When directly using the interface to query the database, you can find the data. With the addition of shardingProxy proxy, the query interface does not return the data.
The logging and configuration are shown below：
一、configuration
schemaName: sharding_db
dataSources:
ds_0:
url: jdbc:mysql://19.111.4.11:3306/db1?serverTimezone=UTC&useSSL=false
username: sera
password: szua
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
maxPoolSize: 50
ds_1:
url: jdbc:mysql://19.111.4.11:3306/db2?serverTimezone=UTC&useSSL=false
username: sera
password: szua
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
maxPoolSize: 50
ds_2:
url: jdbc:mysql://19.111.4.11:3306/db3?serverTimezone=UTC&useSSL=false
username: sera
password: szua
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
maxPoolSize: 50
shardingRule:
tables:
pscst_prdt_cvr:
actualDataNodes: ds_${0..1}.pscst_prdt_cvr${0..1}
databaseStrategy:
inline:
shardingColumn: ecif_cust_no
algorithmExpression: ds_${ecif_cust_no % 2}
tableStrategy:
inline:
shardingColumn: ecif_cust_no
algorithmExpression: pscst_prdt_cvr${ecif_cust_no % 2}
keyGenerator:
type: SNOWFLAKE
column: ecif_cust_no
bcpur_epcst_aslb_stats:
actualDataNodes: ds_2.bcpur_epcst_aslb_stats
databaseStrategy:
inline:
shardingColumn: ecif_cust_no
algorithmExpression: ds_2
tableStrategy:
inline:
shardingColumn: ecif_cust_no
algorithmExpression: bcpur_epcst_aslb_stats
keyGenerator:
type: SNOWFLAKE
column: ecif_cust_no
bindingTables:
- pscst_prdt_cvr,bcpur_epcst_aslb_stats
defaultDataSourceName: ds_2
defaultTableStrategy:
none:
二、logs（Logic SQL and Actual SQL logs）
log（Logic SQL and Actual SQL logs）
[INFO ] 11:05:16.105 [ShardingSphere-Command-2] ShardingSphere-SQL - Logic SQL:
SELECT BIZ_DT, ECIF_CUST_NO, DEP_FLG, DBTCD_FLG, PLM_PY_FLG, PY_GTWY_FLG,
SFSRV_EQP_SGNG_FLG, ATMBL_MRTG_FLG, HS_MRTG_FLG, HLPFM_ETMN_FLG, PSNL_MANG_LN_FLG,
PSNL_CNSM_LN_FLG, ETC_FLG, CSCRD_FLG, MBLBNK_FLG, EBP_SGNG_FLG FROM pscst_prdt_cvr
WHERE ECIF_CUST_NO = ?
[INFO ] 11:05:16.109 [ShardingSphere-Command-2] ShardingSphere-SQL - SQLStatement:
SelectStatementContext(super=CommonSQLStatementContext(sqlStatement=org.apache.shardingsphere
.sql.parser.sql.statement.dml.SelectStatement@6d74eaeb,
tablesContext=org.apache.shardingsphere.sql.parser.binder.segment.table.TablesContext@23f8fdb9),
tablesContext=org.apache.shardingsphere.sql.parser.binder.segment.table.TablesContext@23f8fdb9,
projectionsContext=ProjectionsContext(startIndex=7, stopIndex=218, distinctRow=false,
projections=[ColumnProjection(owner=null, name=BIZ_DT, alias=Optional.empty),
ColumnProjection(owner=null, name=ECIF_CUST_NO, alias=Optional.empty),
ColumnProjection(owner=null, name=DEP_FLG, alias=Optional.empty),
ColumnProjection(owner=null, name=DBTCD_FLG, alias=Optional.empty),
ColumnProjection(owner=null, name=PLM_PY_FLG, alias=Optional.empty),
ColumnProjection(owner=null, name=PY_GTWY_FLG, alias=Optional.empty),
ColumnProjection(owner=null, name=SFSRV_EQP_SGNG_FLG, alias=Optional.empty),
ColumnProjection(owner=null, name=ATMBL_MRTG_FLG, alias=Optional.empty),
ColumnProjection(owner=null, name=HS_MRTG_FLG, alias=Optional.empty),
ColumnProjection(owner=null, name=HLPFM_ETMN_FLG, alias=Optional.empty),
ColumnProjection(owner=null, name=PSNL_MANG_LN_FLG, alias=Optional.empty),
ColumnProjection(owner=null, name=PSNL_CNSM_LN_FLG, alias=Optional.empty),
ColumnProjection(owner=null, name=ETC_FLG, alias=Optional.empty),
ColumnProjection(owner=null, name=CSCRD_FLG, alias=Optional.empty),
ColumnProjection(owner=null, name=MBLBNK_FLG, alias=Optional.empty),
ColumnProjection(owner=null, name=EBP_SGNG_FLG, alias=Optional.empty)]),
groupByContext=org.apache.shardingsphere.sql.parser.binder.segment.select.groupby.GroupByContext@6386efb2,
orderByContext=org.apache.shardingsphere.sql.parser.binder.segment.select.orderby.OrderByContext@23183b2c,
paginationContext=org.apache.shardingsphere.sql.parser.binder.segment.select.pagination.PaginationContext@64ef8bcc,
containsSubquery=false)
[INFO ] 11:05:16.113 [ShardingSphere-Command-2] ShardingSphere-SQL -
Actual SQL: ds_0 ::: SELECT BIZ_DT, ECIF_CUST_NO, DEP_FLG, DBTCD_FLG, PLM_PY_FLG,
PY_GTWY_FLG, SFSRV_EQP_SGNG_FLG, ATMBL_MRTG_FLG, HS_MRTG_FLG, HLPFM_ETMN_FLG,
PSNL_MANG_LN_FLG, PSNL_CNSM_LN_FLG, ETC_FLG, CSCRD_FLG, MBLBNK_FLG,
EBP_SGNG_FLG FROM pscst_prdt_cvr0 WHERE ECIF_CUST_NO = ? ::: [10000]
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] duzhanfei commented on issue #7940: 【sharding-proxy】Actual SQL execution results are incorrect (data should have been returned, but no data was returned),
Posted by GitBox <gi...@apache.org>.
duzhanfei commented on issue #7940:
URL: https://github.com/apache/shardingsphere/issues/7940#issuecomment-718428662
@kimmking @Lucas-307
controller and service method are only simply method calls
<img width="775" alt="图片19" src="https://user-images.githubusercontent.com/46663706/97539237-96f4a300-19fc-11eb-9bcf-7cbc60ab0fc1.png">
<img width="570" alt="图片20" src="https://user-images.githubusercontent.com/46663706/97539260-9e1bb100-19fc-11eb-91f7-a41b35718ed8.png">
<img width="867" alt="图片21" src="https://user-images.githubusercontent.com/46663706/97539267-a378fb80-19fc-11eb-973f-2b38ac3aba67.png">
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] duzhanfei commented on issue #7940: 【sharding-proxy】Actual SQL execution results are incorrect (data should have been returned, but no data was returned),
Posted by GitBox <gi...@apache.org>.
duzhanfei commented on issue #7940:
URL: https://github.com/apache/shardingsphere/issues/7940#issuecomment-717806442
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] duzhanfei commented on issue #7940: 【sharding-proxy】Actual SQL execution results are incorrect (data should have been returned, but no data was returned),
Posted by GitBox <gi...@apache.org>.
duzhanfei commented on issue #7940:
URL: https://github.com/apache/shardingsphere/issues/7940#issuecomment-722125634
If you use this URL, the problem will recur
url: jdbc:mysql://127.0.0.1:3307/sharding_db?useServerPrepStmts=true&cachePrepStmts=true
and tis url is ok
url: jdbc:mysql://127.0.0.1:3307/sharding_db?serverTimezone=UTC&useSSL=false
At 2020-11-05 11:10:33, "邱鹿 Lucas" <no...@github.com> wrote:
@Lucas-307 hi, can you reproduce this scene through the demo I provided ?
let me try.
—
You are receiving this because you were mentioned.
Reply to this email directly, view it on GitHub, or unsubscribe.
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] duzhanfei commented on issue #7940: 【sharding-proxy】Actual SQL execution results are incorrect (data should have been returned, but no data was returned),
Posted by GitBox <gi...@apache.org>.
duzhanfei commented on issue #7940:
URL: https://github.com/apache/shardingsphere/issues/7940#issuecomment-717754391
here are same datas ECIF_CUST_NO = 10000 in ds_0.pscst_prdt_cvr0, but we can't find it. @Lucas-307
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] duzhanfei commented on issue #7940: 【sharding-proxy】Actual SQL execution results are incorrect (data should have been returned, but no data was returned),
Posted by GitBox <gi...@apache.org>.
duzhanfei commented on issue #7940:
URL: https://github.com/apache/shardingsphere/issues/7940#issuecomment-717757425
Thanks for the tip, shardingRule is really unreasonable. @Lucas-307
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] tuohai666 commented on issue #7940: 【sharding-proxy】Actual SQL execution results are incorrect (data should have been returned, but no data was returned),
Posted by GitBox <gi...@apache.org>.
tuohai666 commented on issue #7940:
URL: https://github.com/apache/shardingsphere/issues/7940#issuecomment-729563277
@lxlcoop I can't reproduce using the repo above. All of the two url failed due to the wrong config: the sharding key ecif_cust_no can not be a varchar.
Version: 4.1.1
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] Lucas-307 commented on issue #7940: 【sharding-proxy】Actual SQL execution results are incorrect (data should have been returned, but no data was returned),
Posted by GitBox <gi...@apache.org>.
Lucas-307 commented on issue #7940:
URL: https://github.com/apache/shardingsphere/issues/7940#issuecomment-718321895
> @Lucas-307
> The expected results can be returned when the client is used alone
>
> (When using the NavCAT or cmd control console, the correct results are expected)
>
> <img alt="图片9" width="723" src="https://user-images.githubusercontent.com/46663706/97430479-e763f600-1953-11eb-9f96-469e8651e14b.png">
>
> <img alt="图片8" width="732" src="https://user-images.githubusercontent.com/46663706/97430538-fcd92000-1953-11eb-9f0c-9379ca42a2b5.png">
>
> but the execution results are not correct until they are integrated into the local project
So, the problem is in your project. You can test `Actual Sql` in MyBatis select sql.
Just try.
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] duzhanfei closed issue #7940: 【sharding-proxy】Actual SQL execution results are incorrect (data should have been returned, but no data was returned),
Posted by GitBox <gi...@apache.org>.
duzhanfei closed issue #7940:
URL: https://github.com/apache/shardingsphere/issues/7940
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] Lucas-307 commented on issue #7940: 【sharding-proxy】Actual SQL execution results are incorrect (data should have been returned, but no data was returned),
Posted by GitBox <gi...@apache.org>.
Lucas-307 commented on issue #7940:
URL: https://github.com/apache/shardingsphere/issues/7940#issuecomment-717745707
@duzhanfei Hi ,you can execute under sql in `ds_0.pscst_prdt_cvr0` directly. I guess you can't find anything.
```sql
SELECT BIZ_DT, ECIF_CUST_NO, DEP_FLG, DBTCD_FLG, PLM_PY_FLG,
PY_GTWY_FLG, SFSRV_EQP_SGNG_FLG, ATMBL_MRTG_FLG, HS_MRTG_FLG, HLPFM_ETMN_FLG,
PSNL_MANG_LN_FLG, PSNL_CNSM_LN_FLG, ETC_FLG, CSCRD_FLG, MBLBNK_FLG,
EBP_SGNG_FLG FROM pscst_prdt_cvr0 WHERE ECIF_CUST_NO = 10000
```
Please make sure your data is match your `shardingRule`.
If there are same datas `ECIF_CUST_NO = 10000` but not in `ds_0.pscst_prdt_cvr0`, we can't find it. (we called it dirty data.) Because if a sql include shardingKey, we will calcuate and execute in matched table directly and ignore other sharding tables.
By the way, your `shardingRule` is unreasonable. Only `ds0.pscst_prdt_cvr0` and `ds1.pscst_prdt_cvr1` include datas by the same database and table strategy.
```yaml
databaseStrategy:
inline:
shardingColumn: ecif_cust_no
algorithmExpression: ds_${ecif_cust_no % 2}
tableStrategy:
inline:
shardingColumn: ecif_cust_no
algorithmExpression: pscst_prdt_cvr${ecif_cust_no % 2}
```
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] qiqsa commented on issue #7940: 【sharding-proxy】Actual SQL execution results are incorrect (data should have been returned, but no data was returned),
Posted by GitBox <gi...@apache.org>.
qiqsa commented on issue #7940:
URL: https://github.com/apache/shardingsphere/issues/7940#issuecomment-718432016
@duzhanfei the problem has‘t be deal？
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] duzhanfei commented on issue #7940: 【sharding-proxy】Actual SQL execution results are incorrect (data should have been returned, but no data was returned),
Posted by GitBox <gi...@apache.org>.
duzhanfei commented on issue #7940:
URL: https://github.com/apache/shardingsphere/issues/7940#issuecomment-718444956
>
>
> @duzhanfei version number ？ I try do it
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] duzhanfei commented on issue #7940: 【sharding-proxy】Actual SQL execution results are incorrect (data should have been returned, but no data was returned),
Posted by GitBox <gi...@apache.org>.
duzhanfei commented on issue #7940:
URL: https://github.com/apache/shardingsphere/issues/7940#issuecomment-729663998
I had get the same result when the ecif_cust_no is not varchar before bringing up this issue.
At 2020-11-18 17:56:49, "Zhang Yonglun" <no...@github.com> wrote:
@lxlcoop I doubt this issue itself is the problem.
Please provide directly information like sql/response via log/tcpdump/wireshark in another issue, without any spring/mybatis/.
@lxlcoop I can't reproduce using the repo above. All of the two url failed due to the wrong config: the sharding key ecif_cust_no can not be a varchar.
Version: 4.1.1
—
You are receiving this because you were mentioned.
Reply to this email directly, view it on GitHub, or unsubscribe.
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] duzhanfei removed a comment on issue #7940: 【sharding-proxy】Actual SQL execution results are incorrect (data should have been returned, but no data was returned),
Posted by GitBox <gi...@apache.org>.
duzhanfei removed a comment on issue #7940:
URL: https://github.com/apache/shardingsphere/issues/7940#issuecomment-717806545
@Lucas-307
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] yu199195 closed issue #7940: 【sharding-proxy】Actual SQL execution results are incorrect (data should have been returned, but no data was returned),
Posted by GitBox <gi...@apache.org>.
yu199195 closed issue #7940:
URL: https://github.com/apache/shardingsphere/issues/7940
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] Lucas-307 commented on issue #7940: 【sharding-proxy】Actual SQL execution results are incorrect (data should have been returned, but no data was returned),
Posted by GitBox <gi...@apache.org>.
Lucas-307 commented on issue #7940:
URL: https://github.com/apache/shardingsphere/issues/7940#issuecomment-722165465
> If you use this URL, the problem will recur
url: jdbc:mysql://127.0.0.1:3307/sharding_db?useServerPrepStmts=true&cachePrepStmts=true
>
> and tis url is ok
url: jdbc:mysql://127.0.0.1:3307/sharding_db?serverTimezone=UTC&useSSL=false
@duzhanfei I reproduced it, I think it's a bug.
@tuohai666 Please have a look.
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] Lucas-307 commented on issue #7940: 【sharding-proxy】Actual SQL execution results are incorrect (data should have been returned, but no data was returned),
Posted by GitBox <gi...@apache.org>.
Lucas-307 commented on issue #7940:
URL: https://github.com/apache/shardingsphere/issues/7940#issuecomment-717791567
@duzhanfei It's blank?
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] Lucas-307 edited a comment on issue #7940: 【sharding-proxy】Actual SQL execution results are incorrect (data should have been returned, but no data was returned),
Posted by GitBox <gi...@apache.org>.
Lucas-307 edited a comment on issue #7940:
URL: https://github.com/apache/shardingsphere/issues/7940#issuecomment-717839398
> @Lucas-307 I have completed the picture
@duzhanfei Get it.
If you change your MyBatis select sql to `Actual Sql` and change url to `jdbc:mysql://19.111.4.11:3306/db1?serverTimezone=UTC&useSSL=false` what will happen?
Or you can try to execute `Logic SQL` in mysql cilent.
Make it simple to locate problem.
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] Lucas-307 commented on issue #7940: 【sharding-proxy】Actual SQL execution results are incorrect (data should have been returned, but no data was returned),
Posted by GitBox <gi...@apache.org>.
Lucas-307 commented on issue #7940:
URL: https://github.com/apache/shardingsphere/issues/7940#issuecomment-722161321
> If you use this URL, the problem will recur url: jdbc:mysql://127.0.0.1:3307/sharding_db?useServerPrepStmts=true&cachePrepStmts=true and tis url is ok url: jdbc:mysql://127.0.0.1:3307/sharding_db?serverTimezone=UTC&useSSL=false At 2020-11-05 11:10:33, "邱鹿 Lucas" <no...@github.com> wrote: @Lucas-307 hi, can you reproduce this scene through the demo I provided ? let me try. — You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub, or unsubscribe.
This is valuable information.
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] lxlcoop commented on issue #7940: 【sharding-proxy】Actual SQL execution results are incorrect (data should have been returned, but no data was returned),
Posted by GitBox <gi...@apache.org>.
lxlcoop commented on issue #7940:
URL: https://github.com/apache/shardingsphere/issues/7940#issuecomment-728976296
@tuohai666 we change the CP to Hikari，it still didn't work. Please have a look, we look forward to your reply as soon as possible.
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] duzhanfei commented on issue #7940: 【sharding-proxy】Actual SQL execution results are incorrect (data should have been returned, but no data was returned),
Posted by GitBox <gi...@apache.org>.
duzhanfei commented on issue #7940:
URL: https://github.com/apache/shardingsphere/issues/7940#issuecomment-717777425
Actual SQL execution results
logs
At 2020-10-28 16:06:02, "邱鹿 Lucas" <no...@github.com> wrote:
here are same datas ECIF_CUST_NO = 10000 in ds_0.pscst_prdt_cvr0, but we can't find it. @Lucas-307
@duzhanfei Maybe, you can take a picture or give more details for this, I have no idea any more.
—
You are receiving this because you were mentioned.
Reply to this email directly, view it on GitHub, or unsubscribe.
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] duzhanfei commented on issue #7940: 【sharding-proxy】Actual SQL execution results are incorrect (data should have been returned, but no data was returned),
Posted by GitBox <gi...@apache.org>.
duzhanfei commented on issue #7940:
URL: https://github.com/apache/shardingsphere/issues/7940#issuecomment-719455508
When using ShardingProxy to operate mysql in the project,
there is no problem about add, delete or update
But the query does not return data
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] kimmking commented on issue #7940: 【sharding-proxy】Actual SQL execution results are incorrect (data should have been returned, but no data was returned),
Posted by GitBox <gi...@apache.org>.
kimmking commented on issue #7940:
URL: https://github.com/apache/shardingsphere/issues/7940#issuecomment-728038632
> > If you use this URL, the problem will recur
> > url: jdbc:mysql://127.0.0.1:3307/sharding_db?useServerPrepStmts=true&cachePrepStmts=true
> > and tis url is ok
> > url: jdbc:mysql://127.0.0.1:3307/sharding_db?serverTimezone=UTC&useSSL=false
>
> @duzhanfei I reproduced it, I think it's a bug.
>
> @tuohai666 Please have a look.
As @Lucas-307 reproduce it, we should reopen and track it.
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] kimmking closed issue #7940: 【sharding-proxy】Actual SQL execution results are incorrect (data should have been returned, but no data was returned),
Posted by GitBox <gi...@apache.org>.
kimmking closed issue #7940:
URL: https://github.com/apache/shardingsphere/issues/7940
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] duzhanfei commented on issue #7940: 【sharding-proxy】Actual SQL execution results are incorrect (data should have been returned, but no data was returned),
Posted by GitBox <gi...@apache.org>.
duzhanfei commented on issue #7940:
URL: https://github.com/apache/shardingsphere/issues/7940#issuecomment-718330878
@Lucas-307
I change my MyBatis select sql to Actual Sql and change url to jdbc:mysql://19.111.4.11:3306/db1?serverTimezone=UTC&useSSL=false ,the result is correct, data been returned;
<img width="564" alt="图片10" src="https://user-images.githubusercontent.com/46663706/97520796-00fa5180-19d7-11eb-8042-1f9b1a002dcd.png">
<img width="797" alt="图片11" src="https://user-images.githubusercontent.com/46663706/97520808-08215f80-19d7-11eb-8da0-2b0ea8ce2bf1.png">
<img width="894" alt="图片12" src="https://user-images.githubusercontent.com/46663706/97520817-0d7eaa00-19d7-11eb-9a59-313bd18b0269.png">
By the way,
When I switched the data source from mysql to ShardingProxy, I just changed the datesouce configuration,
Is there anything else 1 need to do, like import the corresponding dependencies
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] duzhanfei commented on issue #7940: 【sharding-proxy】Actual SQL execution results are incorrect (data should have been returned, but no data was returned),
Posted by GitBox <gi...@apache.org>.
duzhanfei commented on issue #7940:
URL: https://github.com/apache/shardingsphere/issues/7940#issuecomment-718436805
yes
At 2020-10-29 15:40:53, "qiqsa" <no...@github.com> wrote:
@duzhanfei the problem has‘t be deal？
—
You are receiving this because you were mentioned.
Reply to this email directly, view it on GitHub, or unsubscribe.
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] tuohai666 commented on issue #7940: 【sharding-proxy】Actual SQL execution results are incorrect (data should have been returned, but no data was returned),
Posted by GitBox <gi...@apache.org>.
tuohai666 commented on issue #7940:
URL: https://github.com/apache/shardingsphere/issues/7940#issuecomment-722200906
I don't think the root cause is relative with the useServerPrepStmts=true&cachePrepStmts=true parameters, because we have did a lot of tests for the prepared statement.
I believe you can get the right result if you change the CP to Hikari. As to why druid didn't work, I think a tcpdump package will help.
@duzhanfei
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] duzhanfei commented on issue #7940: 【sharding-proxy】Actual SQL execution results are incorrect (data should have been returned, but no data was returned),
Posted by GitBox <gi...@apache.org>.
duzhanfei commented on issue #7940:
URL: https://github.com/apache/shardingsphere/issues/7940#issuecomment-718447004
@qiqsa
I has tried all shardingproxy versions，the result is same：
<img width="627" alt="图片22" src="https://user-images.githubusercontent.com/46663706/97540696-f94ea300-19fe-11eb-900f-06c2d86fd245.png">
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] qiqsa commented on issue #7940: 【sharding-proxy】Actual SQL execution results are incorrect (data should have been returned, but no data was returned),
Posted by GitBox <gi...@apache.org>.
qiqsa commented on issue #7940:
URL: https://github.com/apache/shardingsphere/issues/7940#issuecomment-718442066
@duzhanfei version number ？ I try do it
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] tuohai666 closed issue #7940: 【sharding-proxy】Actual SQL execution results are incorrect (data should have been returned, but no data was returned),
Posted by GitBox <gi...@apache.org>.
tuohai666 closed issue #7940:
URL: https://github.com/apache/shardingsphere/issues/7940
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] tuohai666 commented on issue #7940: 【sharding-proxy】Actual SQL execution results are incorrect (data should have been returned, but no data was returned),
Posted by GitBox <gi...@apache.org>.
tuohai666 commented on issue #7940:
URL: https://github.com/apache/shardingsphere/issues/7940#issuecomment-729567819
@lxlcoop I doubt this issue itself is the problem.
Please provide directly information like sql/response via log/tcpdump/wireshark in another issue, without any spring/mybatis/.
> @lxlcoop I can't reproduce using the repo above. All of the two url failed due to the wrong config: the sharding key ecif_cust_no can not be a varchar.
> Version: 4.1.1
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] qiqsa edited a comment on issue #7940: 【sharding-proxy】Actual SQL execution results are incorrect (data should have been returned, but no data was returned),
Posted by GitBox <gi...@apache.org>.
qiqsa edited a comment on issue #7940:
URL: https://github.com/apache/shardingsphere/issues/7940#issuecomment-718432016
@duzhanfei the problem has‘t be deal？ Navicat execue sql as ordinary statement，but Mybatis + sharding-Proxy execute sql as prepareStatement ，you can check if the prepareStatement has problem?
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] duzhanfei commented on issue #7940: 【sharding-proxy】Actual SQL execution results are incorrect (data should have been returned, but no data was returned),
Posted by GitBox <gi...@apache.org>.
duzhanfei commented on issue #7940:
URL: https://github.com/apache/shardingsphere/issues/7940#issuecomment-718331285
@Lucas-307 When the data source is switched to ShardingProxy, the problem remains
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] duzhanfei removed a comment on issue #7940: 【sharding-proxy】Actual SQL execution results are incorrect (data should have been returned, but no data was returned),
Posted by GitBox <gi...@apache.org>.
duzhanfei removed a comment on issue #7940:
URL: https://github.com/apache/shardingsphere/issues/7940#issuecomment-719454875
When using ShardingProxy to operate the database in the project,
there is no problem about add, delete or update
But the query does not return data
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] Lucas-307 commented on issue #7940: 【sharding-proxy】Actual SQL execution results are incorrect (data should have been returned, but no data was returned),
Posted by GitBox <gi...@apache.org>.
Lucas-307 commented on issue #7940:
URL: https://github.com/apache/shardingsphere/issues/7940#issuecomment-718712659
> I just changed the datesouce configuration, doesn't import the any dependencies . is this ok ? At 2020-10-29 18:43:48, "邱鹿 Lucas" <no...@github.com> wrote: @Lucas-307@kimmking@qiqsa When I switched the data source from mysql to ShardingProxy, I just changed the datesouce configuration, Is there anything else 1 need to do ？ like import the corresponding dependencies I think this two is enough, you don't have to do anything else. — You are receiving this because you modified the open/close state. Reply to this email directly, view it on GitHub, or unsubscribe.
yes
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] Lucas-307 commented on issue #7940: 【sharding-proxy】Actual SQL execution results are incorrect (data should have been returned, but no data was returned),
Posted by GitBox <gi...@apache.org>.
Lucas-307 commented on issue #7940:
URL: https://github.com/apache/shardingsphere/issues/7940#issuecomment-717768235
> here are same datas ECIF_CUST_NO = 10000 in ds_0.pscst_prdt_cvr0, but we can't find it. @Lucas-307
@duzhanfei Maybe, you can take a picture or give more details for this, I have no idea any more.
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] Lucas-307 commented on issue #7940: 【sharding-proxy】Actual SQL execution results are incorrect (data should have been returned, but no data was returned),
Posted by GitBox <gi...@apache.org>.
Lucas-307 commented on issue #7940:
URL: https://github.com/apache/shardingsphere/issues/7940#issuecomment-717839398
> @Lucas-307 I have completed the picture
@duzhanfei Get it.
If you change your MyBatis select sql to `Actual Sql` and change url to `jdbc:mysql://19.111.4.11:3306/db1?serverTimezone=UTC&useSSL=false` what will happen?
Or you can try to execute `Logic SQL` in mysql cilent.
Make it simple to location problem.
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] kimmking commented on issue #7940: 【sharding-proxy】Actual SQL execution results are incorrect (data should have been returned, but no data was returned),
Posted by GitBox <gi...@apache.org>.
kimmking commented on issue #7940:
URL: https://github.com/apache/shardingsphere/issues/7940#issuecomment-718364246
> @Lucas-307
> I change my MyBatis select sql to Actual Sql and change url to jdbc:mysql://19.111.4.11:3306/db1?serverTimezone=UTC&useSSL=false ,the result is correct, data been returned;
>
> <img alt="图片10" width="564" src="https://user-images.githubusercontent.com/46663706/97520796-00fa5180-19d7-11eb-8042-1f9b1a002dcd.png">
>
> <img alt="图片11" width="797" src="https://user-images.githubusercontent.com/46663706/97520808-08215f80-19d7-11eb-8da0-2b0ea8ce2bf1.png">
>
> <img alt="图片12" width="894" src="https://user-images.githubusercontent.com/46663706/97520817-0d7eaa00-19d7-11eb-9a59-313bd18b0269.png">
>
> By the way,
> When I switched the data source from mysql to ShardingProxy, I just changed the datesouce configuration,
> Is there anything else 1 need to do, like import the corresponding dependencies
It shows proxy works well.
So the reason maybe something wrong in your web controller or service method.
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] duzhanfei commented on issue #7940: 【sharding-proxy】Actual SQL execution results are incorrect (data should have been returned, but no data was returned),
Posted by GitBox <gi...@apache.org>.
duzhanfei commented on issue #7940:
URL: https://github.com/apache/shardingsphere/issues/7940#issuecomment-717768269
hi, there are same datas ECIF_CUST_NO = 10000 in ds_0.pscst_prdt_cvr0, but we can't find it
At 2020-10-28 15:09:00, "邱鹿 Lucas" <no...@github.com> wrote:
@duzhanfei Hi ,you can execute under sql in ds_0.pscst_prdt_cvr0 directly. I guess you can't find anything.
SELECT BIZ_DT, ECIF_CUST_NO, DEP_FLG, DBTCD_FLG, PLM_PY_FLG,
PY_GTWY_FLG, SFSRV_EQP_SGNG_FLG, ATMBL_MRTG_FLG, HS_MRTG_FLG, HLPFM_ETMN_FLG,
PSNL_MANG_LN_FLG, PSNL_CNSM_LN_FLG, ETC_FLG, CSCRD_FLG, MBLBNK_FLG,
EBP_SGNG_FLG FROM pscst_prdt_cvr0 WHERE ECIF_CUST_NO =10000
Please make sure your data is match your shardingRule.
If there are same datas ECIF_CUST_NO = 10000 but not in ds_0.pscst_prdt_cvr0, we can't find it. (we called it dirty data.) Because if a sql include shardingKey, we will calcuate and execute in matched table directly and ignore other sharding tables.
By the way, your shardingRule is unreasonable. Only ds0.pscst_prdt_cvr0 and ds1.pscst_prdt_cvr1 include datas by the same database and table strategy.
databaseStrategy:
inline:
shardingColumn: ecif_cust_noalgorithmExpression: ds_${ecif_cust_no % 2}tableStrategy:
inline:
shardingColumn: ecif_cust_noalgorithmExpression: pscst_prdt_cvr${ecif_cust_no % 2}
—
You are receiving this because you were mentioned.
Reply to this email directly, view it on GitHub, or unsubscribe.
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] duzhanfei commented on issue #7940: 【sharding-proxy】Actual SQL execution results are incorrect (data should have been returned, but no data was returned),
Posted by GitBox <gi...@apache.org>.
duzhanfei commented on issue #7940:
URL: https://github.com/apache/shardingsphere/issues/7940#issuecomment-717808356
@Lucas-307 I have completed the picture
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] Lucas-307 commented on issue #7940: 【sharding-proxy】Actual SQL execution results are incorrect (data should have been returned, but no data was returned),
Posted by GitBox <gi...@apache.org>.
Lucas-307 commented on issue #7940:
URL: https://github.com/apache/shardingsphere/issues/7940#issuecomment-718632478
> @Lucas-307 @kimmking @qiqsa
> When I switched the data source from mysql to ShardingProxy, I just changed the datesouce configuration,
> Is there anything else 1 need to do ？ like import the corresponding dependencies
I think this two is enough, you don't have to do anything else.
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] kimmking commented on issue #7940: 【sharding-proxy】Actual SQL execution results are incorrect (data should have been returned, but no data was returned),
Posted by GitBox <gi...@apache.org>.
kimmking commented on issue #7940:
URL: https://github.com/apache/shardingsphere/issues/7940#issuecomment-718402901
> @Lucas-307
> The expected results can be returned when the client is used alone
>
> (When using the NavCAT or cmd control console, the correct results are expected)
>
> <img alt="图片9" width="723" src="https://user-images.githubusercontent.com/46663706/97430479-e763f600-1953-11eb-9f96-469e8651e14b.png">
>
> <img alt="图片8" width="732" src="https://user-images.githubusercontent.com/46663706/97430538-fcd92000-1953-11eb-9f0c-9379ca42a2b5.png">
>
> but the execution results are not correct until they are integrated into the local project
This show proxy work well.
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] duzhanfei commented on issue #7940: 【sharding-proxy】Actual SQL execution results are incorrect (data should have been returned, but no data was returned),
Posted by GitBox <gi...@apache.org>.
duzhanfei commented on issue #7940:
URL: https://github.com/apache/shardingsphere/issues/7940#issuecomment-717781990
server.yaml configruration
At 2020-10-28 16:06:02, "邱鹿 Lucas" <no...@github.com> wrote:
here are same datas ECIF_CUST_NO = 10000 in ds_0.pscst_prdt_cvr0, but we can't find it. @Lucas-307
@duzhanfei Maybe, you can take a picture or give more details for this, I have no idea any more.
—
You are receiving this because you were mentioned.
Reply to this email directly, view it on GitHub, or unsubscribe.
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] hurukawatinami commented on issue #7940: 【sharding-proxy】Actual SQL execution results are incorrect (data should have been returned, but no data was returned),
Posted by GitBox <gi...@apache.org>.
hurukawatinami commented on issue #7940:
URL: https://github.com/apache/shardingsphere/issues/7940#issuecomment-742917202
Good, 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:
users@infra.apache.org
[GitHub] [shardingsphere] duzhanfei commented on issue #7940: 【sharding-proxy】Actual SQL execution results are incorrect (data should have been returned, but no data was returned),
Posted by GitBox <gi...@apache.org>.
duzhanfei commented on issue #7940:
URL: https://github.com/apache/shardingsphere/issues/7940#issuecomment-719454875
When using ShardingProxy to operate the database in the project,
there is no problem about add, delete or update
But the query does not return data
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] duzhanfei commented on issue #7940: 【sharding-proxy】Actual SQL execution results are incorrect (data should have been returned, but no data was returned),
Posted by GitBox <gi...@apache.org>.
duzhanfei commented on issue #7940:
URL: https://github.com/apache/shardingsphere/issues/7940#issuecomment-717875322
@Lucas-307
The expected results can be returned when the client is used alone
(When using the NavCAT or cmd control console, the correct results are expected)
<img width="723" alt="图片9" src="https://user-images.githubusercontent.com/46663706/97430479-e763f600-1953-11eb-9f96-469e8651e14b.png">
<img width="732" alt="图片8" src="https://user-images.githubusercontent.com/46663706/97430538-fcd92000-1953-11eb-9f0c-9379ca42a2b5.png">
but the execution results are not correct until they are integrated into the local project
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] duzhanfei commented on issue #7940: 【sharding-proxy】Actual SQL execution results are incorrect (data should have been returned, but no data was returned),
Posted by GitBox <gi...@apache.org>.
duzhanfei commented on issue #7940:
URL: https://github.com/apache/shardingsphere/issues/7940#issuecomment-718521148
@Lucas-307 @kimmking @qiqsa
When I switched the data source from mysql to ShardingProxy, I just changed the datesouce configuration,
Is there anything else 1 need to do ？ like import the corresponding dependencies
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] duzhanfei commented on issue #7940: 【sharding-proxy】Actual SQL execution results are incorrect (data should have been returned, but no data was returned),
Posted by GitBox <gi...@apache.org>.
duzhanfei commented on issue #7940:
URL: https://github.com/apache/shardingsphere/issues/7940#issuecomment-718709657
I just changed the datesouce configuration, doesn't import the any dependencies .
is this ok ?
At 2020-10-29 18:43:48, "邱鹿 Lucas" <no...@github.com> wrote:
@Lucas-307@kimmking@qiqsa
When I switched the data source from mysql to ShardingProxy, I just changed the datesouce configuration,
Is there anything else 1 need to do ？ like import the corresponding dependencies
I think this two is enough, you don't have to do anything else.
—
You are receiving this because you modified the open/close state.
Reply to this email directly, view it on GitHub, or unsubscribe.
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] duzhanfei commented on issue #7940: 【sharding-proxy】Actual SQL execution results are incorrect (data should have been returned, but no data was returned),
Posted by GitBox <gi...@apache.org>.
duzhanfei commented on issue #7940:
URL: https://github.com/apache/shardingsphere/issues/7940#issuecomment-722126317
Thank you very much
At 2020-11-05 11:10:33, "邱鹿 Lucas" <no...@github.com> wrote:
@Lucas-307 hi, can you reproduce this scene through the demo I provided ?
let me try.
—
You are receiving this because you were mentioned.
Reply to this email directly, view it on GitHub, or unsubscribe.
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] Lucas-307 commented on issue #7940: 【sharding-proxy】Actual SQL execution results are incorrect (data should have been returned, but no data was returned),
Posted by GitBox <gi...@apache.org>.
Lucas-307 commented on issue #7940:
URL: https://github.com/apache/shardingsphere/issues/7940#issuecomment-722113316
> @Lucas-307 hi, can you reproduce this scene through the demo I provided ?
let me try.
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] duzhanfei commented on issue #7940: 【sharding-proxy】Actual SQL execution results are incorrect (data should have been returned, but no data was returned),
Posted by GitBox <gi...@apache.org>.
duzhanfei commented on issue #7940:
URL: https://github.com/apache/shardingsphere/issues/7940#issuecomment-720281414
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org