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

路由到单库单表移除补充的SQL语句片段 #210

Closed
hanahmily opened this issue Dec 19, 2016 · 1 comment
Closed

路由到单库单表移除补充的SQL语句片段 #210

hanahmily opened this issue Dec 19, 2016 · 1 comment

Comments

@hanahmily
Copy link
Contributor

Sharing-JDBC会在order by,group by 等语句中对原始的sql进行改造,增加一些而外的内容。
但是在最终路由结果为单库单表时,这些增加的SQL片段就是一些多余的内容。

建议的新功能行为

在最终结果为单库单表时,去掉这些增加的内容。

为什么这个新功能是对大多数用户有用的

这个功能对性能的提升有帮助,同时可以帮助一些有子查询的遗留系统

@StormAll
Copy link

正在处理此issue
大致修改思路:
1、在SQLBuilder中对SQL片段增加是否是额外增加的标识
2、在SQLRouteEngine的routeSQL方法,根据路由结果,处理额外增加的SQL片段

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants