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

子查询中的orderby和groupby不列入解析上下文 #310

Closed
terrymanu opened this issue Aug 3, 2017 · 1 comment
Closed

子查询中的orderby和groupby不列入解析上下文 #310

terrymanu opened this issue Aug 3, 2017 · 1 comment

Comments

@terrymanu
Copy link
Member

由于子查询中的orderby和groupby无法在结果归并模块中归并,因为归并数据并未下推到jdbc端。因此,包含子查询的orderby和groupby将不进行排序和分组归并。
此修改适用于以下场景

SELECT COUNT(1) FROM (SELECT * FROM t_order ORDER BY order_id desc) t
terrymanu added a commit that referenced this issue Aug 3, 2017
@terrymanu
Copy link
Member Author

fixed at 1.5.1

terrymanu added a commit that referenced this issue Aug 3, 2017
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant