Good evening Lords and Ladys: <br />I'm using SQLServer 2000 and Hibernate
Search 3.1.0, when I'm following Hibernate Search In Action, I found this
bug (HSEARCH-248).<br /><br />I'm asking for a hint on where to debug and
for any ideas to fix the generated query.<br /><br />Since I'm not
an SQLServer 2000 expert, I think that this bug may be solved with this
recipe:<br />1. Convert to varchar and concatenate all tuples
involved in the where as well as its corresponding values.<br />2.
Timestamp tuples must be considered to be converted, whit SQLServer 21
conversion type.<br /><br />Example of resulting query: <br /><br />select
<br />this_.CV_CURP as CV2_47_0_<br />from EC.dbo.TEXTO_PACIENTE this_ <br
/>where this_.id_tipo_texto='23' and <br />
(CONVERT(VARCHAR,this_.CV_CURP)+CONVERT(VARCHAR,this_.TM_EVENTO,21)+
CONVERT(VARCHAR,this_.ID_TIPO_TEXTO)) in (<br />
(CONVERT(VARCHAR,?)+CONVERT(VARCHAR,?,21)+CONVERT(VARCHAR,?)))<br /><br
/><br /><br />Cheers, <br />Arturo