Uploaded image for project: 'Solr'
  1. Solr
  2. SOLR-10353

TestSQLHandler reproducible failure: No match found for function signature min(<NUMERIC>)

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 7.0, 7.1, master (8.0)
    • Component/s: Parallel SQL
    • Security Level: Public (Default Security Level. Issues are Public)
    • Labels:
      None

      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)
      

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                risdenk Kevin Risden
                Reporter:
                hossman Hoss Man
              • Votes:
                0 Vote for this issue
                Watchers:
                6 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: