New issue

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

#

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

Already on GitHub? # to your account

Jump to bottom

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

Closed

terrymanu opened this issue Aug 3, 2017 · 1 comment

Member

terrymanu commented Aug 3, 2017

由于子查询中的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


          fixed #310

df6eeb2

Member Author

terrymanu commented Aug 3, 2017

fixed at 1.5.1

terrymanu closed this as completed

terrymanu added a commit that referenced this issue


          fixed test case for #310

109c8b7

# for free to join this conversation on GitHub. Already have an account? # to comment