[GitHub] [shardingsphere] wsm12138 commented on issue #22820: In the federation scenario, create view return error with "ERROR: String index out of range: -7".

Tue, 13 Dec 2022 23:07:18 -0800 


wsm12138 commented on issue #22820:
URL: 
https://github.com/apache/shardingsphere/issues/22820#issuecomment-1350513118

   0f8e1d8b239191fc91d7612d5fc5003ead5df2aa
   ```
   set dist variable sql_federation_type='ADVANCED';
   create view select_view as select o.order_id, o.user_id from t_order o where 
o.order_id > 1500 minus all select i.order_id, i.user_id from t_order_item i 
where i.order_id > 1500 order by order_id;
   create view select_viewb as select o.order_id, o.user_id from t_order o 
where o.order_id > 2500 except all select i.order_id, i.user_id from 
t_order_item i where i.order_id > 2000 order by order_id;
   ```
   
   <img width="609" alt="image" 
src="https://user-images.githubusercontent.com/86462784/207528824-594643e2-a677-4e46-a9e3-5be22f681318.png";>
   


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