Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

postgres expect RPAREN, actual RECURSIVE #1789

Closed
DevilMayCrySamsara opened this issue Jun 21, 2017 · 2 comments
Closed

postgres expect RPAREN, actual RECURSIVE #1789

DevilMayCrySamsara opened this issue Jun 21, 2017 · 2 comments
Labels
Milestone

Comments

@DevilMayCrySamsara
Copy link

postgres 有RECURSIVE,递归查询,但是貌似druid不支持?

@DevilMayCrySamsara
Copy link
Author

delete from itsm_system_role_menu where menu_id in(
with RECURSIVE menuTemp(menu_id,parent_id)
as (
select menu_id ,parent_id from itsm_system_menu where menu_id in
(
'M00006'
)
union all
select a.menu_id ,a.parent_id from itsm_system_menu as a INNER JOIN menuTemp b on a.parent_id=b.menu_id
)
select menu_id from menuTemp);

@wenshao wenshao added the Bug label Jun 23, 2017
@wenshao wenshao added this to the 1.1.0 milestone Jun 23, 2017
@wenshao
Copy link
Member

wenshao commented Jun 25, 2017

已修复问题,请用新版本 https://github.com/alibaba/druid/releases/tag/1.1.0

@wenshao wenshao closed this as completed Jun 25, 2017
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
None yet
Development

No branches or pull requests

2 participants