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.