[teiid-issues] [JBoss JIRA] (TEIID-3279) SOLR: Error when date, time or timestamp literal is in where clause

[Filip Elias (JIRA)]

Filip Elias created TEIID-3279:
----------------------------------

             Summary: SOLR: Error when date,time or timestamp literal is in where clause
                 Key: TEIID-3279
                 URL: https://issues.jboss.org/browse/TEIID-3279
             Project: Teiid
          Issue Type: Bug
          Components: Connector API
    Affects Versions: 8.7
            Reporter: Filip Elias
            Assignee: Steven Hawkins


Query fails when time,date or timestamp literal is used in where clause.

Examples:
Query:
{code}select intkey from smalla where timevalue = '11:30:20'{code}
Error:
{code}
'11:30:20'org.apache.solr.client.solrj.impl.HttpSolrServer$RemoteSolrException: Invalid Date String:'11-30-20'
	at org.apache.solr.client.solrj.impl.HttpSolrServer.request(HttpSolrServer.java:491)
{code}
Query:
{code}select intkey from smalla where datevalue = '2002-02-02'{code}
Error: 
{code}
org.apache.solr.client.solrj.impl.HttpSolrServer$RemoteSolrException: Invalid Date String:'11-30-20'
	at org.apache.solr.client.solrj.impl.HttpSolrServer.request(HttpSolrServer.java:491)
{code}
Query:
{code}select intkey from smalla where timestampvalue = '2000-01-01 00:00:04'{code}
Error:
{code} org.apache.solr.client.solrj.impl.HttpSolrServer$RemoteSolrException: Invalid Date String:'2000-01-01T00-00-04'
	at org.apache.solr.client.solrj.impl.HttpSolrServer.request(HttpSolrServer.java:491)
{code}

SOLR supports only timestamps (YYYY-mm-ddThh:mm:ssZ) so date and time types should be converted into timestamp before a query is send to  SOLR.





--
This message was sent by Atlassian JIRA
(v6.3.11#6341)