[SOLR-10353] TestSQLHandler reproducible failure: No match found for function signature min(<NUMERIC>)

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 7.0, 7.1, 8.0
• Component/s: Parallel SQL
• Assignee: Kevin Risden
• Reporter: Chris M. Hostetter
• Created: 23/Mar/17 18:22
• Updated: 08/Jun/19 15:34
• Resolved: 06/Aug/17 18:20

Description

found this while doing jdk9 testing, but the seed reproduces with jdk8 as well...

hossman@tray:~/lucene/dev/solr/core [master] $ git rev-parse HEAD
c221ef0fdedaa92885746b3073150f0bd558f596
hossman@tray:~/lucene/dev/solr/core [master] $ ant test  -Dtestcase=TestSQLHandler -Dtests.method=doTest -Dtests.seed=D778831206956D34 -Dtests.nightly=true -Dtests.slow=true -Dtests.locale=az-Cyrl-AZ -Dtests.timezone=America/Cayman -Dtests.asserts=true -Dtests.file.encoding=ANSI_X3.4-1968
...
   [junit4]   2> NOTE: reproduce with: ant test  -Dtestcase=TestSQLHandler -Dtests.method=doTest -Dtests.seed=D778831206956D34 -Dtests.nightly=true -Dtests.slow=true -Dtests.locale=az-Cyrl-AZ -Dtests.timezone=America/Cayman -Dtests.asserts=true -Dtests.file.encoding=ANSI_X3.4-1968
   [junit4] ERROR   28.0s | TestSQLHandler.doTest <<<
   [junit4]    > Throwable #1: java.io.IOException: --> http://127.0.0.1:37402/collection1:Failed to execute sqlQuery 'select str_s, count(*), sum(field_i), min(field_i), max(field_i), cast(avg(1.0 * field_i) as float) from collection1 where text='XXXX' group by str_s order by sum(field_i) asc limit 2' against JDBC connection 'jdbc:calcitesolr:'.
   [junit4]    > Error while executing SQL "select str_s, count(*), sum(field_i), min(field_i), max(field_i), cast(avg(1.0 * field_i) as float) from collection1 where text='XXXX' group by str_s order by sum(field_i) asc limit 2": From line 1, column 39 to line 1, column 50: No match found for function signature min(<NUMERIC>)
   [junit4]    > 	at __randomizedtesting.SeedInfo.seed([D778831206956D34:703C3BB66B2E7E8D]:0)
   [junit4]    > 	at org.apache.solr.client.solrj.io.stream.SolrStream.read(SolrStream.java:235)
   [junit4]    > 	at org.apache.solr.handler.TestSQLHandler.getTuples(TestSQLHandler.java:2349)
   [junit4]    > 	at org.apache.solr.handler.TestSQLHandler.testBasicGrouping(TestSQLHandler.java:675)
   [junit4]    > 	at org.apache.solr.handler.TestSQLHandler.doTest(TestSQLHandler.java:90)
   [junit4]    > 	at org.apache.solr.BaseDistributedSearchTestCase$ShardsRepeatRule$ShardsFixedStatement.callStatement(BaseDistributedSearchTestCase.java:985)
   [junit4]    > 	at org.apache.solr.BaseDistributedSearchTestCase$ShardsRepeatRule$ShardsStatement.evaluate(BaseDistributedSearchTestCase.java:960)
   [junit4]    > 	at java.lang.Thread.run(Thread.java:745)

Issue Links

• is depended upon by: SOLR-9963 Add Apache Calcite Avatica handler to Solr
• relates to: CALCITE-1667 Forbid calls to JDK APIs that use the default locale, time zone or character set
• relates to: SOLR-8593 Integrate Apache Calcite into the SQLHandler