phoema commented on issue #4953: Can we specify some specific database 
operations without parsing through the shardingsphere framework
URL: 
https://github.com/apache/incubator-shardingsphere/issues/4953#issuecomment-604284837
 
 
   example:
   we have some complex sqls like 
   many join tables and with functions 
   but now shardingsphere Support not well, so we want to go around
   only excute the sql with out shardingsphere parse。
   is have any way to do this?
   func_inc_var_session is our customer function
   select `func_inc_var_session`(`t`.`procinsid`,`t`.`task_def_key`,0) AS 
`rownum`,....
   from ((((`act_hi_taskinst` `a` left join `act_hi_procinst` 
on((`a`.`PROC_INST_ID_` = `act_hi_procinst`.`ID_`))) left join `flow_extend` 
on((`act_hi_procinst`.`BUSINESS_KEY_` = `flow_extend`.`id`))) left join 
`case_info` on((`flow_extend`.`case_id` = `case_info`.`id`))) left join 
`flow_define` on((`flow_extend`.`flow_def_id` = `flow_define`.`id`))) where 
(`a`.`ASSIGNEE_` is not null) order by 
`a`.`PROC_INST_ID_`,`a`.`TASK_DEF_KEY_`,`a`.`START_TIME_` desc) `t` join 
(select `func_inc_var_session`(NULL,NULL,1) AS 
`func_inc_var_session(null,null,1)`) `b`)

----------------------------------------------------------------
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:
us...@infra.apache.org


With regards,
Apache Git Services

Reply via email to