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 2021/09/22 02:57:30 UTC
[GitHub] [shardingsphere] CrackerSuperior opened a new issue #12611: Why are SQL execution results different?
CrackerSuperior opened a new issue #12611:
URL: https://github.com/apache/shardingsphere/issues/12611
Why are SQL execution results different? By rights, these two SQL results should be the same.
My version is 5.0.0-beta.
SQL 1：
``` sql
mysql> select EVTSN from acct_retn_evt_c limit 5;
+---------+
| EVTSN |
+---------+
| 8673633 |
| 4288503 |
| 3150255 |
| 5586885 |
| 7989813 |
+---------+
5 rows in set (0.01 sec)
```
SQL 2 :
```sql
mysql> select t.EVTSN from (select * from acct_retn_evt_c limit 5) as t;
+---------+
| EVTSN |
+---------+
| 8673633 |
| 7989813 |
| 8985855 |
| 8319346 |
| 3940432 |
| 4288503 |
| 515120 |
| 8814116 |
| 2362388 |
| 4445725 |
| 3150255 |
| 5732529 |
| 6555199 |
| 1239401 |
| 358936 |
| 5586885 |
| 8843936 |
| 4457043 |
| 3185153 |
| 9137463 |
+---------+
20 rows in set (0.01 sec)
```
--
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.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] CrackerSuperior commented on issue #12611: Why are SQL execution results different?
Posted by GitBox <gi...@apache.org>.
CrackerSuperior commented on issue #12611:
URL: https://github.com/apache/shardingsphere/issues/12611#issuecomment-924542475
> @CrackerSuperior Can you provide your config?
``` yaml
schemaName: test
dataSources:
ds_0:
url: jdbc:mysql://172.18.40.194:3306/test?serverTimezone=UTC&useSSL=false
username: pcloud
password: pcloud
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
maxPoolSize: 50
minPoolSize: 1
maintenanceIntervalMilliseconds: 30000
ds_1:
url: jdbc:mysql://172.18.40.195:3306/test?serverTimezone=UTC&useSSL=false
username: pcloud
password: pcloud
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
maxPoolSize: 50
minPoolSize: 1
maintenanceIntervalMilliseconds: 30000
ds_2:
url: jdbc:mysql://172.18.40.196:3306/test?serverTimezone=UTC&useSSL=false
username: pcloud
password: pcloud
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
maxPoolSize: 50
minPoolSize: 1
maintenanceIntervalMilliseconds: 30000
ds_3:
url: jdbc:mysql://172.18.40.198:3306/test?serverTimezone=UTC&useSSL=false
username: pcloud
password: pcloud
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
maxPoolSize: 50
minPoolSize: 1
maintenanceIntervalMilliseconds: 30000
rules:
- !SHARDING
tables:
acct_retn_evt_c:
actualDataNodes: ds_${0..3}.acct_retn_evt_c
keyGenerateStrategy:
column: acct_retn_detl_id
keyGeneratorName: snowflake
acct_retn_evt_c_b:
actualDataNodes: ds_${0..3}.acct_retn_evt_c_b
keyGenerateStrategy:
column: acct_retn_detl_id
keyGeneratorName: snowflake
bindingTables:
- acct_retn_evt_c,acct_retn_evt_c_b
defaultDatabaseStrategy:
standard:
shardingColumn: acct_retn_detl_id
shardingAlgorithmName: database_inline
defaultTableStrategy:
none:
shardingAlgorithms:
database_inline:
type: INLINE
props:
algorithm-expression: ds_${acct_retn_detl_id % 4}
keyGenerators:
snowflake:
type: SNOWFLAKE
props:
worker-id: 123
--
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.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] strongduanmu closed issue #12611: Why are SQL execution results different?
Posted by GitBox <gi...@apache.org>.
strongduanmu closed issue #12611:
URL: https://github.com/apache/shardingsphere/issues/12611
--
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.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] strongduanmu commented on issue #12611: Why are SQL execution results different?
Posted by GitBox <gi...@apache.org>.
strongduanmu commented on issue #12611:
URL: https://github.com/apache/shardingsphere/issues/12611#issuecomment-924541093
@CrackerSuperior Can you provide your config?
--
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.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] CrackerSuperior commented on issue #12611: Why are SQL execution results different?
Posted by GitBox <gi...@apache.org>.
CrackerSuperior commented on issue #12611:
URL: https://github.com/apache/shardingsphere/issues/12611#issuecomment-924550665
> Duplicate with #12553.
Ok, thanks. I'll keep an eye on 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.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] strongduanmu commented on issue #12611: Why are SQL execution results different?
Posted by GitBox <gi...@apache.org>.
strongduanmu commented on issue #12611:
URL: https://github.com/apache/shardingsphere/issues/12611#issuecomment-924544682
Duplicate with #12553.
--
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.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] strongduanmu commented on issue #12611: Why are SQL execution results different?
Posted by GitBox <gi...@apache.org>.
strongduanmu commented on issue #12611:
URL: https://github.com/apache/shardingsphere/issues/12611#issuecomment-924543977
@CrackerSuperior Thank you for your detailed info, this issue may duplicate with #12553. I will check it.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org