lwtdev edited a comment on issue #7548:
URL: https://github.com/apache/shardingsphere/issues/7548#issuecomment-696549026
> hi, @lwtdev
> two points need to clearify:
>
> 1. when you create your table, before or after proxy started?
> 2. your inline expression is wrong, maybe route to ds_01.customer_0001,
that doesn't exist.
1. I did not create any tables;
In fact , the sql I want to execute was ``` sctl:explain select * from
customer where id = 3;```
And It's also cause a exception.
```sql
mysql> sctl:explain select * from customer where id = 3;
ERROR 10002 (C1000): 2Unknown exception: [null]
```
I test it in 4.1.1 and works well:
```sql
mysql> sctl:explain select * from customer_email where id = 3;
+-----------------+------------------------------------------------+
| datasource_name | sql |
+-----------------+------------------------------------------------+
| ds_01 | select * from customer_email_0003 where id = 3 |
+-----------------+------------------------------------------------+
1 row in set (0.24 sec)
```
2. Thanks for your patient to figure out this problem
The right config of `database_inline`should be
```yaml
database_inline:
type: INLINE
props:
algorithm-expression: ds_0${(id % 4 ).intdiv(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:
[email protected]
