[GitHub] [incubator-shardingsphere] liusf1993 opened a new issue #3273: Default database doesn't work on sql without tables

[GitBox <gi...@apache.org>]

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:
users@infra.apache.org


With regards,
Apache Git Services