Hello, I was, finally, trying the SQL handler on one of our collections. Executing a SELECT * FROM logs LIMIT 10 runs fine, but restricting the set using a WHERE clause gives me the exception below. The type field is a String type, indexed and has DocValues.
I must be doing something wrong, but have no idea what. Many thanks, Markus stmt=SELECT * FROM logs WHERE type=query LIMIT 10 gives me: java.lang.AssertionError: cannot translate call =(CAST($7):VARCHAR CHARACTER SET "ISO-8859-1" COLLATE "ISO-8859-1$en_US$primary", CAST($2):VARCHAR CHARACTER SET "ISO-8859-1" COLLATE "ISO-8859-1$en_US$primary") at org.apache.solr.handler.sql.SolrFilter$Translator.translateBinary(SolrFilter.java:181) at org.apache.solr.handler.sql.SolrFilter$Translator.translateComparison(SolrFilter.java:128) at org.apache.solr.handler.sql.SolrFilter$Translator.translateMatch(SolrFilter.java:81) at org.apache.solr.handler.sql.SolrFilter$Translator.access$100(SolrFilter.java:70) at org.apache.solr.handler.sql.SolrFilter.implement(SolrFilter.java:64) at org.apache.solr.handler.sql.SolrRel$Implementor.visitChild(SolrRel.java:103) at org.apache.solr.handler.sql.SolrSort.implement(SolrSort.java:58) at org.apache.solr.handler.sql.SolrRel$Implementor.visitChild(SolrRel.java:103) at org.apache.solr.handler.sql.SolrProject.implement(SolrProject.java:55) at org.apache.solr.handler.sql.SolrRel$Implementor.visitChild(SolrRel.java:103) at org.apache.solr.handler.sql.SolrToEnumerableConverter.implement(SolrToEnumerableConverter.java:61) at org.apache.calcite.adapter.enumerable.EnumerableRelImplementor.implementRoot(EnumerableRelImplementor.java:108) at org.apache.calcite.adapter.enumerable.EnumerableInterpretable.toBindable(EnumerableInterpretable.java:92) at org.apache.calcite.prepare.CalcitePrepareImpl$CalcitePreparingStmt.implement(CalcitePrepareImpl.java:1257) at org.apache.calcite.prepare.Prepare.prepareSql(Prepare.java:331) at org.apache.calcite.prepare.Prepare.prepareSql(Prepare.java:228) at org.apache.calcite.prepare.CalcitePrepareImpl.prepare2_(CalcitePrepareImpl.java:784) at org.apache.calcite.prepare.CalcitePrepareImpl.prepare_(CalcitePrepareImpl.java:639) at org.apache.calcite.prepare.CalcitePrepareImpl.prepareSql(CalcitePrepareImpl.java:609) at org.apache.calcite.jdbc.CalciteConnectionImpl.parseQuery(CalciteConnectionImpl.java:214) at org.apache.calcite.jdbc.CalciteMetaImpl.prepareAndExecute(CalciteMetaImpl.java:603) at org.apache.calcite.avatica.AvaticaConnection.prepareAndExecuteInternal(AvaticaConnection.java:638) at org.apache.calcite.avatica.AvaticaStatement.executeInternal(AvaticaStatement.java:149) at org.apache.calcite.avatica.AvaticaStatement.executeQuery(AvaticaStatement.java:218) at org.apache.solr.client.solrj.io.stream.JDBCStream.open(JDBCStream.java:269) at org.apache.solr.client.solrj.io.stream.ExceptionStream.open(ExceptionStream.java:54) at org.apache.solr.handler.StreamHandler$TimerStream.open(StreamHandler.java:397) at org.apache.solr.client.solrj.io.stream.TupleStream.writeMap(TupleStream.java:83)
