Skip to content
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

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
# for free to join this conversation on GitHub. Already have an account? # to comment
Projects
None yet
Development

No branches or pull requests

2 participants