Try cast(concat(...) as char) ... Cheers Avlesh
On Wed, Nov 4, 2009 at 7:36 PM, Jonathan Hendler <jonathan.hend...@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>[...@1db4c43</str> > <str>[...@6bcef1</str> > <str>[...@1df503b</str> > <str>[...@c5dbb</str> > <str>[...@1ddc3ea</str> > <str>[...@6963b0</str> > <str>[...@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 > > >
