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

ORDER BY与GROUP BY衍生列未添加表名或表别名 #63

Closed
hanahmily opened this issue May 6, 2016 · 0 comments
Closed

ORDER BY与GROUP BY衍生列未添加表名或表别名 #63

hanahmily opened this issue May 6, 2016 · 0 comments

Comments

@hanahmily
Copy link
Contributor

  1. order by 生成的补充列不带所有表的别名
    bug现象
select ... order_id AS sharding_gen_1 from order a order by a.order_id

应该为

select ... a.order_id AS sharding_gen_1 from order a order by a.order_id
  1. group by 生成补充列时没有判断查询投射中是否已经存在了该列
    bug现象
select a.order_id, order_id AS sharding_gen_1 from order a group by a.order_id

应该为

select a.order_id  from order a order by a.order_id
@terrymanu terrymanu changed the title order by 和 group by 生成补充列的bug [BUG] ORDER BY与GROUP BY衍生列未添加表名或表别名 May 6, 2016
@terrymanu terrymanu changed the title [BUG] ORDER BY与GROUP BY衍生列未添加表名或表别名 ORDER BY与GROUP BY衍生列未添加表名或表别名 Jul 11, 2016
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