[SOLR-15456] Solr SQL metrics for field with custom field type defaults to String instead of using the correct numeric type

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Fix Version/s: 9.0, 8.10
• Component/s: Parallel SQL
• Labels: RobustSQL
• Assignee: Timothy Potter
• Reporter: Timothy Potter
• Created: 07/Jun/21 22:10
• Updated: 28/Sep/21 20:22
• Resolved: 21/Jun/21 21:11

Description

I have a simple "stats" query (from SolrTable) that requests the min / max of an integer field, but that field is declared in the schema using a custom field type, such as:

  <fieldType name="integer" class="solr.TrieIntField" .../>

  <field name="myIntField" type="integer"  .../>

The switch at https://github.com/apache/solr/blob/main/solr/core/src/java/org/apache/solr/handler/sql/SolrSchema.java#L144 causes the "type" for this field to be String which results in some weird output for this query:

SELECT min(myIntField), max(myIntField) from table

Results:

{
  "result-set":{
    "docs":[{
        "EXPR$0":"2.0210507E7",
        "EXPR$1":"2.0210605E7"}
      ,{
        "EOF":true,
        "RESPONSE_TIME":8846}]}}

Since we're querying /luke already to get schema info, we might as well use the field type info vs. defaulting to String

Issue Links

• links to: GitHub Pull Request #181
• links to: GitHub Pull Request #2524