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

Jump to bottom

druid不能解析以full为别名的sql #1270

Closed
terryzhu opened this issue Jun 2, 2016 · 4 comments
Closed

druid不能解析以full为别名的sql #1270

terryzhu opened this issue Jun 2, 2016 · 4 comments
Labels
Bug
Milestone
1.0.30

Comments

@terryzhu
Copy link
Contributor

terryzhu commented Jun 2, 2016

druid不支持select full full from t1的语句
其中full为一个列名,第二个full为别名
但是mysql db是可以接受这条sql而不报错的
@zhangjianweibj
Copy link

改成：select full as full from t1

@wenshao wenshao added this to the 1.0.23 milestone Jul 15, 2016
@wenshao
Copy link
Member

wenshao commented Jul 15, 2016

为什么一定要这么写呢？

@wenshao wenshao modified the milestones: 1.0.24, 1.0.23 Jul 15, 2016
@terryzhu
Copy link
Contributor Author

主要是有ORM框架,不写as,把所有列名都隐式地声明了一个alias发到db

@wenshao wenshao modified the milestones: 1.0.25, 1.0.24 Aug 7, 2016
@wenshao wenshao modified the milestones: 1.0.26, 1.0.25 Aug 21, 2016
@wenshao wenshao modified the milestones: 1.0.27, 1.0.26 Sep 11, 2016
@wenshao wenshao modified the milestones: 1.0.28, 1.0.27 Nov 26, 2016
@wenshao wenshao modified the milestones: 1.0.29, 1.0.28 Feb 5, 2017
@wenshao wenshao modified the milestones: 1.0.30, 1.0.29 Mar 14, 2017
wenshao added a commit that referenced this issue May 13, 2017
@wenshao
mysql column alias support full. for issue #1270
05a4ac1
@wenshao wenshao added the Bug label May 13, 2017
@wenshao
Copy link
Member

wenshao commented May 14, 2017

已经支持，请使用新版本 https://github.com/alibaba/druid/releases/tag/1.0.30

@wenshao wenshao closed this as completed May 14, 2017
# for free to join this conversation on GitHub. Already have an account? # to comment
Assignees
No one assigned
Labels
Bug
Projects
None yet
Milestone
1.0.30
Development

No branches or pull requests
3 participants
@wenshao @terryzhu @zhangjianweibj