[ES|QL] Sort returns a bug when the table has unsupportef fields

[stratoula]

Elasticsearch Version

main

Installed Plugins

No response

Java Version

bundled

OS Version

Darwin

Problem Description

Sorting fails sometimes with the error

No TopN sorting encoder for type UNSUPPORTED

Steps to Reproduce

Playing with ES|QL I tried to run the following query

from logstash-* | sort extension.keyword

This returns the error

No TopN sorting encoder for type UNSUPPORTED

If I run the query:

from logstash-* | keep extension.keyword | sort extension.keyword

the data return successfully.

Logs (if relevant)

No response

[elasticsearchmachine]

Pinging @elastic/es-ql (Team:QL)

[elasticsearchmachine]

Pinging @elastic/elasticsearch-esql (:Query Languages/ES|QL)

[astefan]

The simplest mapping that generates this error is

{"mappings": {
    "properties": {
        "extension": {
          "type": "text",
          "fields": {
            "keyword": {
              "type": "keyword",
              "ignore_above": 256
            }
          }
        },
        "geo": {
          "properties": {
            "coordinates": {
              "type": "geo_point"
            },
            "dest": {
              "type": "keyword"
            },
            "src": {
              "type": "keyword"
            },
            "srcdest": {
              "type": "keyword"
            }
          }
        }
      }
}}