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

sql server 序列查询问题 #1992

Closed
LeasonX opened this issue Sep 21, 2017 · 3 comments
Closed

sql server 序列查询问题 #1992

LeasonX opened this issue Sep 21, 2017 · 3 comments

Comments

@LeasonX
Copy link

LeasonX commented Sep 21, 2017

开启wall filter执行select next value for orderId这个语句报错,报错信息如下

Caused by: com.alibaba.druid.sql.parser.ParserException: syntax error, not support option : IDENTIFIER, pos 29, line 1, column 22, token IDENTIFIER OrderId
	at com.alibaba.druid.sql.dialect.sqlserver.parser.SQLServerSelectParser.select(SQLServerSelectParser.java:93)
	at com.alibaba.druid.sql.parser.SQLStatementParser.parseSelect(SQLStatementParser.java:2087)
	at com.alibaba.druid.sql.parser.SQLStatementParser.parseStatementList(SQLStatementParser.java:143)
	at com.alibaba.druid.sql.parser.SQLStatementParser.parseStatementList(SQLStatementParser.java:93)
	at com.alibaba.druid.sql.parser.SQLStatementParser.parseStatementList(SQLStatementParser.java:89)
	at com.alibaba.druid.wall.WallProvider.checkInternal(WallProvider.java:620)
	at com.alibaba.druid.wall.WallProvider.check(WallProvider.java:574)
	at com.alibaba.druid.wall.WallFilter.check(WallFilter.java:712)
	... 160 common frames omitted

请问是因为什么原因

@wenshao wenshao added this to the 1.1.4 milestone Sep 22, 2017
@wenshao
Copy link
Member

wenshao commented Sep 22, 2017

不能解析sql语句导致的,这个周末回发布新版本解决此问题

@LeasonX
Copy link
Author

LeasonX commented Sep 22, 2017

@wenshao 最好也能在druid-spring-boot-starter项目中解决此问题。

@wenshao
Copy link
Member

wenshao commented Oct 3, 2017

https://github.com/alibaba/druid/releases/tag/1.1.4
问题已经修复,请使用新版本

@wenshao wenshao closed this as completed Oct 3, 2017
# 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