liusf1993 opened a new issue #3273: Default database doesn't work on sql 
without tables
URL: https://github.com/apache/incubator-shardingsphere/issues/3273
 
 
   My case is like this:
   I have two db `db1` and `db2`.  `db1` ows table `t1`,`t2`,`t3`, function 
`f1`, and `db2` only onws `t2`. Only table `t2` was in partition, so I want sql 
related to `t1` , `t3`, `f1` to be executed on `db1`, only `t2` be executed on 
`db1` and `db2` according to it's condition value. I use the configuration 
`spring.shardingsphere.sharding.default-data-source-name`, now sql related to 
`t1` or `t3` was executed on `d1` as expected, but `f1`'s execution database 
was in random.  
   
   The result I **expected** is like this,
   ```select 1 from t1;``` on db1
   ```select 1 from t3;``` on db1
   **``` select f1;``` on db1**
   ```select 1 from t2;``` on db1,db2
   
   The **actual** result is like this:
   ```select 1 from t1;``` on db1
   ```select 1 from t3;``` on db1
   **``` select f1;``` on (db1 or db2 in random)**
   ```select 1 from t2;``` on db1,db2

----------------------------------------------------------------
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:
[email protected]


With regards,
Apache Git Services

Reply via email to