Druid 不支持sqlServer的top关键字查询吗?

m528fe3b  于 4个月前  发布在  Druid
关注(0)|答案(2)|浏览(68)

目前用sqlServer select top 100 * from xx,报错。请问是否不支持,异常稍后贴出

628mspwn

628mspwn1#

c.a.d.f.s.StatFilter.mergeSql merge sql error, dbType com.alibaba.druid.pool.DruidDataSource, druid-1.1.17, sql : select top 300 GOODSID
from JDGOODS where
SHOPID = ?
and status in (0,2) and trycount2 <= 5

group by GOODSID

com.alibaba.druid.sql.parser.ParserException: syntax error, error in :' top 300 GOODSID

pb3s4cty

pb3s4cty2#

1.1.22 ParserException: syntax error, error in :'P(?) goods0_.goods_id as goods_id1_', expect DOT, actual DOT pos 22, line 1, column 22, token DOT

相关问题