lwtdev edited a comment on issue #7548:
URL: https://github.com/apache/shardingsphere/issues/7548#issuecomment-696564515
> Hi @lwtdev
> So, if you create a logic table `customer` and execute `select * from
customer where id = 3;`, does everything go well?
>
> Plus, if there is a logic table, do you think the following error will
still happen?
>
> ```sql
> mysql> sctl:explain select * from customer where id = 3;
> ERROR 10002 (C1000): 2Unknown exception: [null]
> ```
Can not create logic table `customer` after proxy started.
```sql
create table customer(id bigint(23) primary key );
ERROR 10002 (C1000): 2Unknown exception: [null]
```
If create physical tables `customer_000{0...3}` before proxy started. It
works well:
```sql
mysql> sctl:explain select * from customer where id = 3;
+-----------------+------------------------------------------+
| datasource_name | sql |
+-----------------+------------------------------------------+
| ds_01 | select * from customer_0003 where id = 3 |
+-----------------+------------------------------------------+
1 row in set (0.01 sec)
mysql> select * from customer where id = 3;
Empty set (0.07 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.
For queries about this service, please contact Infrastructure at:
[email protected]
