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

db2 获取sequence值出错 #1323

Closed
hualunqun opened this issue Jul 7, 2016 · 0 comments
Closed

db2 获取sequence值出错 #1323

hualunqun opened this issue Jul 7, 2016 · 0 comments
Milestone
1.0.22

Comments

@hualunqun
Copy link

数据库：DB2;
druid版本：1.0.21;
问题：假设数据库中存在sequence名为TEST_SEQ，当向数据库中发出取sequence值的语句
SELECT (NEXTVAL FOR TEST_SEQ) FROM SYSIBM.SYSDUMMY1
时druid打印异常：

merge sql error, dbType db2, sql:......
com.alibaba.druid.sql.parser.ParserException: syntax error, except RPAREN, actual FOR FOR

这个语句在DB2中是正确执行的。
@wenshao wenshao added this to the 1.0.22 milestone Jul 8, 2016
wenshao added a commit to wenshao/druid that referenced this issue Jul 8, 2016
@wenshao
db2 sql parser support sequence expr. fixed issue alibaba#1323
8ec64dc
@wenshao wenshao closed this as completed Jul 8, 2016
wenshao added a commit that referenced this issue Jul 8, 2016
@wenshao
db2 sql parser support sequence expr. fixed issue #1323
552e090
wenshao added a commit to wenshao/druid that referenced this issue Jul 8, 2016
@wenshao
db2 sql parser support sequence expr. fixed issue alibaba#1323
e9334f0
# for free to join this conversation on GitHub. Already have an account? # to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
1.0.22
Development

No branches or pull requests
2 participants
@wenshao @hualunqun