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

merge sql error dbType postgresql #1841

Closed
gongdear opened this issue Jul 20, 2017 · 2 comments
Closed

merge sql error dbType postgresql #1841

gongdear opened this issue Jul 20, 2017 · 2 comments
Labels
Milestone

Comments

@gongdear
Copy link

gongdear commented Jul 20, 2017

{com.alibaba.druid.filter.stat.StatFilter:148}-merge sql error, dbType postgresql,
sql : select gid, kind, mapid, poi_id, telephone, admincode, x, y, zipcode, name, address, street, number,geom from public.v_poi order by public.v_poi.geom <-> st_point(?,?) limit 1

developer environment:spring4.2.5.RELEASE mybatis3.3.1 druid1.1.1 redis3.0.5;
redis is used for cache;
but both result and cache are correct :)

@gongdear gongdear changed the title merge sql error with postgresql/postgis merge sql error dbType postgresql Jul 20, 2017
@gongdear
Copy link
Author

I try to repleace '<->' to 'st_distance' then console doesn't show any error , druid probably unsupported '<->'

@wenshao wenshao added the Bug label Jul 20, 2017
@wenshao wenshao added this to the 1.1.2 milestone Jul 20, 2017
@wenshao
Copy link
Member

wenshao commented Jul 23, 2017

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

@wenshao wenshao closed this as completed Jul 23, 2017
# for free to join this conversation on GitHub. Already have an account? # to comment
Labels
Projects
None yet
Development

No branches or pull requests

2 participants