PeiMouRen opened a new issue, #25596:
URL: https://github.com/apache/shardingsphere/issues/25596
# How to handle views that use sub database tables
for example, now there is a `t_order` table requires sharding(like
`ds_${0..1}.t_order`), but there is another view that uses the sharding table
`t_order`，like
```sql
CREATE
OR REPLACE VIEW v_order_detail ( orderId, orderDate, orderItemId,
orderItemName ) AS SELECT
t1.ID,
t1.DATE,
t2.ID,
t2.NAME
FROM
t_order t1
JOIN t_order_item t2 ON t1.ID = t2.orderId
```
what should I do with this view in this scenario? create this view in all
dbs, or only create in one of the dbs? Is there has other way to handle it?
--
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]
