lucene-solr-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Avlesh Singh <avl...@gmail.com>
Subject Re: Bug with DIH and MySQL CONCAT()?
Date Wed, 04 Nov 2009 14:44:08 GMT
Try cast(concat(...) as char) ...

Cheers
Avlesh

On Wed, Nov 4, 2009 at 7:36 PM, Jonathan Hendler <jonathan.hendler@gmail.com
> wrote:

> Hi All,
>
> I have an SQL query that begins with "SELECT CONCAT (  'ID', Subject.id  ,
> ':' , Subject.name , ':L', Subject.level) as subject_name" and the query
> runs great against MySQL from the command line.
> Since this is a nested entity, the schema.xml contains "<field
> name="subject_name" type="string" indexed="true" stored="true"
> multiValued="true" />"
>
> After a full-import, a select output of the xml looks like
>
> "<arr name="subject_name">
> <str>[B@1db4c43</str>
> <str>[B@6bcef1</str>
> <str>[B@1df503b</str>
> <str>[B@c5dbb</str>
> <str>[B@1ddc3ea</str>
> <str>[B@6963b0</str>
> <str>[B@10fe215</str>
> ...
> "
>
> Without a CONCAT - it works fine.
>
> Is this a bug?
>
> Meanwhile - should I go about concatenating some where else in the DIH
> config?
>
> Thanks.
>
> - Jonathan
>
>
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message