strongduanmu commented on issue #21230:
URL: 
https://github.com/apache/shardingsphere/issues/21230#issuecomment-1261652152

   Following is my test result.
   
   ```sql
   sharding_db=> show sharding broadcast table rules;
    sharding_broadcast_tables
   ---------------------------
    t_broadcast
    t_broadcast_view
    t_broadcast_view_new
   (3 rows)
   
   sharding_db=> create view t_broadcast_view as select * from t_broadcast;
   CREATE VIEW
   sharding_db=>
   sharding_db=> select * from t_broadcast_view where id=4;
    id | c_id | a  |     b
   ----+------+----+------------
     4 |    4 | 40 | test4
   (1 row)
   
   sharding_db=> alter view t_broadcast_view rename to t_broadcast_view_new;
   ALTER VIEW
   
   sharding_db=> select * from t_broadcast_view_new where id=4;
    id | c_id | a  |     b
   ----+------+----+------------
     4 |    4 | 40 | test4
   (1 row)
   ```


-- 
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]

Reply via email to