Re: Solr date variable resolver is not working with MySql

[Shawn Heisey]

On 6/10/2015 6:43 AM, abhijit bashetti wrote:

<snip>

>  &gt;= to_date('[?, '28/05/2015 11:13:50']', 'DD/MM/YYYY HH24:MI:SS')

<snip>

> Anyone knows where is the problem? Why is the variable resolver not working 
> as expected?
> Note : to_date is function written by us in MySql.
> I have checked out the solr code from svn... trying it by adding logs to 
> it...but the logs are not reflected and i m not able to move it.
> I am not very sure very it is wrong ...but just a wild guess that something 
> is wrong at variableResolverImpl.replaceTokens or at the 
> TemplateString.fillTokens...
> I will keep on it but if you know/get a chance to look at it, it would be of 
> great help from your end..

You should not need to use "to_date" with MySQL.  Do you know whether
MySQL will accept DD/MM/YYYY for dates on your system?  If it will, you
should be able to use this directly in your query:

doc.index_state_modification_date >= '${dih.request.lastIndexDate}'

If I were you, I would use YYYY/MM/DD for dates, just to be sure that
locale settings won't cause it to be misinterpreted.

Thanks,
Shawn