Hi,
我们用到的db2 的with as语句如下，目前druid不支持这个语句，是否可以支持
WITH rpl(INNER_ROLE_CD,INNER_ROLE_CD_1) as
(select root.INNER_ROLE_CD,root.INNER_ROLE_CD_1
from pl_0007 root
where root.INNER_ROLE_CD_1= ?
union all
select child.INNER_ROLE_CD,child.INNER_ROLE_CD_1
from rpl parent, pl_0007 child
where parent.INNER_ROLE_CD = child.INNER_ROLE_CD_1 )
select distinct rpl.INNER_ROLE_CD,rpl.INNER_ROLE_CD_1 from rpl;
li362692680
commented
7 years ago
Hi, 我们用到的db2 的with as语句如下，目前druid不支持这个语句，是否可以支持 WITH rpl(INNER_ROLE_CD,INNER_ROLE_CD_1) as (select root.INNER_ROLE_CD,root.INNER_ROLE_CD_1 from pl_0007 root where root.INNER_ROLE_CD_1= ? union all select child.INNER_ROLE_CD,child.INNER_ROLE_CD_1 from rpl parent, pl_0007 child where parent.INNER_ROLE_CD = child.INNER_ROLE_CD_1 ) select distinct rpl.INNER_ROLE_CD,rpl.INNER_ROLE_CD_1 from rpl;