Hey Eric,

On Mon, Jan 24, 2011 at 7:23 PM, Eric Angel <eric.angel...@gmail.com> wrote:

> * Or you can typecast before you concat:
> > * <entity name="practice" pk="id" query="select id, name, concat_ws(',',
> > cast(lat as char), cast(lng as char)) as latlng from practice "></entity>
>

Casting before or after concat'ing, work's both - as we've seen two weeks
ago, in a similar thread (
http://search.lucidimagination.com/search/document/250975238eaeb9e0/solr_4_0_spatial_search_how_to#60c4c05c9b482df1
)

But anyway, thanks for pointing out, that it's really a (confirmed)
MySQL-Bug - very annoying :/

Regards
Stefan

Reply via email to