[GitHub] [shardingsphere] strongduanmu commented on issue #22480: In the federation scenario, use ‘order by’ when creating a view, and use the ‘limit 10,5 ’clause when select the view, and the order of the result data is incorrect

[GitBox]

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

   When I execute create view statement, the following exception occurs.
   
   ```
   sharding_db=> create view left_join_view as select o.order_id, o.user_id, 
m.merchant_name from t_new_order o left join t_merchant m on o.merchant_id = 
m.merchant_id where o.user_id > 20 order by 1,2,3;
   ERROR:  relation "t_new_order_0" does not exist on gaussdb
   LINE 1: ...elect o.order_id, o.user_id, m.merchant_name from t_new_orde...
                                                                ^
   ```


-- 
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: notifications-unsubscr...@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
us...@infra.apache.org