Afsalmc commented on issue #29841:
URL:
https://github.com/apache/shardingsphere/issues/29841#issuecomment-1912391998
@strongduanmu
```
dataSources:
db0:
dataSourceClassName: com.zaxxer.hikari.HikariDataSource
driverClassName: com.microsoft.sqlserver
jdbcUrl:
jdbc:sqlserver://db1.database.windows.net;databaseName=db1;loginTimeout=300;encrypt=false;
username: adm
db1:
dataSourceClassName: com.zaxxer.hikari.HikariDataSource
driverClassName: com.microsoft.sqlserver
jdbcUrl:
jdbc:sqlserver://db11.database.windows.net;databaseName=db11;loginTimeout=300;encrypt=false;
username: adm
rules:
- !SQL_FEDERATION
sqlFederationEnabled: true
executionPlanCache:
initialCapacity: 1000
maximumSize: 4000
- !SHARDING
tables:
ACCOUNT:
actualDataNodes: dbo.Account,db1.Account
```
I haven't used any init SQL. The schema was already defined and I just
connected using shardingsphere jdbc. I also noticed that I'm only getting this
weird behavior when the query contains Distinct keyword :
`select count(DISTINCT accountid)
as c,Stamp from dbo.Account
group by stamp`
Not when
`select count(accountid)
as c,Stamp from Account
group by stamp`
--
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: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
