[
https://issues.apache.org/jira/browse/SOLR-4978?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13701129#comment-13701129
]
Bill Au commented on SOLR-4978:
-------------------------------
This will only have an effect if convertType is enabled and will only affect
date field type. convertType is disabled by default. I guess most people use
the default setting, which is probably why no one has noticed this bug before.
The current behavior for date field type is incorrect when converType is
enabled. Making the change will fix the bug. So date fields indexed by DIH
when convertType is enabled will actually have a time portion.
> Time is stripped from datetime column when imported into Solr date field
> ------------------------------------------------------------------------
>
> Key: SOLR-4978
> URL: https://issues.apache.org/jira/browse/SOLR-4978
> Project: Solr
> Issue Type: Bug
> Components: contrib - DataImportHandler
> Reporter: Bill Au
>
> I discovered that all dates I imported into a Solr date field from a MySQL
> datetime column have the time stripped (ie time portion is always 00:00:00).
> After double checking my DIH config and trying different things, I decided to
> take a look at the DIH code.
> When I looked at the source code of DIH JdbcDataSource class, I discovered
> that it is using java.sql.ResultSet and its getDate() method to handle date
> field. The getDate() method returns java.sql.Date. The java api doc for
> java.sql.Date
> http://docs.oracle.com/javase/6/docs/api/java/sql/Date.html
> states that:
> "To conform with the definition of SQL DATE, the millisecond values wrapped
> by a java.sql.Date instance must be 'normalized' by setting the hours,
> minutes, seconds, and milliseconds to zero in the particular time zone with
> which the instance is associated."
> I am so surprise at my finding that I think I may not be right. What am I
> doing wrong here? This is such a big hole in DIH, how could it be possible
> that no one has noticed this until now?
> Has anyone successfully imported a datetime column into a Solr date field
> using DIH?
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscr...@lucene.apache.org
For additional commands, e-mail: dev-h...@lucene.apache.org
